fields adding

[Former Member]

hi experts i have one requirement . i want add two fields to existing cube with some logic . so please give me step by step procedure(in bw 3.5 version) in r/3 and bw .

thanks in advance

Bharati.

Edited by: bharati.bi123 on Apr 14, 2011 9:47 AM

Please search the forum before posting a thread

Edited by: Pravender on Apr 15, 2011 11:59 AM

[shyam_uthaman]

You need to use Remodelling Technique ->This will retain the existing data in your cube while adding the new fields

To go this follow the below steps:

1. Go to RSA1 and locate your cube.

2. To create the remodelling rule, Right click on the cube and from the context menu that opens up select Additional Functions->Remodelling

3. This takes you to a screen where you will specify the rule name and the name of the cube(comes by default).

4. Click on the create button to create a new rule.

5. Put in the description of the rule in the new pop-up window that opens up and click on transfer to continue.

6. Now click on the Add an operation to list button(the green Plus sign on the top left)->you can also use Ctrl+F11 as a shortcut to this.

7. A new window opens up where you can define the rule for selected infocube.

8. Select the 'Add Characteristic' or 'Add Key Figure' radio-button depending on your requirement.

9.Maintain the parameters and logic for the operation in the bottom part o the pop-up.

10. Click the transfer button to add the defined operation to the remodelling rule.

11. Go back to the rsa1 screen.

12.Right click on the cube again and from the context menu that opens up select Additional Functions->Remodelling

13. This time, put in the rule name we created and press schedule.

[Former Member]

Hi,

First steps.

1. Identify what fields are those that you want to bring from R/3.

2. Check if your data source is already bringing the data from R/3.

3. If the data source is already bringing data into BW, then identify the info objects that you need to include in cube/dso.

4. If there is any DSO between your datasource and cube then you need to include the info objects in dso and cube as well.

5. You might have to delete the data from your data targets and then re load the data into the data targets after inclusion of the two new objects.

(if you are using new version of BW then you can use the remodelling technique to enhance the cube, without deleting the data).

6. If the datasource is not brining in the data for two new fields from R/3 then you have to enchance your datasource to bring the new fields data.

7. In RSA6 in R/3 enhance the data source and include the new fields. You need to check if you can just add the new fields from the same extract structure tables . If data to be brought from different tables then you have to wriite routine to populate data of new fields in your datasource.

8. Once done Activate the data source. and unhide the new fields from datasource.

9. Check for the new fields the data in RSA3 in R/3.

10. If you are able to see the dat ain RSA3, then in BW side do a replicate on this datasource.

11. You might have to activate the transfer structures associated with the datasource.

12. Activate all the update rules, DSO, Cube etc in the data flow.

13. Do a load from R/3 using info package. Your data will be loaded with the new fields data.

Hope it helps.

[Former Member]

Hello Bharati,

If you are trying to add some fields, please identify the suitable dimensions for the corresponding fields, then add them accordingly.For those new fields, if you want to have historical data, then you need to perform deletion of data in the cube. Or you can do the Re-Init with out data and set the delta, so then delta will also be picked for new fields as well.

Hope this may help you.

Thanks

PT