Search results for query: *

Hi people, I use MS Access database. For building a data warehouse, I have prepared all the primary key column (integer) following the recommendation of Kimball. That means I have a dimension table Country with attributes - country id - country name - country lf instead...

Hi, DrLex, I will give a short report about what I have so far. - I have created a self join in Impromptu and looked at it. Unfortunately, it doesn't look at all like your code. No similarity so far. - Then, I opened the IQD files in Transformer (got removed the error). The result is that I...

Hi DrLex, Thank you for your answer. Theoretically, I have a question to your explanation. You say- (If your customer dimension is truly exclusive, then you should be able to read the table as many times as you have levels, setting the level id appropriately.) This is what I thought to do...

Hi BlueBrand, can you please write in this forum how you did with your example more in detail? For example, how you aliased the table and how you did joins after the drLex's recommendation? I have exactly the same case. I have a self referencing table and wanna build in Transformer as Levels...

Hi drlex, I need also to use self join. But for that, I have to use impromptu. In transformer, I can't do self referencing table. Do I understand right? ras

Just in case there is someone who may face the same problem: I have tried several ways to solve the problem I posted here. The best way was to restart again and again with the dimension which makes problem. I removed all the other dimensions and created first the dimension which was not build...

Hi Draoued thank you first for your answer. I have checked that the lowest levels are marked as unique. But the iqds - I got my data sources from access database from the transformer directly. As I don't use impromptu, I don't have iqd for dimensions (here I wonder if I can create iqd for each...

Hi, I have a dimension which has difficulties to be created as dimension in a cube. My dimensions are Country, Year and Grouping Country - ctry_name Year - year Grouping -grp_cd -grp_name All the levels are well connected to the data sources and there was no error in generating...