I am browsing a cube on SSAS 2005 browser. I see the fact based on parent member and expanded it to next level. I can see the top 25 list of second level when I right click on the measure column and select "Show top 25".
But when I remove the parent member which is first level in the Hierarchy then the measure shows no data for the same top 25. But there is data. Instead of having the two levels in the same hierarchy when I update the dimension setting for ATTRIBUTEVISIBLE to TRUE and then when I directly pull in the same attribute which was in the level 2 in the hierarchy I am able to see the Measure showing me data for top 25. I am not sure whats wrong in the cube.
I am struggling with this issue since 5 days. Your inputs will be very helpful.
Thanks