Show TOC

Remodeling an InfoCubeLocate this document in the navigation structure

Prerequisites

  • You have created an InfoCube and loaded data into it.

    Note

    If you need to perform a key figure operation (Add, Replace or Delete) and the InfoCube contains compressed and uncompressed requests, you need to compress all of the requests before you can proceed. Remodeling cannot be performed on a partially compressed InfoCube.

Procedure


  1. You can access InfoCube remodeling in the Data Warehousing Workbench under Administration . You can also access it from the InfoCube context menu in the InfoProvider tree by choosing Start of the navigation path Additional Functions -> Remodeling  End of the navigation path .

  2. Create a remodeling rule. Specify name and description for the remodeling rule, select an InfoCube, as required, and choose Create .

  3. Choose Add Operation to List. You can select one of the following options from the dialog box:

    • Add characteristic/key figure

    • Delete characteristic/key figure

    • Replace characteristic/key figure

  4. For the Add Characteristic and Replace Characteristic options, specify how you want to fill the new characteristic with data:

    • Constant: The system fills the new characteristic with a constant.

    • Attribute: The system fills the new characteristic with the values of an attribute of a characteristic contained in the same dimension. In the case of an SAP HANA-optimized InfoCube , the system fills the InfoCube with the values of an attribute of a characteristic from any dimension.

      Note

      For more information, see SAP HANA-Optimized InfoCube in http://help.sap.com.

    • 1:1 mapping for characteristic: The system fills the new characteristic with the values of another characteristic in the same dimension. In the case of an SAP HANA-optimized InfoCube , the system fills the InfoCube with the values of another characteristic from any dimension. You replace one characteristic with another, thereby adopting the value of the original characteristic.

    • Customer exit: The system fills the new characteristic using a customer exit. More information: Customer Exit in Remodeling .

  5. For key figures, the Constant and Customer exit filling methods are supported for Add Key figure and only Customer exit is supported for Replace Key figure.

  6. Choose Transfer .

  7. Repeat steps 3 and 4 until you have collected all changes. In the bottom half of the screen, you can make changes to the operations at any time. To do this, select the corresponding step in the upper half of the screen.

    You can delete an operation at any time using Remove Operation from the List.

  8. Save your entries.

  9. Choose Check. The system checks whether the operations are correctly defined and whether the relevant InfoObjects are available in the InfoProvider.

    The system also checks the compatibility of the filling method

    Example

    • If the filling method is 1:1 mapping, the system reads one single value from the old InfoObject and checks if this is a valid value for the new InfoObject without filling or changing master data.

    • If the filling method is Customer exit, the system passes one row of the source table to the customer exit and executes it to check if the output is received and compatible with the new InfoObject

  10. You can display a list of the objects affected by remodeling using Impact Analysis. These objects are deactivated during remodeling. You can make a note of the objects that you need to reactivate later.

  11. By choosing Schedule , you can either start remodeling immediately or schedule it for later. You can specify whether to execute the process in parallel by setting the Execute Steps in Parallel flag. Do not set this flag if your system does not have sufficient capacity.

  12. You can check the process in the monitor. More information: Monitor and Error Handling .

Results

You can now use the remodeled, active InfoCube.