首页 > Linux操作系统 > Linux操作系统 > 模型改建-remodeling in bw 3.5

模型改建-remodeling in bw 3.5

原创 Linux操作系统 作者:jdzlhy 时间:2010-12-13 15:23:20 0 删除 编辑
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.

模型改建-remodeling in bw 3.5

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.

模型改建-remodeling in bw 3.5

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".

模型改建-remodeling in bw 3.5

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

模型改建-remodeling in bw 3.5

Click on 'Add' icon in the next screen.

模型改建-remodeling in bw 3.5

Choose radio button for the operation 'Delete Characteristic'.

Fill the characteristic name and click on 'Transfer' button.

模型改建-remodeling in bw 3.5

Now save the changes and click on 'Schedule'.

模型改建-remodeling in bw 3.5

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

模型改建-remodeling in bw 3.5

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

模型改建-remodeling in bw 3.5

In the same way you can add characteristic ZCOUNTRY.

模型改建-remodeling in bw 3.5

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.

模型改建-remodeling in bw 3.5

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

模型改建-remodeling in bw 3.5

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.

模型改建-remodeling in bw 3.5

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量