Create a Balances Cube

A balances cube stores financial balances in a multidimensional database for interactive reporting and analysis.

In this topic, you’ll see an example of how to create a General Ledger balances cube for your ledger, for example USFed1 US.

Before you start

Before you create a balances cube, you must ensure that your ledger is set up. You must also verify the account combinations set up for your chart of accounts. To view the account combinations, go to the Manage Account Combinations task in the Financial Reporting Structures functional area in the Functional Setup Manager.

1. In the Setup and Maintenance work area, go to the following:
   • Offering: Financials
   • Functional Area: General Ledger
   • Task: Review and Submit Accounting Configuration
2. Click the Scope link.
3. On Select Scope, from the Primary Ledger drop-down list, select Select and Add and click Apply and Go to Task.
4. On Manage Primary Ledgers, search for and select the USFed1 US ledger and then click Save and Close.
5. On Review and Submit Accounting Configuration, review the accounting details and then click Submit.

   A confirmation message appears, indicating that the Create Accounting Configuration process has been submitted.

6. Click OK in the Confirmation dialog box.
7. Access the Scheduled Processes work area from the Tools menu in the Navigator to verify that the Create Accounting Configuration process and its subprocesses completed successfully.
8. Restart your browser to review your newly generated balance cubes for your ledger in the Calculation Manager.