If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

missing hierarchy levels in Report Studio

Started by colt, 29 Jul 2011 07:32:10 AM

Previous topic - Next topic

colt

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 ?


bdbits

When you generate the cube, it will only include the levels that have associated facts. Does that explain your situation?

Arsenal

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