Ln

Returns the natural logarithm (base e) of an expression.

Syntax

Ln ( numeric_value_expression )

Parameter	Description
numeric_value_expression	A numeric value (see MDX Grammar Rules).

Notes

Ln returns the inverse of Exp.
The constant e is the base of the natural logarithm. e is approximately 2.71828182845904.

Example

WITH MEMBER [Measures].[Ln_Sales]
AS
 'Ln([Measures].[Sales])' 
SELECT
 {[Year].levels(0).members}
ON COLUMNS, 
 {[Measures].[Sales], [Measures].[Ln_Sales]}
ON ROWS
FROM 
 Sample.Basic
WHERE 
  ([Market].[East], [Product].[Cola])

returns the following grid:

(axis)	Jan	Feb	...	Nov	Dec
Sales	1812	1754	...	1708	1841
Ln_Sales	7.502	7.470	...	7.443	7.518