problem with converting a multiselect xml into a usable list (for an export process)

Hi all,

I am creating an export screen in DEPM V11, the user can multi select a period and i need to get a list of those periods to pass as a parameter to an Importmaster job.

using the action 'select element', I enable multiselect and push the action.results to a variable. The variable is created correctly, but i want to be able to get a list of these member and their descendants so that i can pass into an Importmaster script.

I have created a hyperblock and filtered it so only the base level members are selected - i want to push the base level members into a variable that i can then pass into an importmaster job.

i dont want to pass [period].[2022_01],[period].[2022_02] - i only want the 2022_01,2022_02 to be in my list.

Find more posts tagged with

Infor EPM Discussions

Comments

radek-kafka

Hi,

for this kind of conversion I'm using and "helper" list - another list (here named: lvCinnostSelected ) where source of it's content is:

="{ {AddCalculatedMembers(Descendants({"&MULTISELECTGETMEMBERSSIMPLE(ReportVariables.rv_MyMultiselecttXML.Text;",")&"}, 50, Leaves))} }"

And than I do:

=IF(ReportVariables.rv_MyMultiselecttXML.Text="";""; GETPROPERTYVALUES(ReportObjects.lvCinnostSelected.Listresult; "KEY"; ","))

It will produce in the cell comma separated list of OLAP elements that could than pass to script or whatever you want .. )

BR,

Radek

jens-marburger

Hi,

might be easier with an ROA() formula

=ROA("ALIAS","CUBE","[DIM]","MEMBER_NAME",ReportVariables.rv_multi.Text)

BR,

Jens

jens-marburger

Peter, in your case ReportVariables.rv_multi.Text = Action.result in the "select element" action

radek-kafka

In my case I'm returning all basic elements under selected.. So you can select 2023, Q4_2022 and it will produce 202210,202211,202213, 202301, ... 202312

That is what I have understood Peter was asking for. But you are right . ROA will do the stuff for us also in simple case.

Peter Chapman

Thanks Jens - the ROA wont work as i want to get the members that are potentially below the selected member (ie they select 2022 and 2023_Q1 - so i would need to return the base members of 2022 and the base members of 2023_q1

radek-kafka

Hi Peter .. that is exactly what my solution should do .. In the "helper" list you should enable exposing of intristic attribute KEY to have it output XML .. But 1st step is to have list of all descendants under the selection.

Peter Chapman

Thanks Radek for the inspiration!!!

got it working

I used the following code when creating the listviews. I n

="Generate({"&MultiSelectGetMembersSimple(ReportVariables.rv_xml_period.text,",")&"},Descendants([Period].CurrentMember, [Period].CurrentMember.Level, SELF_AND_AFTER))"

i then apply an attribute filter to only display N level members.

Receipt from Taxi.msg

Copyright © 2025 Infor. All rights reserved.