On similar lines, i was trying to do the
On similar lines, i was trying to do the following:
I am trying to calculate the [Prior Bud Var] based on the version of the Budget Selected. The following code works great if the users picks either [Feb Budget] OR [Jan Budget] AS [Budget Ver]. However, when the users picks both, [Prior Bud Var] returns "blank" in the front end.
CREATE MEMBER CURRENTCUBE.[Measures].[Prior Budget] AS NULL;
CREATE MEMBER CURRENTCUBE.[Measures].[Prior Bud Var] AS NULL;
Scope([Measures].[Prior Budget], [Budget Ver].&[Feb Budget]);
This = ([Measures].[Budget], [Budget Ver].&[Jan Budget]);
End Scope;
Scope([Measures].[Prior Budget], [Budget Ver].&[Jan Budget]);
This = ([Measures].[Budget], [Budget Ver].&[Dec Budget]);
End Scope;
Scope([Measures].[Prior Bud Var], {[Budget Ver].&[Feb Budget],[Budget Ver].&[Jan Budget]});
This = [Measures].[Budget] - [Measures].[Prior Budget];
End Scope;