1. Database Administrator's Guide for Oracle Essbase
  2. Dynamically Calculating Data Values
  3. Using Dynamic Calculation

Using Dynamic Calculation

You can tag any member as Dynamic Calc, except the following members:

  • Level 0 members that do not have a formula

  • Label-only members

  • Shared members

Which members you choose to calculate dynamically depends on the database structure and on the balance between (1) the need for reduced calculation time and disk usage and (2) the need for speedy data retrieval for users. See Choosing Values to Calculate Dynamically.

In Outline Editor, you can see which members are Dynamic Calc. The following figure shows Dynamic Calc members.

Figure 22-1 Sample.Basic Outline Showing Dynamic Calc Members


This image shows an outline with Dynamic Calc members.

In Smart View, users can display visual cues to distinguish dynamically calculated values.

When developing spreadsheets that include dynamically calculated values, spreadsheet designers may want to use the spreadsheet Navigate Without Data option, so that Essbase does not dynamically calculate and store values while test spreadsheets are built.