Hi!
I need to create a organization hierarchy to my excel-report with a cubevalue/cubemember/cubeset function (see picture)
- How can I create this kind of hierarchy? I have tried [Organization].[Store].children and [Organization].[Store].members.
- This hierarchy should update if a new member is added (for example new organization part zzz3 is created/added in the middle of the year)
How can I create these?
I need to create a organization hierarchy to my excel-report with a cubevalue/cubemember/cubeset function (see picture)
- How can I create this kind of hierarchy? I have tried [Organization].[Store].children and [Organization].[Store].members.
- This hierarchy should update if a new member is added (for example new organization part zzz3 is created/added in the middle of the year)
How can I create these?
