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