Creating Formulas for Aggregate Storage Databases

In aggregate storage databases, formulas must be written as numeric value expressions in the MDX language. Formulas are permitted only on members of dynamic hierarchies and on the accounts dimension. You can specify a solve order for formulas within a dimension.

Formulas are calculated only at retrieval time; calculated formula values are not stored.

  To create or edit formulas:

  1. Open an outline in edit mode. 

    The Outline tab is displayed.

  2. Right-click a member to which a formula is attached, and select Edit member properties.

  3. In the Member Properties dialog box, select the Formula tab.

  4. Following MDX syntax, enter a formula in the text box provided.

  5. Optional: Use a predefined template to generate your formula:

    1. Click MDX Templates.

    2. In ASO MDX Formula Templates, select a formula template from Select MDX Templates.

    3. Enter parameter information in the provided fields.

    4. Click Insert Formula.

    5. Optional: Perform additional edits to the generated formula in the text box.

  6. Click OK to save the formula.

Related Information