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

Cognos SSAS Cube Named Set hierarchical structure

Started by dbahiker, 22 Nov 2017 11:44:24 AM

Previous topic - Next topic

dbahiker

I was wondering if there is a way to create indentation or a new column from a SSAS data source Named Set on the rows? I don't want to create a crossjoin.

You can do it in Excel. By default, items from different levels will be displayed in separate fields in the hierarchy, and the named set replaces the current fields in the row or column area.
To display those items in the same field as other items, clear the Display items from different levels in separate fields check box. See screenshot attachment. Is there a function or something like this in Cognos Report Studio?