Corporate Governance - Governance, Risk, and Compliance Topic for Oracle Applications - page 58

• Calendar Period : The account balance is the balance for a particular period
in the accounting calendar.
• Value Set Value : The code combination has a value for each segment in the
chart of accounts. The value must be a valid value in the value set for that
segment. The value set could be reused in other charts of accounts.
• Account Balance Fact : Next we work with the dimensional side of the
components. The center point here is the Account balances fact. These may
be actual values imported from the transactional system, official budgets,
or forecasts that may be created under a different scenario.
• Period Dimension : The account balance fact may be analyzed and
summarized by many dimensions. An important dimension is the period
dimension. Costs and revenues for the same period can be gathered to create
a projected Financial Statement for that period or collection of periods.
• Scenario Dimension : The financial planning process will test many different
scenarios before one of those scenarios is selected to be the plan that will
drive the enterprise and may be communicated. However, being able to see
the development of the final plan through various scenarios is an important
capability in being able to defend the final plan.
• Company Dimension : The company dimension is self explanatory. It is very
likely to be linked to the balancing segment in the transactional systems chart
of accounts.
• Account Dimension : The account dimension is self explanatory. The levels of
the dimension should reflect the hierarchy in the segment values themselves.
• Cost Center Dimension : The cost center dimension is self explanatory. The
cost center generally represents a department, although you may have cost
centers that exist purely for analysis purposes.
• Business Unit Dimension : The management dimension of your cube
may be a business unit or a division dimension that is closely aligned to
the management responsibility and reporting relationships. This could be
a dimension in its own right or it may be implemented in the balancing
segment or in the cost center segment. It would be very good practice to
break it out in the transformation to the cube.
• Ledger Dimension : The Ledger dimension is the boundary within which the
additivity of balances in the cube can be guaranteed. You have to think very
carefully if you want to add balances from different ledgers as to whether the
results will be meaningful or not.