cancel
Showing results for 
Search instead for 
Did you mean: 

Remodelling through 1:1 mapping with characteristic

Former Member
0 Kudos

 

Hi,

For remodelling an infocube through 1:1 mapping with characteristic, we need to map the characteristic in the transformation/update rules, in that case do we need to map the new characteristic to the old characteristics in the update rules.

For eg., new_char is going to be populated by values from old_char, so once the remodelling rule is scheduled do we need to add the new_char in the update rules.

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

ravi_chandra3
Active Contributor
0 Kudos

Hi

No need to map . because suppose if u are populating the data for the new fields by using

i) constant : then u can directly enter the value in this case.

ii) attribute of a characteristic : If u want to populate the data through this method u have to give the required characteristic and the attriutes. Whenever u select this radiobutton(attribute of the characteristic ) then the at the bottom u will get 2 text fields there u have to give the characteristic and attribute values.

iii) 1 : 1 mapping : here also u will get the text box there u have to give the required characteristic .

iv) customer exit : where u have to write the logic.

So if u populate the data by using the remodelling then no need to map at the transformation level.

Regard,

RaviChandra

jagadeesh_mandepudi2
Active Contributor
0 Kudos

Hi

Please follow below steps..

Link: http://help.sap.com/saphelp_nw2004s/helpdata/en/58/85e5414f070640e10000000a1550b0/frameset.htm

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.


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.


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


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


Click on 'Add' icon in the next screen.


Choose radio button for the operation 'Delete Characteristic'.

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


Now save the changes and click on 'Schedule'.


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


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


In the same way you can add characteristic ZCOUNTRY.


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.


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


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.


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

Jagadeesh

Former Member
0 Kudos

Hi,

My question is with the mapping in the transformation, does it have to be mapped with the old_char.

jagadeesh_mandepudi2
Active Contributor
0 Kudos

Hi

Its not required to Map since you already have old car in the target so it will populate from it.

Jagadeesh