ACOS(x)

Description:

This function returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi.

Syntax: ACOS (Number)

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

Remarks

• The number argument is compulsory.
• If you want to convert the result from radians to degrees, multiply it by 180/PI () or use the DEGREES function.
• Number is the cosine of the angle you want and must be from -1 to 1.

Example

The ACOS function can be used in any database where you have stored the cosine angles data and you want to convert that into an arc-cosine value, it is possible to do that with the help of this function. This function displays the arc-cosine value of the cosine angle that is the number parameter given to the function.

=ACOS (-0.5)	- Arccosine of -0.5 in radians, 2*pi/3 (2.09)
=ACOS (0.18)	- Arccosine of 0.18 in radians, 2*pi/3 (1.39)
=ACOS ("range")	- Arccosine of the number in that range in radians.

 

 

Let us take the example of a cube in PowerOLAP which has data which is the information about the cosine values of an angle. If in the same dimension in another member you want to display the arccosines in radians of the cosine angle, then it is appropriate to use the ACOS function to convert the cosine values into arc-cosine.

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 dimension.

 



The formula above writes values into the "TrigValData" cube to the "ArcCosine" member by calculating the ACOS for the number in the "Cosine" member of the "TrigValues" dimension.

The ACOS function takes a COSINE value which is a number given to the function as a parameter and then converts this into the ArcCosine value and the calculated result is written into the "TrigValData" cube in the "ArcCosine" member of the "TrigValues" dimension.