Get all base elements of a multiselect

gottesheim-daniela

Hello!

I've got a lookup where multiselect is enabled. Therefor users can select one or more elements. These elements can either be hierarchies or base elements. The result of the lookup is stored in a global variable, e.g.

[DBUYER]
Sum


[DBUYER].[Einkaeufer_nach_Name].[100_Berger_Manuela]


[DBUYER].[Einkaeufer_nach_Name].[100_Coric_Mario]

The elements [DBUYER].[Einkaeufer_nach_Name].[100_Berger_Manuela] and [DBUYER].[Einkaeufer_nach_Name].[100_Coric_Mario] are hierarchies and both consist of 2 base elements. So in total it are 4 base elements.

I now want to get a list of all base elements refering to the global variable where the multiselect is stored. The optimum would be to get a specific attribute for those 4 base elements. Is there any function that provides this output?

Best regards, Daniela

Peter Mayall

There is a way.  You create a hyperblock to get the elements with customer MDX:

="Generate({"&MultiSelectGetMembersSimple(GlobalVariables.gv_YourVar.Text,",")&"},Descendants([Your Dim].CurrentMember, 10, Leaves))"

Replace "GlobalVariables.gv_YourVar.Text" and "Your Dim" as appropriate. 

Then you can get the attribute or whatever you need to do.