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.