Selecting the Time Balance

  To select a time balance:

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 Accounts dimension.

3. Select the member.

4. Select the Account Info tab.

5. Locate the Time Balance group.

6. Select a Time Balance option:

   • None—The default value. Essbase rolls up parents in the time dimension in the usual way—the value of a parent is based on the formulas and consolidation properties of the children of the parent.

   • First—The parent value represents the value of the first member in the branch (often at the beginning of a time period).

   • Last—The parent value represents the value of the last member in the branch (often at the end of a time period).

   • Average—The parent value represents the average of the children values.

   • External source—In the drop-down list, select the column in the database that contains the desired time balance option.

   Note:

   If you set a time balance as first, last, or average, you must set a skip property to tell Essbase what to do when it encounters missing values or values of 0. See Selecting the Skip Option.

   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.

7. 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.