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.
(http://i53.tinypic.com/15q84g4.png)
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.