Corporation Switch User Manual

5-10 Oracle Financial Consolidation Hub User's Guide
• Add dimension members to dimensions
• Search for, view, and update any existing members
A dimension is a classification scheme used to categorize or group business data. For
example, data can be grouped by the line item, product, geographical area, customer,
natural account, and time. A dimension contains dimension members. For example, the
Line Item dimension might have dimension members of Total Assets and Fixed Assets.
If you use Oracle General Ledger, then the segment values for the relevant charts of
accounts are automatically synchronized with Enterprise Performance Foundation as
dimension members. For more information on transferring segment values from Oracle
General Ledger, see Using Oracle General Ledger with Enterprise Performance
Foundation, page 5-17. If you do not use Oracle General Ledger, or if you need
additional dimension members for analytical or consolidation purposes, you can create
them using WebADI spreadsheet loaders. In addition, you can update existing
dimension members through the spreadsheet loaders.
See: WebADI Spreadsheets, page A-1
The spreadsheet loaders include columns for display code, name, description, and value
set. If you are working with the following dimensions, the spreadsheet loaders include
additional columns:
• Line Item - An additional column is available to select the account type
• Natural Account - An additional column is available to select the account type
• Company Cost Center Organization - Additional columns are available to enter the
company and cost center associated with each organization. Company is required
but cost center is optional.
This task cannot be used for the following situations:
• Creating, viewing, and updating members for the entity dimension. Entities are
handled through a separate Entity user interface.
See: Setting Up Entities, page 6-1
• Updating or creating members pulled through the Oracle General Ledger
integration. If a dimension member was created through the Oracle General Ledger
integration, do not update it. Also do not create new dimension members for a
value set that was created through Oracle General Ledger integration. Instead,
create the new values in Oracle General Ledger and rerun Oracle General Ledger
integration.
See: Using Oracle General Ledger with Oracle Enterprise Performance Foundation,
page 5-17
Some attributes for dimension members do not appear in the spreadsheet loader.
Financial Consolidation Hub automatically populates these attributes . To view the full