Link to home
Start Free TrialLog in
Avatar of angupta
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.
Avatar of Reza Rad
Reza Rad
Flag of New Zealand image

you can use case expression for conditional expressions, look at here for example:
http://msdn.microsoft.com/en-us/library/ms722762%28v=VS.85%29.aspx

all types of mdx conditional expressions are here:
http://msdn.microsoft.com/en-us/library/ms711272%28VS.85%29.aspx
Avatar of angupta
angupta

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
Avatar of Reza Rad
Reza Rad
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial