Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: jdmillar on 14 Jan 2014 10:05:27 AM

Title: Filtering a hierarchy at a specific level
Post by: jdmillar on 14 Jan 2014 10:05:27 AM
Hi all;

I'm a Report Studio newbie, so please bear with me :)  I'm working from a DMR model and want to filter a report to only show (for example) members from the first and second levels in a hierarchy, but without dragging specific elements to the report.  Can somebody shed some light on what I'm sure is a relatively straightforward question?

Thanks,
Jason
Title: Re: Filtering a hierarchy at a specific level
Post by: Francis aka khayman on 15 Jan 2014 01:10:44 AM
just drag the levels you need in your crosstab (i assume since you are using DMR)


Time Hierarchy
   Year
   Month
   Day


Report:

                                [Col1] [Col2]
[Year]   [ Month]     <measure>



Output: Level 1 and 2 only of Time Hierarchy shown

                                 Product   
2011       Jan              100
               Feb              200
               Mar              300
              ...etc
Text only | Text with Images