Among the calculation types is a user-defined expression. It enables you to create calculations using the OLAP expression syntax, which includes the following elements:
The OLAP syntax is an extension of the SQL syntax. If you have used SQL analytic functions or row functions, this syntax will be familiar to you.
The easiest way to formulate an expression is to let Analytic Workspace Manager do the work for you. You can use the templates to create a similar calculation, and cut-and-paste the syntax into an expression.
To create an expression:
Open the Create Calculated Measure dialog box.
Select the calculation type that most closely matches the one you want to define.
Modify the template as desired.
Cut-and-paste the calculation from the Calculation box into a text editor.
Repeat these steps if your calculation uses two or more functions.
Modify the calculation as desired in the text editor. You can combine numeric operators, analytic functions, and single-row functions in a single calculation.
From the Calculation Types list, select Expression.
Cut-and-paste the calculation from the text editor into the Calculation box.