Exp

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 )

numeric_value_expression A numeric value.

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:

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

Notes

See Also

Ln

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