Start of Content Area

Function documentation Remodeling InfoCubes  Locate the document in its SAP Library structure

Prerequisite

You have created an Infocube and loaded data into it.

If you need to perform Key figure operation (Add, Replace or Delete) and InfoCube contains few compressed and few 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's context menu in the InfoProvider tree by choosing   Additional Functions  Remodeling  .

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

       3.      Choose This graphic is explained in the accompanying text  (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, you have to 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 that is contained in the same dimension.

·         1:1 mapping for characteristic: The system fills the new characteristic with the values of another characteristic in the same dimension. You replace one characteristic with another for example, 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.

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

       5.      Choose Transfer.

       6.      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 This graphic is explained in the accompanying text (Remove Operation from the List).

       7.      Save your entries.

       8.      Choose  This graphic is explained in the accompanying text (Check). The system checks whether the operations are correctly defined and whether the relevant InfoObjects are available in the InfoProvider. Also, it checks the compatibility of the filling method. 

 

  EXAMPLE

·         If the filling method is 1:1 mapping then it will read one single value from the old Infoobject and check if this is an allowed value for the new Infoobject without really filling or changing master data.

 

·         If the filling method is Customer exit, then it will pass one row of the source table to the customer exit and execute to check if the output is received and is compatible with the new Infoobject.

       9.      You can display a list of the objects affected by remodeling using This graphic is explained in the accompanying text (Impact Analysis). These objects are deactivated during remodeling. You can make a note of the objects that you need to reactivate later.

   10.      By choosing Schedule, you can either start remodeling immediately or schedule it for later.

   11.      You can check the process in the monitor.

More information: Monitor and Error Handling.

 

Result

You can now use the Infocube in a remodeled and active form.

 

End of Content Area