Use OLAPQuery functions to insert standard numeric functions in computed measure expressions. Numeric functions compute a new measure for each value associated with it. You can use two types of OLAPQuery functions in the OLAPQuery section:
Interactive Reporting Functions—Non-MDX functions that allow you to perform common mathematical computations in MDX. The % of Column, % of Row, and % of Total functions allow you to use only a measure name from the query (not all measures in the cube) as a parameter.
MDX functions—Standard mathematical functions that you apply to computed item expressions. Interactive Reporting supports a number of MDX functions. (For more information on MDX functions, consult your MDX documentation.)
The table below provides a quick reference to the commands available on the Query menu and lists any related shortcuts.
The following table lists the functions available in the OLAPQuery section.
Table 42. OLAPQuery Functions
To apply a data function:
Select OLAP, then Add Computed Item, and then click Functions in the Modify Item dialog box.
Select the Interactive Reporting Web Client or MDX function from the Functions list.
A description of the selected function is displayed below the Functions list and explains the type of calculation the function performs.
You can select any measure in the cube, not just a measure in the query. The Cube Hierarchy list shows the organization of the cube including both members and levels.
Some functions require that you specify a second measure to perform the calculation. See the specific function if you are required to specify a second measure.
Define the dataset to evaluate the function and click OK.
To add a member or level to the dataset from the Cube Hierarchy list, select a member or level, and click Add.
To remove a member or level from the dataset, select a member or level and click Remove.