Exp

The MDX Exp function for Essbase returns the exponent of an expression; that is, the value of e (the base of natural logarithms) raised to the power of the expression.

Syntax

Exp ( numeric_value_expression )

Parameters

numeric_value_expression: A numeric value (see MDX Grammar Rules).

Notes

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

Example

The calculated member Index is created to represent e raised to the power of [Variance %]/100. In the example, [Variance %] divided by 100 is the numeric value expression provided to the Exp function.

WITH MEMBER [Scenario].[Index]
AS
 'Exp(
      [Scenario].[Variance %]/100
  )' 
SELECT
 {[Scenario].[Variance %], [Scenario].[Index]}
ON COLUMNS, 
  {[Market].children}
ON ROWS
FROM 
 Sample.Basic
WHERE 
  {[Sales]}

This query returns the grid:

Table 4-62 Output Grid from MDX Example

(axis)	Variance %	Index
East	10.700	1.113
West	10.914	1.115
South	3.556	1.036
Central	3.595	1.037