COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => SDK => Topic started by: andigrill on 14 Feb 2024 07:06:54 AM

Title: Extract MUNs from Content Store
Post by: andigrill on 14 Feb 2024 07:06:54 AM
Hello,

I would like to know if there is a way to extract all MUNs from one cube used in any report (Analysis Studio or Report Studio)
For example:
I want to have a list of all MUNs on Cube CUBE1 on DIMENSION1 on each Level
[CUBE1].[DIMENSION1].[DIMENSION1].[LEVEL1]->:[PC].[@MEMBER].[Value1]
[CUBE1].[DIMENSION1].[DIMENSION1].[LEVEL1]->:[PC].[@MEMBER].[Value2]
[CUBE1].[DIMENSION1].[DIMENSION1].[LEVEL2]->:[PC].[@MEMBER].[Value3]
...

As far as I know with BSP you can list all elements using this reference but not each element.