Ln

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

Syntax

Ln ( numeric_value_expression )

numeric_value_expression A numeric value.

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:

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

Notes

See Also

Log
Log10
Exp

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com