Registering Cubes, Application Settings, and Dimensions

Use these steps to register cubes, application settings, and dimensions from Planning applications.

To register cubes and define application settings:

  1. On the Cubes screen, click Add, then enter the cube name and then specify the cube type. Add all the cubes used in the dimensions you are registering.

    Note:

    The cube name is put into the Source Plan Type property and other related properties, such as Aggregation, Formula, and Data Storage.
  2. Define the Planning application settings.
    Field Valid Values Example

    Alias Tables

    Enter dimension alias tables.

    Default English Spanish

    Weekly Distribution Type

    Specify the weekly distribution type.

    Even

    Multi Currency

    Set this check box, if the Planning application supports multi-currency.

    Select the check box

    Hybrid Mode

    Set this check box if the Planning 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

    Currencies

    You must enter at least one currency code.

    USD, CAD, INR

    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.

    Channel

  3. 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. If this is different than the actual dimension in your external application, specify the external dimension name below.

    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 or User Defined.

    Account

    Allow Shared Nodes

    Select if the dimension you are importing has shared nodes.

     
    Select the valid cubes for this dimension Select all the cubes for the dimension. Use the back button to enter additional cubes if needed. Plan1 Plan2
    Enter the External Dimension name Optionally enter the external dimension name. This lets you enter a different value for the dimension name above.

    acc1

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

  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 Planning Dimensions.