|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
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.
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
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
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.
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
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards