DeepSee MDX Reference
Numeric Expressions
 [Next]
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

This section describes how to create and use numeric expressions in DeepSee MDX.
Details
In DeepSee MDX, a numeric expression can have any of the following forms:
Uses
You can use numeric expressions in the following ways:
Examples
This section shows examples of some of the less common kinds of numeric expressions. The first example shows that a member expression has a numeric value:
SELECT gend.h1.gender.female ON 0 FROM patients
 
                                    Female
                                        526
The next example is a variation of the preceding:
SELECT gend.h1.gender.female+100 ON 0 FROM patients
 
                                Expression
                                        626
As noted earlier, the value of a member expression depends upon the measure that is in use:
SELECT gend.h1.gender.female ON 0 FROM patients WHERE MEASURES.[avg age]
 
                                    Female
                                      37.23
Similarly:
SELECT gend.h1.gender.female+500 ON 0 FROM patients WHERE MEASURES.[avg age]
 
                                Expression
                                     537.23
The next example shows the numeric value of a dimension:
SELECT allerd ON 0 FROM patients
 
 
                                      1,000
As noted earlier, the value of such an expression depends upon the measure that is in use:
SELECT allerd ON 0 FROM patients WHERE MEASURES.[avg allergy count]
 
 
                                       0.99