Beginner’s Guide on Remodeling of Info Providers

By Arun Bala Ganesan, Wipro Technologies

Remodeling, a term which so obviously states something is either reset or rearranged with terms of Info providers. What must be the ideal way to modify how data is displayed? Say, we have loaded a million records into our cube, but in a dire need to modify, do some changes to accommodate some more Info objects to the existing fact or delete some repeating data / no data columns etc at dimension level. In such cases what is the handy solution? The most trusted way to resolve hiccups of this sort is to identify & remodel your Info provider either at fact/dimensions level. In this article we’ll discuss some steps to change the metadata of our Info Cube and remodel our Info Provider. But first time users must be cautious enough to use the remodeled object, and transport the same object to different system landscapes sequentially. The drawback is that, we need to ensure no inconsistency with regards to definition of the Info provider exists between different systems in our entire landscape, else objects could become non-transportable at last. A simple example for re-modeling is as below.

So whatever the changes the DW architects make, care must be taken to do a full backup of all data, followed by stopping all respective process chains. After remodeling existing InfoCube, ensure to re-activate all your transformations & restart process chains (if applicable).

Remodeling in SAP NW-BI 7.0 is applicable only for InfoCubes; not Characteristic Info objects or DSOs. The following options can be performed during a remodeling.

  • Add Characteristics / Key figure

  • Replace Characteristics / Key figure

  • Delete Characteristics / Key figure  

There are some pre-activities to be performed too. Once a remodeling rule is scheduled, it is not allowed to modify in future; if not we must create a new remodeling rule. The best advantage is remodeling can be performed even when cube is filled with full data.  The remodeling activity can be monitored also, and the requests can be either reset or restarted. Reset would be an exception, while Restart would potentially re-initiate the whole process.

So, to discuss on the early watches to be taken care, its best advised to never run remodeling for an InfoCube, while some process chains or SM37 jobs are running in parallel & take care of manually activating & restarts of the process chains once the remodelling is successful. Also, the InfoCube is locked for any loads or changes.

This activation must be performed for all objects upper & below the data flow (which would include transformation rules). Plus, data backups are a must. Aggregates existing on the cube, if any, will have to be recreated.

Deletion of Characteristics – Step by Step Example

Use T-Code: RSMRT or use ‘Re-Modeling’ in Administration tab on LHS of RSA1.

Consider the data as in the cube. Here we plan to delete the unused field Z08_DTE.

Give the remodeling rule name & description.

Choose the required options as in the figure.  

Save, Check & Schedule the rule.  

Click here to continue...

Please send us your feedback/suggestions at webmaster@SAPTechnical.COM 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image