1. Working with Planning
  2. Working With Strategic Modeling
  3. Working with Models
  4. Working in the Account View

Working in the Account View

When you open a model, it opens in the Account View, where you can view and manage the accounts and subaccounts in a model.

About Accounts, Subaccounts, and Account Groups

Account types include:

  • Input accounts—Manually enter financial data into Input accounts for historical and forecast periods. In forecast periods, use forecast methods or freeform formulas to calculate values. The forecast method you specify determines the format for the input data in forecast periods. For example, if Sales uses the Growth Rate forecast method, you enter input data as a growth rate into the forecast periods.

    For details about entering data in input accounts, see Entering Account Data.

  • Calculated accounts—Calculates values with formulas using output from other accounts. You can't edit formulas in calculated accounts; they are fixed to retain accounting integrity.
  • User-Defined Accounts—Defined in Oracle Smart View for Office. Includes Memo Accounts to create additional detail in the financial accounts, Custom Ratio accounts to create additional ratios for analysis, and Debt Covenant accounts to define measures within Custom Ratios testing against performance standards (debt covenants).

Subaccounts are used for additional input detail in main accounts. Subaccounts inherit attributes of main accounts in both historical and forecast periods. You can distinguish subaccounts because they have a colon in their account key.

Account groups are used to group accounts together to make them easy to find and display when doing data entry. Default account groups are inherited from the template. Administrators and modelers can create additional account groups. See Working with Account Groups.

Dataviews are used to filter the type of accounts that are displayed. Administrators and modelers can create and edit dataviews. See Working with Dataviews.

Strategic Modeling account numbers have up to three segments, separated by a decimal point or, for subaccounts, a colon:

  • Main account number (vxxxx). These accounts drive the accounting integrity of the model.

  • Related account number (vxxxx.xx)

  • Subaccount number (vxxxx.xx:xxxx or for a subaccount of a main account: vxxxx:xxxx)

For descriptions of the accounts, see Strategic Modeling Account Definitions.

About the Account View

In the Account View, you can:

  • Change the point of view: Select from the Scenario, Dataview, or Account Groups lists and then click Refresh Refresh icon.
  • Add and delete subaccount members in the account hierarchy. See Adding and Deleting Subaccount Members.
  • Calculate and save a model.
  • Perform analysis tasks using the actions available on the Actions menu.