Blog Pro de Jean-Baptiste HEREN

Notes d'un consultant Freelance en Informatique

To content | To menu | To search

Cognos report studio : current member level in a hierarchy

Posted on Wednesday 03 November 2010, 18:02 - Décisionnel - Permalink

L'expression suivante renvoie niveau de profondeur du membre spécifié dans une hiérarchie.

ordinal (level(currentMember([My_Package].[My_Dimension].[My_Hierarchy])))

Post updated on Wednesday 03 November 2010, 18:02

Jean-Baptiste Heren

Author: Jean-Baptiste Heren

Stay in touch with the latest news and subscribe to the RSS Feed about this category

Be the first to comment on this article

Add a comment This post's comments feed

no attachment


You Might Also Like

result_crosstab.png

Cognos Report : Display a different measure in row for the aggregated column

Following tip is when you use a Relational Datamodel (DMR). In a Cognos Report crosstab, If You need to Display different measure in the aggregated column, you can do it using a simple if-then-else...

Continue reading

Cognos 8 - convert a member unique name from one hierarchy to another

If you need to build any report or Event studio Query using the same data from different packages; and you want to prompt just once. You can convert the member unique name from one hierarchy to...

Continue reading