on 03-10-2015 3:21 PM
Hi All
Due to some data changes happened in the ECC sys , we need to load Lo billing item level data (sales org 5000) to BW so some one could explain step by step procedure to complete this.
we are planning to do this in cumming week end and current BW system data flow like below (loading deltas)-
PSA(delta)-> WDSO (delta)-> DSO(delta)->CUBE (delta)we are planning to do these below actions correct me if need any better solution.Ecc side -1. delete the setup tables2. fill the setup tables.BW side-1. run the info package using repair full request (no selection)2. create new DTP to load WDSO (from PSA) using selection sales org 5000.3. create new DTP to load DSO (from WDSO) using selection sales org 50004. delete the data in cube using selective deletion for sales org 5000.5. create new DTP to load to cube (from dso) using selection sales org 5000Pl advise is there any better solution.ThanksBhaskarHello Bhaskar,
Your approach is correct.
Remember to lock all users and stop backgrnd jobs before starting yort tasks. During setup table filling i think if you fill only for sales ord 5000, it will fulfill your needs... your thoughts?
Then at BW repair full to DSO, no need to delete data from DSO since it will overwrite.
Do selective deletion of data from cube(sales org=5000) and load from DSO to cube.
Delta will not be affected sice you will do repair full.
Regards,
AR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
no need to delete data from DSO since it will overwrite.
Do selective deletion of data from cube(sales org=5000) and load from DSO to cube.
If you say it will overwrite the data in standard DSO,then why did you suggest to do selective deletion of data from cube.
As per my understanding the data will be loaded to cube from change log table of DSO. So if you keep loading the "same data" in DSO again and again then the delta request from DSO to cube will send 0 records.
Regards,
AL
Hello Anshu/Bhaskar,
After deleting data from the cube, we will run the repair full, it will not pick delta, am i correct, it will do a full load on the selected sales org, loading all the missing records in cube
We are deleting data from cube so that there is no possibility of overwrite and incorrect values.
Regards,
AR
Hi Amit,
User have multiple sales org data . As per the needs, he is just loading sales org 5000 data only.
At DTP levels there is no repair full request option.
at info pack level only he will load thru repair full request based on sales org 5000
Rest of the data flow will be loaded by asusual delta loads .
thru delta from dso chang log to cube it feeeds 0 reocrds wherer there is no change in record.
Thanks
Dear Bhaskar
Here are the steps for you incase of reload:
Hope this helps
Thanks
Dhruv
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
While filling setup tables - if have selection on sales org please use it other wise it loads all data and will take more time.
BW Side.
1. Info pack better to use selections on sales org = 5000 and load data thru repair full request.
Remaining steps you don't need to create new dtps.
From PSA on wards delta load will take care them automatically.
At cube level you can delete data on sales org based before start your loading.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear All
No need to delete data in ODS as it will overwrite.
Yes, cube is additive but while loading data (delta) from DSo to Cube it will send 2 images so there is no point to double records in cube.
so it will send - value for old entry along with new record (so old doc will be zero).
DSO - active table
docno item qty amount
1000 1 10 10000
cube
docno item qty amount
1000 1 10 10000
If the qty changed to 18 the records will be loaded to cube from DSO- change log as below-
cube
docno item qty amount
1000 1 10 10000
1000 1 -10 10000
1000 1 18 10000
In this case no need to delete data in cube, pl advise if it is wrong.
Thanks
Bhaskar
Yes i can confirm it..If you have DSO with all the keyfigures in overwrite mode then you will not have doubled value of keyfigure in cube.Probably that is also one of reason to introduce DSO in the flows,so that we do not have data duplication issues.
Sometimes this happens because of missed deltas or someone deleted the delta request then this DSO approach comes handy.handy. In fact you do not need down time also for the same reason.
You can fill up the setup tables and you can keep running the deltas.You just have to make sure regarding the sequence of request you load to PSA.
First your full request should go and then your existing delta request.
I did it in past for DBM module.User never complained about the data integrity.
Regards,
AL
Yes besides that it also acts as single point of truth.So better to keep all the data intact in DSO and apply business logic in other provider.
This helps in long run when you have to validate data with ECC systems and as a part of house keeping activity data is deleted from PSA.So your DSO becomes handy.Correct!
Regards,
AL
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.