If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to make hiyerarchy report in Cognos 10

Started by cemuney, 24 Mar 2011 07:14:52 AM

Previous topic - Next topic

cemuney

Hi all,
I am using Sql Server Analysis Services 2008R2 Cubes as a datasource.
There are some hierarchies in my cubes.
Is it possible to dizayn reports by just dragdropping the hiyerarchy to the report.
This is sample form Excel2010 pivot table. In Cognos 10 i can also design the report.
But when i click the [2009] [January] Cognos shows only the [2009] [January] and the children of 2009 are displayed. Other years are disappears.
Thanks from now.


tjohnson3050

You are viewing the tree in member view.  Toggle the view by clicking the second icon from the left on top of the source pane.  You will then have more objects in the tree (hierarchy, level etc.) that you can drag on to the report.  When you drag the year level, all years will be displayed.