Registering Enterprise Profitability and Cost Management Cubes, Application Settings, and Dimensions

Use these steps to register cubes, application settings, and dimensions for Enterprise Profitability and Cost Management applications.

Predefined Cubes and Dimensions

When you register an Enterprise Profitability and Cost Management application, the following cubes and dimensions are created automatically:

Cubes:

• PCM_CLC: In Enterprise Profitability and Cost Management, use this cube to run calculations.
• PCM_REP: In Enterprise Profitability and Cost Management, use this cube to view data and run reports.

Dimensions:

Dimension Name	Dimension Type	Valid Cubes
Account	Custom	PCM_CLC, PCM_REP
Entity	Entity	PCM_CLC, PCM_REP

You can delete these predefined cubes and dimensions, and you can define additional cubes and dimensions as needed.

To define cubes, application settings and register dimensions:

1. On the Cubes screen, click Add, and then enter the cube name.

   Note:

   The cube type is automatically set to ASO and cannot be changed.

   Add all the cubes used in the dimensions you are registering.

2. Define the Enterprise Profitability and Cost Management application settings:

   Field	Valid Values	Example
   Alias Tables	Enter dimension alias tables.	Default English Spanish
   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.	USD,CAD,INR

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. Note: Dimension Name is a display name in Oracle Enterprise Data Management Cloud only. The External Dimension Name gets exported to Enterprise Profitability and Cost Management.	Product The value you enter becomes the name of the viewpoint, node set, hierarchy set, node type and dimension in Oracle Enterprise Data Management Cloud. Note: You cannot use PCM_Balance or PCM_Rule as a dimension name.
   Dimension Description	Optionally enter a dimension description.
   Dimension Type	Select the dimension type: Custom (default) or Entity. Tip: Enterprise Profitability and Cost Management uses the Custom dimension type for the Account dimension.	Custom
   Allow Shared Nodes	Select if the dimension you are importing has shared nodes.	Select the check box
   Select the valid cubes for this dimension	Select all the cubes for the dimension. Use the back button to enter additional cubes if needed.	PCM_CLC, PCM_REP
   External Dimension Name	Enter the external dimension name.	Product

4. Click Next.
5. 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.

6. 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 Enterprise Profitability and Cost Management Dimensions.