COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: MikeG on 11 Dec 2014 10:06:40 AM

Title: Skip a Drill down level for a description attribute
Post by: MikeG on 11 Dec 2014 10:06:40 AM
Hi

I have 3 levels of drill down

Z1000   Salaries
D100     Other Salaries
A10       Overtime


I have a  top member and its description attribute on the report 
eg     Z1000   Salaries

want to drill down 2 levels to get A10 Overtime

I go into advanced drill down for the member and change it's expression on drill down to level 3

I get  'A10  Other Salaries'   ie the member has skipped a level but the description has just gone down one level

So I go in advanced drill down for the description lvl1 and change it's expression on drill down to description lvl3

I still get
A10  Other Salaries  . How can I make the description skip a level with the member ?

thanks
Mike