Account Dimension

The Account dimension represents a hierarchy of natural accounts. Accounts store financial data for entities and scenarios in an application, and provides the Account properties for Income Statement Accounts. Each account has an Account type, such as Revenue or Expense, that defines its accounting behavior. Every application must include an Account dimension.

The Account dimension stores:

  • Trial Balance Chart of Accounts or Book Balance accounts
  • Tax Accounts for calculation of a tax provision or Country-by-Country (CbCR) report
  • Permanent or Temporary Differences
  • R & D and other credits
  • Net operating losses
  • Additional Provision items

Account Dimension

To define an Account Dimension:

  1. From the Home Page, select Applications, then Overview, and then the Dimensions tab.
  2. Click Account to display the Account dimension properties.
    Complete the Account properties.
  3. Click the Edit Dimensions Properties tab Edit Dimension Properties tab.
  4. Select the appropriate optional properties for your application:
    • Enter a Description for the Account dimension.
    • Select an Alias Table, if available.
    • Enter an Alias name for the Account dimension.
    • Select Two Pass Calculation.
    • Check to Apply Security.
  5. Select the type of Data Storage to be applied to the dimension:
    • Label Only
    • Never Share
    • Dynamic Calc (Used for Parent members)
    • Dynamic Calc and Store
    • Store (Used for Base members)
  6. Under Display Option, select the option you want to display on the report: the Member Name or Alias in reports.
    • Member Name
    • Alias
    • Member Name:Alias
    • Alias:Member Name
  7. Select Hierarchy Type, if available.
  8. Under Cube, select which cubes you want to use. You can use Consol, Rate or CbCR.
  9. Optional: Under Custom Attributes, under Actions, select Edit to modify the custom attribute, or Delete to remove the attribute.
  10. Under Custom Attributes, click Create to add a new custom attribute. Enter a name for the attribute, and select the Data Type.
    Enter the name and data type to create a new custom attribute.
  11. Click Done.