Hiding Last level in a Dimension

[bwalikar]

Hi All,

Need your help in Transformer.

I have the Product Dimension which goes down to Level 5 (Grain). I want the drill down capability to go down only till level 4. Possible option I found was to Suppress Level 5 in Categories window. When I do this I find issues with data aggregation i.e., Individual values do not add up the Total, though the Total value always remains constant. Do you have guys have suggestion on this ?

And how does Hide/Show feature work in Transformer ?

[bdbits]

There are multiple methods of limiting drill-down, and the method chosen has an affect on aggregation.

There is detailed information at http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cogtr.10.2.2.doc/c_categoryactions.html?lang=en.

[bwalikar]

Thanks :)