I have a dimension of legal entities, which has many levels within one hierarchy...i.e. is unbalanced.
This dimension is attached to a cube, which is published to Cognos 10.
I have a report which requires a prompt page, which is to only allow the end user to select the n-level elements from the dimension.
However, the prompt is displaying both the n-levels and the consolidations. I've temporarily added an attribute which is only populated for the n-levels in an attempt to filter on them, but this is not working in my prompt.
Has anyone experienced this challenge and how was it overcome.
Your help, as always, greatly appreciated.
x64bit 10.1.1, w2008R2 OS Enterprise Edition, 1TB HD, 72GB RAM, MS Excel 2007/10, Cognos 10 BI