Adding Formulas to Dimensions

A formula determines how Essbase Server calculates the relationships between members of an Essbase database.

For more information on formulas, see About Formulas.

For information on dimensions, see Dimensions Overview.

  To add a formula to a dimension:

  1. Access the dimension properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Dimension Properties Tabs.

  2. Select the Formula tab.

  3. In the Formula text box, type a formula.

    Note the following restrictions for formulas:

    • The length of the formula cannot exceed 64,000 characters.

    • Formulas in ASO (aggregate storage) models must be in MDX format.

    • Formulas in BSO (block storage) models must be in the standard Essbase calculation script format.

    Note:

    Formulas are not verified until the model is deployed.

  4. Click Apply.

    Note:

    To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.