EXP (x)

Description:

This function returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm.

Syntax: EXP (Number)

• Number: Enter a number or a range in a PowerOLAP cube for which you want the exponential value.

Remarks

• The number argument is compulsory.
• To calculate powers of other bases, use the exponentiation operator (^).
• EXP is the inverse of LN, the natural logarithm of number.
• This is the number that is the exponent applied to the base e.

Example

The EXP function can be used in any database where you have stored a value for which you want to calculate the exponential value and it is possible to do that with the help of this function. This function displays the value which is e raised to the power of any number specified in a formula or as a range in a cube and this is the number that is the parameter given to the function.

=EXP (1)	-Approximate value of e (2.72)
=EXP (2)	-Base of the natural logarithm e raised to the power of (7.39)
=EXP (-1)	-Approximate value of e (0.37)
=EXP ("range")	-Exponential value of the number in that range.

 

Let us take the example of a cube in PowerOLAP which has data which is the information in numbers for which you want to calculate the exponential value. If in the same dimension in another member or in another dimension in another cube, you want to display the calculated exponential values for the number parameter, then it is appropriate to use the EXP function to calculate this result. In this case we can write a formula in the cube in PowerOLAP to pull in values from one member of a dimension of a cube and write them to the formula and derive the values for the other member of the same dimension, or you can even do this for a different dimension in a different cube.



The formula above writes values into the "TrigValData" cube to the "EXP" member by calculating the exponential value for the number in the "Number" member of the "TrigValues" dimension. The EXP function takes the "Number" member which is a number given to the function as a parameter and it converts this value to exponential as mentioned before, and the calculated result is written into the "TrigValData" cube in the "EXP" member of the "TrigValues" dimension.