Question Re: Parameters in data action in Technology Q&A

Parameters in data action

Ganjos — Wed, 04 Dec 2024 15:06:50 GMT

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

Re: Parameters in data action

William_Yu1 — Thu, 05 Dec 2024 05:32:17 GMT

Actually from your last screenshot that this parameter NOT used yet in the data action, I assume that's why it's not displayed in story through consumption.

Re: Parameters in data action

thomas_beck — Thu, 05 Dec 2024 06:03:37 GMT

Yes, I can confirm parameters that are not used are not shown during Starter Configuration as a selection is irrelevant to Data Action execution.

Re: Parameters in data action

Ganjos — Thu, 05 Dec 2024 09:39:23 GMT

It's not being used, but I can't add SourceMonth and TargetMonth as filters in the data action. Can I?

I need to copy Vencimento Base from one version to another and from one month to another, depending on the version. Therefore, I require four parameters. Do you have a solution?

Re: Parameters in data action

thomas_beck — Thu, 05 Dec 2024 09:55:22 GMT

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

Re: Parameters in data action

Ganjos — Thu, 05 Dec 2024 10:12:37 GMT

Hi,

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

Re: Parameters in data action

thomas_beck — Thu, 05 Dec 2024 10:17:55 GMT

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

Re: Parameters in data action

thomas_beck — Thu, 05 Dec 2024 10:18:54 GMT

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

Re: Parameters in data action

Ganjos — Thu, 05 Dec 2024 10:27:45 GMT

it worked thank you very much!

Re: Parameters in data action

Ganjos — Thu, 05 Dec 2024 11:09:53 GMT

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?

Re: Parameters in data action

thomas_beck — Thu, 05 Dec 2024 11:14:15 GMT

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

Re: Parameters in data action

Ganjos — Thu, 05 Dec 2024 11:39:27 GMT

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

Re: Parameters in data action

thomas_beck — Thu, 05 Dec 2024 12:09:08 GMT

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.

Re: Parameters in data action

Ganjos — Thu, 05 Dec 2024 12:24:10 GMT

Ok, i did it but appeared this error

Re: Parameters in data action

Ganjos — Thu, 05 Dec 2024 12:26:45 GMT

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

Re: Parameters in data action

thomas_beck — Thu, 05 Dec 2024 12:32:31 GMT

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.

Re: Parameters in data action

Ganjos — Fri, 06 Dec 2024 10:50:10 GMT

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.

Re: Parameters in data action

thomas_beck — Thu, 12 Dec 2024 06:40:23 GMT

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.

Re: Parameters in data action

Ganjos — Thu, 12 Dec 2024 11:34:07 GMT

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:

Re: Parameters in data action

thomas_beck — Thu, 12 Dec 2024 11:59:36 GMT

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.