Returns the natural logarithm (base e) of an expression.
Ln ( numeric_value_expression )
| numeric_value_expression | A numeric value. |
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 |
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |