Parameter for measures with cardinality "any"

[ThomasK]

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

[N1kh1l · Accepted solution]

thkarner

thkarnerI think for Measures currently SAC only allows a single cardinality for measure parameters. The only way you scope multiple measures in MEMBERSET is by fixed comma separated list

MEMBERSET [d/Measures]=("Measure1","Measure2","Measure3")

Br.

Nikhil

[ThomasK · Accepted solution]

Thank you. It seems as you described. If so, it´s quite unlogical because MEMBERSET allows to define multiple measures as fixed. Doing the the same with a parameter (to make the Data Action dynamic) seems not to be possible ...

[N1kh1l · Accepted solution]

thkarner

I understand your reasoning and feel there should not be any technical reason for Measure parameter not supporting many cardinality. May be you should raise an influence request or upvote any existing one.

Nikhil