Returns the exponent of an expression; that is, the value of e (the base of natural logarithms) raised to the power of the expression.
Exp ( numeric_value_expression )
numeric_value_expression | A numeric value. |
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 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |