Dimensions for Standard Balance Cubes
A balances cube consists of a set of defining business entities called dimensions. These dimensions are available for creating financial reports, Smart View queries, and allocations using multidimensional cubes.
The following table describes the dimensions and provides example values.
Dimension |
Description |
Examples |
---|---|---|
Accounting Period |
Based upon the calendar of the ledger or ledger set. Report on years, quarters, or periods. |
|
Ledger or Ledger Set |
Used to select a ledger for the reporting. Multiple ledgers may be in the same cube if they share a common chart of accounts. |
|
Chart of Accounts Segments |
Uses a separate dimension for each of the segments from the charts of accounts. Organized by hierarchy. A default hierarchy is provided that includes all detail segment values. Hierarchies published in the Publish Account Hierarchies user interface are included. |
|
Scenario |
Indicates if the balances represented are actual or budget amounts. Allocation-related dimensions are predefined members and required for allocation solutions. Allocation dimensions aren't used directly by end users. Budget scenario dimension members are user-defined in the Oracle Fusion Applications value set called Accounting Scenario. The dimension members appear in the cube after running the Create Scenario Dimension Members process. |
|
Balance Amount |
Indicates if the value is the beginning balance, period activity, or ending balance. Debit, Credit, and Net amounts are available for reporting. |
|
Amount Type |
Indicates whether the amounts represent Base, Period to Date, Quarter to Date, or Year to Date. |
|
Currency |
Used to select the wanted currency for the balances. |
|
Currency Type |
Used to select the currency type of the balances. |
|
Dimensions are predefined and new ones can't be added.