Trigonometric Functions

AtScale supports the following MDX trigonometric functions in a calculated measure formula.

Function SignatureDescription
acos(numeric_expression)Returns the angle, in radians, whose cosine is the specified float expression.
asin(numeric_expression)Returns the angle, measured in radians, whose sine is the specified float expression.
atn(numeric_expression)Returns the measurement of the angle, in radians, whose tangent is the specified float expression.
cos(numeric_expression)Returns the cosine of the specified angle, which is in radians, as a float expression.
exp(x)Returns ex where e is the base of the natural logarithm.
sin(numeric_expression)Returns the sine of the specified angle, which is in radians, as a float expression.
tan(numeric_expression)Returns the tangent of the specified angle, which is in radians, as a float expression.

Example:

3959 * ACOS(COS((PI()/180) * [Y])
* COS((PI()/180) * [X])
* COS((PI()/180) * [CentralLat])
* COS((PI()/180) * [CentralLong])
+ COS((PI()/180) * [Y])
* SIN((PI()/180) * [X])
* COS((PI()/180) * [CentralLat])
* SIN((PI()/180) * [CentralLong])
+ SIN((PI()/180) * [Y])
* SIN((PI()/180) * [CentralLat]) )