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 · Accepted solution]

In order to use a distinct selection across multiple dimensions, you can add additional copy rule for your copy step - see below for Date:

[Ganjos · Accepted solution]

Hi,

I added, but i can´t add the Source Month into the copy rule, only the target month.

[thomas_beck · Accepted solution]

Please check the parameter configuration for sourceMonth - e.g. Cardinality needs to be set to "Single".

[thomas_beck · Accepted solution]

Here are all requirements towards parameters in copy rules: Type: Member Model: Default Model (NAME) Dimension: Date Cardinality: Single Allow "All Members": Deselected

[Ganjos · Accepted solution]

it worked thank you very much!

[Ganjos · Accepted solution]

Can i do the same with Advanced formulas? @thomas_beck

I want to calculate Vencimento Base for the target month and version, using values from the source version and source month. The parameters for the calculation are the same: SourceVersion, TargetVersion, SourceMonth, and TargetMonth. Do you have a solution?

[thomas_beck · Accepted solution]

Yes, this does work also in Advanced Formulas, something like DATA([d/Date] = %targetMonth%) = RESULTLOOKUP([d/Date] = %sourceMonth%)

[Ganjos · Accepted solution]

I did this:

I created the parameters the same way as in the other data action, but in the source and target, I can't select the parameters.

Created parameter

[thomas_beck · Accepted solution]

Your Target-Box also needs to contain the targetDate Parameter so you specify the context to be written to. Please note that "Level" needs to be set to Leaf in the parameter configuration as it is only allow to write to leaves.

[Ganjos · Accepted solution]

Ok, i did it but appeared this error

[Ganjos · Accepted solution]

Alright, I’ve set the correct hierarchy, and now there are no errors. I’m going to test it out.

[thomas_beck · Accepted solution]

Please select a specific hierarchy in the parameter configuration (I assume it is currently set to "Any"). Otherwise the system cannot determine the hierarchy to use for value help.

[Ganjos · Accepted solution]

Hi @thomas_beck 

It worked Thanks.

I need to select multiple months, not just one. Is there a way to do this? The 'Allow all Members' option is currently locked.