Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by 5395

  1. 5395

    dimension with integer id attribute

    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...
  2. 5395

    Self referencing table

    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...
  3. 5395

    Self referencing table

    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...
  4. 5395

    Self referencing table

    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...
  5. 5395

    Self referencing table

    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
  6. 5395

    tranformer: dimension misbuild in cube

    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...
  7. 5395

    tranformer: dimension misbuild in cube

    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...
  8. 5395

    tranformer: dimension misbuild in cube

    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...
See more

Part and Inventory Search

Back
Top