cancel
Showing results for 
Search instead for 
Did you mean: 

Standard datasource enhancement

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member182516
Active Contributor
0 Kudos
former_member182516
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos
Former Member
0 Kudos

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