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 |