Print Page - Hiding Last level in a Dimension

Title: Hiding Last level in a Dimension
Post by: bwalikar on 23 Dec 2015 07:23:00 PM

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 ?

Title: Re: Hiding Last level in a Dimension
Post by: bdbits on 28 Dec 2015 10:08:26 AM

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

Title: Re: Hiding Last level in a Dimension
Post by: bwalikar on 28 Dec 2015 09:30:40 PM

Thanks :)

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: bwalikar on 23 Dec 2015 07:23:00 PM