Specifying formulas

In the Insert Function dialog box, you can specify any of the formulas supported by Application Studio.

We recommend that you use the Edit OLAP Formula wizard to insert and edit these functions:

To insert functions in the Edit OLAP Formula wizard.

To insert a formula with the Insert Function dialog box:

In Design Mode, click the cell in which to insert the formula.
Click Insert Function on the Objects tool bar.
Or select Insert > Function on the Standard tool bar.
See Enabling menus and toolbars.

The Insert Function dialog box is displayed. In the Categories column, the functions specific to Application Studio are in the categories Special and Properties.
Select the function to insert and click OK.
The function is displayed in the selected cell with place holders for each of the required arguments. For example, here are the place holders for a CELLGET formula:
=CELLGET( "database alias", "cube", "slice element dimension 1", ..., "slice element dimension N")
Specify each argument and press Enter.
For example, here is a completed CELLGET formula, with three slice elements specified:
=CELLGET("Best Practices OLAP","Analysis","[Product].[All Tires]","[Period].[All Years]","[Region].[All Regions].[North America]").

Note that the unique names of the elements are used, not their captions.