adding & removing fields from cube

[Former Member]

Hi Gurus

We have a requirenment of adding and removing few fields from ZPUR_C03.

Would you pl tell me the process to add customized/Business content field and to remove cutomized/business content field?

If possible give me the steps including the things I need to do in R/3 .

As always , appreciate your help.

[Former Member]

Krishna..

Just a word of caution...You have to do data flushing if u r adding something in your cube..& using same extractor to fill info in the cude..

Hope this helps.

Monica

[Former Member]

Hello Krishna,

Please go through this thread

Regards,

Praveen

[Former Member]

Praveen

I went thro this thread but I need to know the steps to enhance the data source.

Do we need to enhance the datasource when we add new field to cube ? ( source system : R/3)

Pl clear me on CMOD and user exit .Where can we create this and whats the use?

[Former Member]

HI KK,

First look whether that field is available in the Datasource already and not using so far into BW, If you could find that then no need to enhance incase that is not available then you will have to enhance the datasource accordingly.

And based on type of application you are using enhancement will differ so pls let everyone know what kind of Datasource you are using.

Regards,

BRB

[Former Member]

BRB

I am using 2lis_02_scl and 2lis_02_item

cube 0pur_c01.

we want to add statistical delivery date ZSTDELDT

so pl tell me what can be done on R/3 side?

[Former Member]

Hi,

This is nice work to be done.

If you are using generic Delta Extractors, then the first step is to stop the delta.

1. Modify the Cube & Extractors in Dev / Quality and be ready to move in Production.

2. Empty the Queue in R/3 for Purchasing.

3. Extract each and every record in BW so that you dont miss any records.

4. Stop the V3 updates and stop any further delta records to be loaded in Delta Queue.

5. Now transfer all the data in the cube to a temporary table in Production.

6. Move the new cube & Extractors to production.

7. Now you have the modified cube.

8. Reload back again the data in the Cube.

9. Start filling up the set up tables in R/3 for Purchasing.

10. Start off V3 updates and so that Delta Queue filling starts.

11. Once thats done start off loading data from R/3 to Cube.

I think you should be all set with this.

Hope this helps,

Pradip Parmar.

[Former Member]

Thanks Pradeep for your help.

If I have some further doubt will come back again.

points given

KK

[Former Member]

Pradeep

Oops my bad...we are not using Generic extractor. but the we are using the data source as given in my last post.so would you pl tell me the steps to add the field to business content datasource ?

Is that the case where we use CMOD and user exit?

I need to know in which scenario we use them?

[Former Member]

Hi, no need to do the same. You shud be able to modify and re use it.

You can change the Extractor which you are using for Purchasing.

2lis_02_scl and 2lis_02_item

Thanks,

Pradip.

[Former Member]

Pradeep

Then in which case we need to go for user exit and CMOD?