Hello,
I have defined a cube in Transformer. One Dimension named B01Produkte contains the levels (top to down) Mandant, B01Produkt, CCArtikel2. When I create the categories in Transformer, everything looks fine and the categories were set correctly.
But when I open the package in Report Studio, then in Insertable Objects, I find the dimension B01Produkte, the hierarchy B01Produkte and only level Mandant. The levels B01Produkt and CCArtikel2 are not there.
To be sure, that I am accessing the latest version, I have changed name of this dimension - this is reflected correctly in Report Studio, but still the 2 levels are not there.
Can anybody help me track down the problem. What are possible reasons for this behaviour ?
When you generate the cube, it will only include the levels that have associated facts. Does that explain your situation?
bd bits is right. I bet that's what is happening.
What you can do is change the inclusion property of the levels. By default, Transformer sets it to "Only When Needed" which translates to what bdbits said - when a fact exists for this category, Transformer will include it in the cube. Otherwise, it won't even though the category will appear in your model.
Change the Inclusion propery of the level to Always and all the categories in that level will always appear irrespective of whether they have associated facts or no