Skip to Content
In BW 3.5 version, if data is present in an infoprovider, we can add an infoobject to it, but we cannot delete or replace an existing infoobject in it, unless all infoprovider data is deleted.

This problem has been overcome in BI 2004s version, where the concept of ‘Remodeling’ can be used to change the structure of an infoprovider even while it holds data.

REMODELLING: Remodeling is a new concept in BI 2004s where we have different options like Add characteristic, Delete characteristic, Replace characteristic, Add key figure, Delete key figure and Replace key figure.

image

Eg: Below is an Info cube with 2 characteristics and 2 key figures. Now we will delete one characteristic ZREG and add a new characteristic ZCOUNTRY.

image

Once you have created infoprovider and want to change it with addition or deletion or replace with any other new infoobject, go to ADMINISTRATION tab and click on “Remodeling”.

image

Enter Remodeling Rule name and Infoprovider on which you want to do Remodeling and click on create.

image

Click on ‘Add’ icon in the next screen.

image

Choose radio button for the operation ‘Delete Characteristic’.

Fill the characteristic name and click on ‘Transfer’ button.

image

Now save the changes and click on ‘Schedule’.

image

If you want to execute it immediately click on “start immediately”, else “start Later”.

image

Now go to cube and check the changes, you can find ZREG has been deleted.

image

In the same way you can add characteristic ZCOUNTRY.

image

After adding or replacing the characteristic, use one of the following options to populate data.

1. Constant: To populate constant data for the new characteristic.

2. Attribute of characteristic: To populate data from an attribute of some other characteristic.

3. 1:1 Mapping with characteristic: To populate data from other characteristic use.

4. Customer Exit: To populate data from some other source.

After saving the changes and Schedule check the changes in the info cube, you will find ZCOUNTRY.

image

In the same way, to add a key figure you can select ‘Add key figure’ and fill the details.

image

After adding the key figure, use one of the following options to populate data.

1. Constant: To populate constant data for new key figure.

2. User Exit: To populate data from different source.

For replacing the key figure, use the following option to populate data.

Customer Exit: To populate data for the replaced key figure.

Before saving and scheduling, if you want to undo the changes, then select the change(shown in circle in below screenshot) and then click on ‘Delete’ icon.

image

For further details please see this link from help.sap.

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

  1. Thanks for the info. Do you have any statistics on how long these operations would take in a production environment? e.g. 5 millions rows an hour to remove a characteristic.
    (0) 
  2. Anurag Khungar
    Thanks for the details.
    Any idea how Compressed data is handled in Remodelling. e.g. If I have part of my data in compressed state and partly in uncompressed state
    (0) 
  3. Kamaljeet Kharbanda
    Hi,

    SAP is suggesting to take backup of data while using Remodeling tool, have you tried the performance with the tool?

    Most of the cases in Remodeling we have to use Customer Exit for populating the data, it will be good if you can provide more detail on that.

    Thanks,
    Kamaljeet @KJ…

    (0) 
  4. Philip Botterill
    Thanks for your explanation of how to change the structure of an InfoCube that already contains data. In the first part of your scenario you effectively replace the “region” characteristic, with a “country” characteristic.

    Do you know of a cleaver way (or future SAP development) that would allow you to do this two step remodeling in such a way that any SAP BEx Queries defined on the InfoCube are automatically adjusted? i.e. any use of the ZREG characteristic in BEx queries is replaced by the ZCOUNTRY characteristic. It would be great if such an adjustment could accommodate structures, restricted key figures, variables etc..

    Without such an adjustment, would the remodeling you describe require a manual adjustment of all BEx queries containing the ZREG characteristic?

    (0) 
  5. Jay Roble
    1. s there a way to simulate the remodeling in order to test your User Exit code?

    2. Can you replace the VALUE of an existing Characteristic or Key figure?
    Example: You have a EU QTY (Equivilent Unit) Key figure. But your EU Rate for each material has changed, so you want to replace the current EQ QTY with the new EU Qty (Qty_Sold x EU Rate).

    (0) 
  6. Anthony Tan
    Hi,

    I just want to comment something about this remodelling tool.  I had had a prior experience setting one up.  I had 8 steps defined and when I ran the remodelling, steps 1 to 4 went fine but failed on step 5.  The entire remodelling halted from there.  Steps 1 to 4 were committed and did not roll back.  In the end my cube got corrupted and I had to rebuild it from scratch.  I understand I had to backup my cube before executing the remodelling.  I took my chances.  Luckily this happened in the Dev box.

    Cheers,
    Anthony

    (0) 
  7. venkat s
    hi,
    blog is good but what ever u did u did by keeping a contant
    can u tell me how to fill a charecteristic or key figure from other data targets like there is a option to write exits
    where and how to write so that i can fill my objects
    (0) 
  8. Laurent THIBERT
    Hello,

    I executed a remodeling step on a cube for adding a new characteristic with a copy rule from another characteristic yet existing. It worked fine. I can see the data correctly updated with LISTCUBE.

    I could then tick the boxes for using two navigational attributes unherited from the new inserted characteristic.

    However, it does not work at all. The characteristics are available while designing a query. However I get the message No Data Available when I run the query.

    Any idea?

    Regards,
    Laurent

    (0) 

Leave a Reply