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?