Other (Advanced Mode) Type
The Advanced computed measures option allows you to specify a formula for computation of the measure. In order to enter the formula, it is assumed that the user is familiar with MDB specific OLAP functions.
There are two ways that you can enter a formula.
You can define the function/condition for a measure and/or dimension by entering the expression in the pane. It is not essential that you select the measure/dimension and the function in the order displayed. You can select the function and then proceed to specify the parameters, which can be either a measure or dimension or both.
You can define it by following the procedure mentioned below:
Selecting the Measure
- Click Insert Measure to open the Select Measure pop-up. The pop-up displays will display the Measure folder. Double-click the folder to expand the list of measures under it. Depending on the Information Domain you are logged in to, the measures for that domain are displayed.
- Click OK to select the measure selection. To close the pop-up without saving the selected measure option, click Cancel.
Selecting the Dimension
- Click Insert Dimension to open the Select Dimension pop-up. The pop-up displays will display the Dimension folder. Double-click the folder to expand the list of dimensions under it. Depending on the Information Domain you are logged in to, the dimensions for that domain are displayed.
- Click OK to select the dimension selection. To close the pop-up without saving the selected dimension option, click Cancel.
Selecting the Function
- Click Insert Function to open the Select
Function pop-up. Double-click the Functions
folder to expand the list of functions within in it. The functions available are
those specific to Essbase. The parameters for the function are displayed in the
Parameters pane.
Note:
The functions displayed are based on the OLAP type and therefore, vary for SQL OLAP and Essbase. - Click OK to select the function. To close the pop-up without saving the selected function option, click Cancel.