Search code examples
scopessasmdx

MDX Scope overwriting value

I am trying to overwrite the value of the member [Balance to Total] in two attributes using SCOPE. However, when I view the results in Excel they both have a value of 4. Why aren't they showing different values?

SCOPE ([Measures].allmembers);                   
        [Group].[Attribute1].&[Balance to Total] = 2;
        [Group].[Attribute2].&[Balance to Total] = 4;
END SCOPE;
Solution

  • I think that the FREEZE function solves my problem.