If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Displaying All Members of a Dimension

Started by MB_DIAA, 05 Feb 2018 02:18:24 PM

Previous topic - Next topic

MB_DIAA

Hello,

I am working on a multidimensional report which uses an Essbase cube as a data source. The report has a dimension called "Departments" and within departments it breaks down by hierarchy all the way down to each individual department ID. I need to obtain that individual department ID but the issue is the dimension is structured in a way that the individual ID exists on different levels for different departments.

For example: I use a descendants([Departments],6] function and it returns maybe 30% of my individual ID's, the remainder are either at level 4,5, or 7. I have tried descendants([Departments],0, after self) hoping it would grab everything but instead it only returns the top level member (Departments). I am wondering if I am using the function incorrectly or if this is unique to the Cognos/Essbase interaction.