Log
The MDX Log function for Essbase returns the logarithm of an expression to a specified base.
Syntax
Log ( numeric_value_expression [,base] )
Parameters
- numeric_value_expression
-
A numeric value or an expression that returns a numeric value (see MDX Grammar Rules).
- base
-
Optional. A number representing the base to use for the logarithm. If less than zero, zero, or close to 1, the Log function returns #MISSING. If omitted, the Log function calculates the base-10 logarithm. Log (Sales, 10) is equivalent to Log(Sales), and is also equivalent to Log10(Sales).
Example
Log(9,3)
returns 2
.