COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: eliza_jane on 05 Jun 2014 05:54:17 AM

Title: Hierarchize( , POST) equivalent for DMR
Post by: eliza_jane on 05 Jun 2014 05:54:17 AM
The requirement is to display the hierarchy level members in reverse order when the entire hierarchy is brought into the crosstab rows

Example:

Product Level Member
Product Type Level Member
Product Line Level Member

instead of

Product Line member
Product Type member
Product member

The hierarchize(hierarchy, POST) works for SSAS cube but is not supported for DMR.

Is there any other alternative to get the desired display with DMR as source?