There are two types of Oracle Fusion General Ledger Balances cubes: Standard Balances cubes and Average Balances cubes

The standard balances cube uses following eight dimensions:
1- Accounting Period: Based upon the calendar of the ledger or ledger set. Report on years, quarters, or periods
2- 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
3- 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
4- Scenario: Indicates if the balances represented are actual or budget amounts. Budget scenario dimension members are user defined in the Oracle Fusion Applications value set called Accounting Scenario and appear in the cube after running the Create Scenario Dimension Members process
5- Balance Amount: Indicates if the value is the beginning balance, period activity, or ending balance. Debit, Credit, and Net amounts are available for reporting
6- Amount Type: Indicates whether the amounts represent Base, Period to Date, Quarter to Date, or Year to Date.
7- Currency: Used to select the desired currency for the balances
8- Currency Type : Used to select the currency type of the balances


Dimensions are seeded and new ones cannot be added


Regards,
Rohit

Thank you. Also, do you know are there any study questions or practice tests available to use to study for the Fusion certificate?





From: Apps2Fusion Discuss [mailto:discuss@apps2fusion.com]


Sent: Monday, November 23, 2015 11:40 AM

To: Robinson, Grant <Grant.Robinson@dhgllp.com>

Subject: [#329]: New reply added - Essbase











Oracle Training Experts






Rohit Sharma replied to the discussion
Essbase






There are two types of Oracle Fusion General Ledger Balances
cubes: Standard Balances cubes and Average Balances cubes



The standard balances cube uses following eight dimensions:

1- Accounting Period: Based upon the calendar of the ledger or ledger set. Report on years, quarters, or periods

2- 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

3- 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

4- Scenario: Indicates if the balances represented are actual or budget amounts. Budget scenario dimension members are user defined in the Oracle Fusion Applications value set called Accounting
Scenario and appear in the cube after running the Create Scenario Dimension Members process

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

6- Amount Type: Indicates whether the amounts represent Base, Period to Date, Quarter to Date, or Year to Date.

7- Currency: Used to select the desired currency for the balances

8- Currency Type : Used to select the currency type of the balances





Dimensions are seeded and new ones cannot be added





Regards,

Rohit




You may view the discussion by clicking on the button below.


















Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified
that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above
immediately and permanently delete this message from your inbox. Thank you for your cooperation.