Data Action to create values for existing dimension members but yet no values

[ericliefke]

Hi all,

i am trying to create a Data action which creates a specific value (zero, not Null) for a given time horizont and for the members of each dimension I selected beforehand via prompt.

First approach:

MEMBERSET[d/Dim1]= %Paramater1%

MEMBERSET[d/Dim2]= %Paramater2%

etc...

Data([d/Measures] ="Measure1")=0

also etc...

This DA only writes back zeroes for already existing values.

My desire is to "fill in" the null values with zeroes in this case.

Any idea? TYIA

[William_Yu1 · Accepted solution]

Hi ericliefke, 

  You may try this: 

   Data([d/Measures] ="Measure1")= 1 - 1 

Best regards, William