Standard datasource enhancement

[Former Member]

Hello Experts,

I am new to sap bi....i have following questions.....pls help me out

1.I want to enhanced standard datasource (2LIS_11_VAHDR) for which i need to add few new fields.but the thing is datasource is already running in production?

2.I don't want to lose historical data & at the same time i need to add new fields?

So, pls guide me step by step enhancement procedure in above mentioned scenario.

Waiting for the earliest reply..

Thanks,

Satya

[former_member182516]

Hi Dave,

Check more links regarding LO enhancements

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b0af763b-066e-2910-a784-dc6731660...

[former_member182516]

Hi ,

Check the below link..

[ Data source enhancement |http://wiki.sdn.sap.com/wiki/display/BI/BestPracticeforDataSource+Enhancement]

Regards

Prashanth K

Edited by: prashanthk on Jul 26, 2010 12:19 PM

[Former Member]

Hi Vikram,

Thanks for the reply...

I have seen the document which is very useful.

but i need to enhanced the data source 2LIS_11_VAHDR which is already running in production.

i need to enhanced few new fields & also i require historical data for old fields.

Pls guide me...

Thanks,

Satya

[former_member181964]

Hi,

If your datasource is already in production, and you want to data only from today onwards for enhanced fields, i.e. historical data is not required for enhanced fields..

1. Fix ECC down time for 20 to 30 munities

2. Keep all objects on Qty system in ECC and BW.

3. Run Delta laods in BW for 2 to 3 times.So with this step you can clear SMQ1 and RSA7. Check the entries in RSA7, if it is ZERO then it is fine.

4. Move DS from ECC Qty to ECC PROD .

5. Replicate in BW.

6. Move all BW objects from BW Qty to BW Prod.

7. Delete Init load in InfoPackage level (Not in ODS/Cube).

8. Load Init without DataTransfer.

9. Then Run Delta.

10.Next day on wards deltas will come as usual.

If you need Historical data also.

1. Delete data in Cube.

2. Fix Down Time and load Init then Delta.

See the thread in SDN

Thanks

Surendra Reddy

[Former Member]

Hi,

Please follow the steps mentioned in the article below :

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2050db8b-9d90-2c10-2980-b13a4b093...

-Vikram

[Former Member]

Does your new fields require Historical data?

Please have a look on this nice blog!

/people/jfrancisco.fernandes/blog/2010/05/21/customizing-cockpit-managing-delta-queues-when-structure-changes

Let us know specific quieries