Filtering a hierarchy at a specific level

[jdmillar]

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

[Francis aka khayman]

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