1. Using Oracle Analytics Cloud - Essbase
  2. Create and Manage Cube Outlines Using the Web Interface
  3. Set Dimension and Member Properties
  4. Create Member Formulas

Create Member Formulas

On the Formula tab of the Member Inspector, you can create and edit member formulas for both block storage and aggregate storage cubes. These formulas are calculated through default cube calculations and calculation-script calculations.

You can construct block storage member formulas from operators, functions, dimension names, member names, substitution variables, and numeric constants. To write formulas for block storage outlines, a set of calculation functions and operators, known as the Calculator, or Calc, language, is provided. For descriptions of calculation commands and functions, see Technical Reference for Oracle Analytics Cloud - Essbase

Aggregate storage member formulas cannot be created using Calculator language. Instead, create them using Multidimensional Expression Language (MDX).

Let’s create an example member formula. Suppose you have a dynamic calc member called “Watchlist Products” and you want it to be the sum of products “100-10”, “200-10” and “300-10.”

  1. On the Applications page, expand <yourapplication> and select the Basic cube.
  2. Click the Actions menu and select Outline.
  3. Click Edit.
  4. Select the Product dimension, add a child called Watchlist_Products, and press the Tab key.
  5. Click menu Image of the outline menu icon. for Watchlist_Products and select Inspect.
  6. Select the Formula tab.
  7. In the member tree, in the left panel of the Formula Editor, drill into Product to find the first product member to add to your formula, “100-10.” Right click the member name and click Insert Name to insert it into your formula.
  8. Place the cursor after "100-10" and press the + key.
  9. Use the member tree to pick the next product member to insert, 200-10. Right click the member name and click Insert Name to insert it into your formula.
  10. Repeat for the last product member, 300-10 and put a semi-colon (;) at the end of the formula.

    The formula should look like this: "100-10"+"200-10"+"300-10";

  11. Click Verify and fix any errors.
  12. Click Apply and Close.
  13. In the Data Storage Type column for Watchlist_Products, select Dynamic Calculation.
  14. Click Save to save the outline.

Member formulas like the one you just created can also include Essbase functions. When using Essbase functions in member formulas, use the Function Name menu on the right side of the formula editor to find and add calculation functions the script. See the Function description under the menu to read descriptions of each function.

See Developing Formulas for Block Storage Databases in Designing and Maintaining Essbase Cubes.

To write formulas for block storage outlines, a set of calculation functions and operators, known as the Calculator, or Calc, language, is provided. For descriptions of calculation commands and functions, see Technical Reference for Oracle Analytics Cloud - Essbase.

Aggregate storage member formulas cannot be created using Calculator language. Instead, create them using Multidimensional Expression Language (MDX). See Aggregate Storage and MDX Outline Formulas in Technical Reference for Oracle Analytics Cloud - Essbase and Developing Formulas on Aggregate Storage Outlines in Designing and Maintaining Essbase Cubes.