Adding Formulas to Members

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

For more information on formulas, see About Formulas.

For information on members, see Members Overview.

  To add a formula to a dimension:

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

  2. Select the Formula tab.

  3. Select an option to enter a formula:

    • Enter a formula in the Formula text box.

    • Select From External source and from the drop-down list, select the external data source column that contains the formula you want to use.

    Note:

    The length of the formula cannot exceed 64 KB.

    Note:

    For the member codes to use in external data sources, see “Using the Data Source to Work With Member Properties” and “Data Source Differences for Aggregate Storage Dimension Builds” in the Oracle Essbase Database Administrator's Guide.

  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.