Before the release of SAP BI 7.0, in the previous version 3.x; we were not able to redesign the info cubes without deleting the existing data from the info cube. We had to delete all the data, modify the cube & then re-load the data again. But with the release of 7.0; the concept of Remodeling introduced as a feature to change the design of an info cube without deleting the Existing Data.
Before starting with the steps of Remodeling, I would like to mention the Dos & DONTs –
No data loading should be in process :
After remodeling, check all the BI objects that are connected to the InfoProvider like transformation rules, MultiProviders, DTPs have been deactivated. You have to re-activate these objects manually.
The remodeling makes existing queries that are based on the InfoProvider invalid. You have to manually adjust these queries according to the remodeled InfoProvider.
You cannot replace or delete units. This avoids having key figures in the InfoCube without the corresponding unit
Following are the steps to be followed :
Go to the context menu of Info cube that is to be redesign, select Remodeling as shown in fig. or select the Administration tab from the Left Most Area. There you can select Remodeling or can go direct to the T-Code RSMRT.
Also remember to activate the Transformation as well as the DTP of the Info Cube. Now there you can map the new Info Objects in the transformation but no need to upload the whole data again.
In the similar way, we can delete the Characteristics from the info cube without deleting the existing data into the Info Cube.
Before starting with the steps of Remodeling, I would like to mention the Dos & DONTs –
No data loading should be in process :
After remodeling, check all the BI objects that are connected to the InfoProvider like transformation rules, MultiProviders, DTPs have been deactivated. You have to re-activate these objects manually.
The remodeling makes existing queries that are based on the InfoProvider invalid. You have to manually adjust these queries according to the remodeled InfoProvider.
You cannot replace or delete units. This avoids having key figures in the InfoCube without the corresponding unit
Following are the steps to be followed :
Go to the context menu of Info cube that is to be redesign, select Remodeling as shown in fig. or select the Administration tab from the Left Most Area. There you can select Remodeling or can go direct to the T-Code RSMRT.
Also remember to activate the Transformation as well as the DTP of the Info Cube. Now there you can map the new Info Objects in the transformation but no need to upload the whole data again.
In the similar way, we can delete the Characteristics from the info cube without deleting the existing data into the Info Cube.
No comments:
Post a Comment