Parameters in data action

[Ganjos]

Hi,

I’m working on a project where I want to trigger a data action with the following parameters: source version, target version, source month, and target month. The objective is to allow users to copy data from one version to another and choose the desired source and target month.

However, when I try to execute the data action in the story, only three parameters appear: source version, target version, and source month. The target month parameter is missing.

I’m attaching three screenshots: one showing the parameters, another showing the data action configuration, and a third showing the story interface with only three parameters visible.

How can I ensure all four parameters, including the target month, are displayed?

Thanks in advance,

Ganjos

[thomas_beck]

Hi @Ganjos 
Using multiple targets via parameter cannot be done within the DATA-statement. There is however a way to do so via specifying a memberset (line 1) outside of the actual instruction (line 2). The members filter will then automatically applied to the DATA-statement:


Please remember to change the parameter cardinality for targetMonth from Single to Any.

[Ganjos]

Hi @thomas_beck 

i did that as you said butit appear an error, but appeared the following error:

This is my code:

MEMBERSET[d/Date]=%TargetMonth%
DATA([d/Measures] = "VB", [d/Date] = %TargetMonth%) = RESULTLOOKUP([d/Measures] = "VB", [d/Date] = %SourceMonth%, [d/Version] = %SourceVersion%) * ( RESULTLOOKUP([d/Measures] = "perce_aumento_VB", [d/Version] = "public.Actual", [d/Date] = "202401") + 1 )

Configuration of the parameter:

[thomas_beck]

Please remove the targetMonth parameter from your data statement, it should be DATA([d/Measures] = "VB") only. The target is now already defined and set by your Memberset-Statement.

[Ganjos]

Finally worked, thanks very much, and thanks for your patience 🙂

[Bernardo_Santos1]

Hi @thomas_beck, i have question, if i wanted to the this copy step but, many to many, how would i do it?
I want this action, because when i copy my months to planning months, i want to do it instantly selection them all, and not doing it one by one

[thomas_beck]

Hi @Bernardo_Santos1, you can do this via an Advanced Formula (e.g. via using dimension properties to map month to planning month) or X-Model Copy Step (same source and target model, map each month to planning month). For the regular copy step this is not possible to map across different dimensions.

[Bernardo_Santos1]

Hi again @thomas_beck, in what form could i use the Advanced data action, iam asking this because the way the X-Model Copy Step works, it is not the way i want and i cant achieve the result i want with this resolution