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

    Additional Cubes Enabled

    		 Select the additional Consol cubes that you want to enable. You can enable Consol2 through Consol5 in any order. Consol3, Consol5

  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 Fusion Cloud Enterprise Data Management 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 Cloud EDM.

    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

    Select the valid cubes for this dimension

    (Custom dimension type only)

    Note:

    For each cube that you select, a set of cube-specific properties is created (for example, Plan Type).

    For Custom dimension types, select the cubes for the dimension.

    By default, the Consol cube is selected. You can clear that selection to create the dimension without cubes.

    		 Consol

    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 Simple Attribute.
      • 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 Attribute Dimension.
      • Enter an attribute dimension name.

        Note:

        The attribute dimension name is put into the Attribute Dim - name node data type property and the viewpoint for the attribute dimension is added to the default view for the application.
      • For Attribute Type, select Text, Numeric, or Date.

      See Understanding Attributes.

    • For registered dimensions:
      • Select Registered Dimension.
      • Enter an attribute name.

        Note:

        A node data type property is created with the name that you enter in order to reference the registered dimension.
      • Select the dimension that contains the attribute values that you want to reference from the Dimension drop down menu.

    Note:

    For simple attributes,attribute dimensions, and registered 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.