MDCalculationFormulaFunctionCall

Description

The MDCalculationFormulaFunctionCall enumeration contains the types of functions, which can be used in the formula as an operand. Detailed description of functions is given in the Special Functions section.

It is used by the following properties and methods:

IMDCalculationFormulaFunctionCall.FunctionCall.

Available Values

Value	Brief description
0	None. Function is not set.
17	Iif. The Iif conditional operator.
20	Nz. The Nz function.
21	Power. The Power function.
53	Min. The Min function.
54	Max. The Max function.
72	Shift. The Shift function.
78	Abs. The Abs function.
80	Trunc. The Trunc function.
81	Round. The Round function.
88	Check. The Check function.
89	MMin. The MMin function.
90	MMax. The MMax function.
91	Exp. The Exp function.
92	Ln. The Ln function.
93	NoData. The NoData function.
94	MAvg. The MAvg function.
95	IsNull. the IsNull function.
96	Dmin. The Dmin function.
97	Dmax. The Dmax function.
98	Dmedian. The Dmedian function.
99	DSum. The DSum function.
100	DCnt. The DCnt function.
101	DCntD. The DCntD function.
102	DAvg. The DAvg function.

Comments

Function use constraints:

Working with sets is supported for the Microsoft SQL Server, Teradata and Oracle DBMS.
The Dmedian function is relevant only for the Oracle DBMS version 10.2 or later.
If source cube coordinates used as function parameters for working with sets are calculated, that is, formulas are set for them in the multidimensional calculation that uses the Consider Dependencies between Formulas checkbox, function with a set results in 0.