angupta
asked on
Calculated Member MDX Expression Syntax
I am trying to build a calculated member based on logic that depends on values for a given dimension attribute. How would I go about building the expression? For example if a given attribute value is 'A' then I want to count an existing measure towards this calculated member. Any sample code would be helpful.
all types of mdx conditional expressions are here:
http://msdn.microsoft.com/en-us/library/ms711272%28VS.85%29.aspx
http://msdn.microsoft.com/en-us/library/ms711272%28VS.85%29.aspx
ASKER
These examples use measures only, I need to use attribute values in the case statement. I tried doing this before however I am unable to read in the values the attributes.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://msdn.microsoft.com/en-us/library/ms722762%28v=VS.85%29.aspx