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

Levels are missing in cube

Started by cognosun, 04 Sep 2012 01:56:58 AM

Previous topic - Next topic

cognosun

There is a Cube in which I have one dimension with 3 levels in it.

If I Publish this Cube and start accessing it in Analysis Studio...and click ( dropdown) on that one dimension I'm seeing the third level details in it.

I'm confused that why transformer is not showing me first 2 levels (without giving any error in .mdl) in Analysis Studio.

Any idea on this....

Thanks in Advance
Joys

MFGF

Have you defined any dimension views in Transformer that cloak the levels? Does the dimension have an alternate drill path with just the lowest level in it and that's what you are seeing in Analysis Studio? How does the dimension appear if you open the package using Query Studio - are all levels present?

MF.
Meep!

cognosun

Hi MF,

Please find my answers..

Have you defined any dimension views in Transformer that cloak the levels? >>
>> Yes.

Does the dimension have an alternate drill path with just the lowest level in it and that's what you are seeing in Analysis Studio?
>>Yes

How does the dimension appear if you open the package using Query Studio - are all levels present?
>> Yes we can see all levels in Query Studio as expected

MFGF

Hmmmm. That sounds a little worrying. If you can see all levels in Query Studio but only the lowest level members in Analysis Studio, somethingis screwy somewhere. What do you see in Report Studio - you have the option of seeing both a structural view of the package (as in QS) and a member based view too (as in AS). I would be interested to hear what is visible there.

I guess to debug this, you may need to experiment a little. Try creating another version of the cube with no dimension views and see if this makes a difference. If not, try taking out the alternate drill paths and see if that works. Once you have an idea of what's behind the issue, we can try to figure out why it's happening.

Cheers!

MF.
Meep!