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.
here's a post from IBM.
Check if this may help.
https://www.ibm.com/developerworks/data/library/cognos/reporting/dimensional_queries/page624.html (https://www.ibm.com/developerworks/data/library/cognos/reporting/dimensional_queries/page624.html)