Ranking in Cognos Crosstab Report for Dimensional Modelling

Create a simple crosstab report using GO Data warehouse (Analysis) package.

Use “Product Line” & “Branch Region” from “Promotion” namespace as rows & Year as column with “Revenue” as measure.

Now create a data item “Rank” to find out the ranking of Revenue for each Line & branch region.

Expression for Rank data item should contains:

rank(currentMeasure DESC TUPLE [2013] WITHIN SET [Product line],[Branch region])

It will rank the measure accordingly for 2013 year.