Registering Financial Consolidation and Close Application Settings and Dimensions
Use these steps to register application settings and dimensions for Financial Consolidation and Close applications.
To define application settings and register dimensions:
- Define the Financial Consolidation and Close application settings:
Field Valid Values Example Multi-Currency
Set this check box if the application supports multi-currency.
Select the check box
Currencies
You must enter at least one currency code. The first currency that you enter will be set as the main currency by default.
USD,CAD,INR
Main Currency
Select one of the currencies that you entered in the currencies field. The default value is the first currency that you entered.
USD
Intercompany Enabled
Set this check box if the application supports intercompany transactions between entities
Select the check box
Multi-GAAP Enabled
Set this check box if the application requires reporting using multiple GAAP standards
Select the check box
Hybrid Mode
Set this check box if the application supports hybrid mode.
Note:
Select this check box to add the plan type-specific Solve Order properties to all BSO and ASO cubes. Clear the check box to add the plan-type specific Solve Order properties only to ASO cubes.
Select the check box
Extended Dimensionality Application
Set this check box if this is an extended dimensionality application. Extended dimensionality applications can have up to four custom dimensions in the external application instead of two.
Select the check box
Alias Tables
Enter dimension alias tables.
Default English Spanish
Additional Smart Lists
Enter the name of one or more smart lists. The smart list names you enter will be a selectable item in the
Smart List
property. Smart list values can be managed in the external application only.Note:
The smart list property will always haveCalculation Status
in the list of allowed values for Financial Consolidation and Close. Enter any additional smart lists in this field.Channel
-
Register the dimensions.
To register one or more dimensions, click Add, and then enter the following information:
Field Valid Values Example Dimension Name
Enter a dimension name.
Note:
Dimension Name is a display name in Oracle Enterprise Data Management Cloud only. The External Dimension Name gets exported to Financial Consolidation and Close.Financial Account
The value you enter becomes the name of the viewpoint, node set, hierarchy set, node type and dimension in Oracle Enterprise Data Management Cloud.Dimension Description
Optionally enter a dimension description.
Dimension Type
Select the dimension type: Account, Entity, Movement, or Custom.
Account
Allow Shared Nodes
Select if the dimension you are importing has shared nodes.
Select the check box
External Dimension Name
(Custom dimension type only)
If the dimension type is Custom, enter the external dimension name.
Note:
For Account, Entity, and Movement dimensions, the external name is always "Account", "Entity", or "Movement", and it cannot be changed. For Custom dimensions, you must enter an external name.Product
- Click Next.
- If the dimension type is Entity, Movement, or Custom, optionally add one or more attributes:
- For simple attributes:
- Select the simple attribute management style.
- Enter an attribute name.
- Enter all values you want to use for the attributes.
Note:
The attribute name is put into theAttribute - name
property and the values are put into a pull-down list.
- For attribute dimensions:
- Select the dimension attribute management style.
- Enter an attribute dimension name.
- For Attribute Type, select Text, Numeric, or Date.
Note:
The attribute dimension name is put into theAttribute Dim - name
property and the viewpoint for the attribute dimension is added to the default view for the application.
Note:
For both simple attributes and attribute dimensions, the attribute name cannot be the same as any of the predefined account names (Account, Entity, Movement) or any of the custom dimension names that you entered. Additionally, the name cannot be one of the predefined account attribute dimension names:
- Is CICTA Account
- CICTA Redirection Account
- Intercompany Account
- Is Plug Account
- Plug Account
- Intercompany Entity
- For simple attributes:
- Review the summary, and then click Apply.
The dimension and its data chain are created. The data objects are bound to the dimension and set to active status. You can now import dimension data, see Importing Financial Consolidation and Close Dimensions.