Selecting a Time Balance

  To select a time balance:

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

2. Select the accounts dimension.

3. Select the Account Info tab.

4. Locate the Time Balance grouping.

5. Select a Time Balance option:

   • None—The default value. When you set the time balance property as none, 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—Set the time balance as first when you want the parent value to represent the value of the first member in the branch (often at the beginning of a time period).

   • Last—Set the time balance as last when you want the parent value to represent the value of the last member in the branch (often at the end of a time period).

   • Average—Set the time balance as average when you want the parent value to represent the average of the children values.

   • Existing—Use the existing time balance

   Note:

   If you set a time balance other than None, 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.

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