Specifying formulas

In the Insert Function dialog box, you can specify any of the formulas supported by Application Studio. You can also insert formulas manually. Formulas in text objects must be specified manually.

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

  • ROC
  • RWC
  • ROA
  • RWA
  • ROK
  1. In Design mode, click the cell in which to insert the formula.
  2. Click Insert Function on the Objects tool bar.
    Or select Insert > Function on the Standard tool bar.

    The Insert Function dialog box is displayed. In the Categories column, the functions specific to Application Studio are in the categories Special and Properties.

  3. 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( "data connection", "cube", "slice element dimension 1", ..., "slice element dimension N")
  4. Specify each argument and press Enter.
    For example, here is a completed CELLGET formula, with three slice elements specified:
    =CELLGET("BestPracticesOLAP","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.