In Calculation scripts, we are using ALTER CUBE script twice updating two dimensions to assign default member for both these dimensions
Dimension 1-Time - Default Member = TimeMonthHierarchy Current Month
Dimension 2- StatusCode - Default Member = C+S
1) Now when I query cube using Base Measure, StatusCode (with Default Member), and TimeMonthHierarchy month attributes it works fine.
2) When I query cube using Base Measure, StatusCode (With default member), and Month Attribute of the time dimension it give measure value as current month measure value for all the months. It is not able to overwrite the default member of the time dimension.
3) When I use calculated measure, and Month attribute and StatusCode(default member) it works fine.
It seems when I use base measure it is not able to overwrite both the dimensions default member but only one which is later in the calculation script. When I use calculate measure it is able to overwrite both the dimensions default member.
Why this behavior, please have your inputs on this. Thanks.
View Complete Post