Remodeling is a new feature added in NW04s BI 7.0 version of SAP BW. It enables to change the structure of an Infocube that is already loaded with data.
Using remodeling a characteristic can be simply deleted or added/ replaced with a constant value, value of another InfoObject (in the same dimension), with value of an attribute of another InfoObject (in the same dimension) or with a value derived using Customer exit.
Similarly, a key figure can be deleted, replaced with a constant value or a new key figure can be added and populated using a constant value or a Customer exit.
Assume, you have an InfoCube for Sales which is already loaded with data. Assume, there is an InfoObject ZCUST_DOB which maintains Customer’s date of birth.
The Business requirement is, the InfoCube should contain Age of the customer also. For remodeling of InfoCube with an extra InfoObject for age, first create an InfoObject ZCUST_AGE and start Remodeling process for cube as follows. The new InfoObject ZCUST_AGE added to the cube will be filled by the remodeling rule which will calculate the values based on the values of ZCUST_DOB for each data record.
Continue reading →