Trigonometric Functions
AtScale supports the following MDX trigonometric functions in a calculated measure formula.
| Function Signature | Description |
|---|---|
| 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]) )