Ln
The MDX Ln function for Essbase returns the natural logarithm (base e) of an expression.
Syntax
Ln ( numeric_value_expression )Parameters
- 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
The following MDX query:
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 output (truncated):
Table 4-110 Output Grid from MDX Example
| (axis) | Jan | Feb | ... | Nov | Dec |
|---|---|---|---|---|---|
| Sales | 1812 | 1754 | ... | 1708 | 1841 |
| Ln_Sales | 7.502 | 7.470 | ... | 7.443 | 7.518 |