Skip to Content
0
Sep 12, 2023 at 11:19 AM

Parameter for measures with cardinality "any"

51 Views

Hi experts,

it is possible to define a parameter for a measure (of a new model) with cardinality "any" (=parameter with multiple measures)

I´m using an Advanced Formula Step to manipulate data and would like to apply those (complex) steps for all measures defined in the parameter.

The question is: How could the multi-measure parameter be used?

Not possible options are:

MEMBERSET [d/Measures] = %Measure%
MEMBERSET [d/Measures] = BASEMEMBER([d/Measures], %Measure%)

IF [d/Measures] = %Measure% THEN
IF [d/Measures] = BASEMEMBER([d/Measures], %Measure%) THEN

FOREACH [d/Measures]

Any ideas?

Thank you, Thomas