User's Manual

5-16 Oracle Financial Consolidation Hub User's Guide
• Data Submission Trial Balance Template - To view the current data in Enterprise
Performance Foundation for an entity. This may differ from the Data Submission
Load Data Template because it represents the cumulative effect of all data
submissions for a given entity in a given period.
• Hierarchy Listing Template - To view a consolidation hierarchy.
• Intercompany Matching Template - To view intercompany balances eliminated
during a consolidation run.
• Value Set Map Validation Template: To view the values mapped in an entity's local
chart of accounts to the consolidation chart of accounts.
• Write back to General Ledger Template: To view the balances of an adjustment
written back to Oracle General Ledger.
Note: You can use the default report templates as a baseline to create
reports with customized formatting, but you cannot modify the default
report templates.
See: Viewing Reports, page 18-1
Task 12: Setting Up Analytical Reporting
You must complete Task 12 before using analytical reporting. Task 12 enables you to
use and view your consolidated results in an OLAP environment.
Specify a data table in Enterprise Performance Foundation. This table is used as an
interface table to move consolidation results into analytical reporting. When you run
consolidation, the results are pushed into the data table. Analytical reporting can then
pull the consolidation results from the table.
Note:
Ensure that the data table is not being used by any other
applications.
Optionally specify a line item hierarchy in Enterprise Performance Foundation. If you
have Internal Controls Manager integration enabled, it will use this line item hierarchy.
See:Integrating with Internal Controls Manager, page 22-1.
You may also have to provide mappings between Financial Consolidation Hub and
analytical reporting. The Created by Object dimension is not supported in analytical
reporting. Thus, in Task 1, if you selected Created by Object column to be available as a
reporting dimension, you must now map to use for these columns. For example, map
the Object dimension to User-Defined Dimension 1 hierarchies should be created on the
user defined dimensions selected.
See: Setting Up Analytical Reporting, page 19-1.