Translate

Hierarchize () function in Cognos Dimensional Reporting

This function is used to arrange the members of a set in their natural order. For example, observe the order of the members in “Order method type” level.             


The natural order of the members is: Fax, Telephone, Mail, E-mail, Web, Sales visit, Special.

Let’s create a simple report using Hierarchize function.

Syntax:
Hierarchize (set_exp)
or
Hierarchize (set (members))
or
Hierarchize (level)

Steps:
1.       Take a list and insert Order method type level.
2.       Run the report.


3.       Delete the Order method type column and insert a Query Calculation with below expression.
Hierarchize (set ([Web],[Telephone],[Special],[E-mail],[Fax],[Mail],[Sales visit]))

4.       Run the report.


In the above example, though we created a set of members with irregular order, they are sorted in the natural order in the output.

5.       Change the expression as follows.
Hierarchize (set ([Web],[Telephone],[Special],[E-mail],[Fax],[Mail],[Sales visit]), post)

6.       Run the report.



Now, the order is reversed.