1. Administering and Working with Oracle Enterprise Data Management Cloud
  2. Administration
  3. Working with Financial Consolidation and Close Applications
  4. Registering Financial Consolidation and Close Applications
  5. Registering Financial Consolidation and Close Application Settings and Dimensions

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:

  1. 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 have Calculation Status in the list of allowed values for Financial Consolidation and Close. Enter any additional smart lists in this field.

    Channel

  2. 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
  3. Click Next.
  4. 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 the Attribute - 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 the Attribute Dim - name property and the viewpoint for the attribute dimension is added to the default view for the application.

      See Understanding Attributes.

    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
  5. 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.