1. Using General Ledger
  2. Overview of Oracle Essbase Balances Cubes

Overview of Oracle Essbase Balances Cubes

Oracle Essbase is embedded within Oracle General Ledger and provides multidimensional balances cubes. Every time a transaction or journal is posted in General Ledger, the balances cubes are updated at the same time.

The flowing table lists and describes Essbase Dimensions and provides examples of dimension members.

Dimension

Description

Example

Accounting Period

Based upon the calendar of the ledger or ledger set. Report on years, quarters, or periods.

  • 2012

  • QTR-1

  • JAN-12

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.

  • InFusion North America Ledger Set

  • InFusion US Primary Ledger

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.

  • Company: InFusion America: 101

  • Cost Center: Sales: 400

  • Account: Cash: 1110

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 Accounting Scenario value set and appear in the cube after running Create Scenario Dimension Members process.

  • Budget 2012

  • Actual

  • Forecast 2013

Balance Amount

Indicates if the value is the beginning balance, period activity, or ending balance. Debit, Credit, and Net amounts are available for reporting.

  • Beginning Balance (DR, CR, or Net)

  • Period Activity (DR, CR, or Net)

  • Ending Balance (DR, CR, or Net)

Amount Type

Indicates whether the amounts represent Base, Period to Date, Quarter to Date, or Year to Date.

  • Base

  • PTD: Period to Date

  • QTD: Quarter to Date

  • YTD: Year to Date

Currency

Used to select the wanted currency for the balances.

  • All ISO Currencies

  • USD: US Dollar

  • JPY: Japanese yen

Currency Type

Used to select the currency type of the balances.

  • Total

  • Entered

  • Converted From (for each ISO currency)