How to create member with children?

Dear There,

I need to create member with children in simple hierarchy. Like the default one with all members in collapse. How can I create a member with selected entities and in the same format? Thanks…

Leon Li

Hi @Leon,

There are two ways how to group members in the dimension; one way is using operand “+” which results as one member without an option to expand it and see members of which it consists.

Recommended option is using function Aggregate() to group dimension members. This way you will get one row which gets a collection of all listed members, and you will be able to expand it to each member (engineer).

Please see the documentation where is an example of how to group members using Aggregate():

Zane /

A post was split to a new topic: How many days on average were spent in each of the transition status