LOG10 (x)

Description:

This function returns the base-10 logarithm of a number.

 

Syntax: LOG10 (Number)

• Number : Enter a number or a range in a PowerOLAP cube for which you want the Base-10 logarithm value.

Remarks

• The number argument is compulsory.
• This is the positive real number for which you want the base-10 logarithm.

Example

The LOG10 function can be used in any database where you have stored a value for which you want to determine the BASE-10 logarithm value. Here it is possible to do that with the help of this function. This function displays the value which the base logarithm value of the number specified in a formula or the range in the cube and this is the number that is the parameter given to the function.

=LOG10 (86)	-Base-10 logarithm of 86 (1.93)
=LOG10 (10)	-Base-10 logarithm of 10 (1)
=LOG10 ("range")	-Base-10 logarithm of the number in the 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 LOG10 value. If in the same dimension in another member or in another dimension in another cube, you want to display the BASE-10 logarithm values for the number parameter,then it is appropriate to use the LOG10 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 "LOG10" member by calculating the base-10 logarithm value for the number in the "Number" member of the "TrigValues" dimension. The LOG10 function takes the "Number" member which is a number given to the function as a parameter and it converts this value to its base-10 logarithm and the calculated result is written into the "TrigValData" cube in the "LOG10" member of the "TrigValues" dimension.