on 2016 Dec 08 6:17 PM
Hi Gurus,
Currently we are live with inventory management in BW. We are live since 2011. Now we have a requirement where in I need to get the movements from Jan 2016 to till date and store in the DSO.
PSA doesn't have data. So what I am going to do is
1. Fill up the set up tables for BF from Jan 2016 till date
2. Create a FULL info package and extract data into PSA.
3. Create a DTP and extract the data into DSO.
After successful load into DSO, I will delete that full update request from PSA so that it wont go into other targets. From next day deltas will go as usual to new dso and other targets.
is my approach right?
Next Question is
How can i retain that full update request in PSA without loading into other data targets. I would like to keep this data for few days and then delete. Is there any way??
Thanks
Sri
Hi,
Assuming as data source 2LIS_03_BF feeding data one DSO/Cube only.
Rather than using full info pack, please use repair full request info pack with selections to load data from set up tables to PSA and run delta dtp to load data to dso/cube.PSA data deletion is not required.
if your data source is feeding data to multiple targets then psa deletion is mandate. But very careful while deleting psa request. if we deleta delta request then it will create problem.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your response.
I finished activity successfully
Steps:
1. Filled up setup tables
2. Executed info package and extracted data into PSA.
3. Executed full update REquest by request into Cube, This got deltas that already existed in PSA.
4. After successful load, Created a delta DTP and initialized Delta without data transfer and deleted all other requests from cube (Previous deltas that existed in PSA and just retained latest request)
5. Later changed the status in the DTP by removing delta inti tick mark.
6. Deltas running fine from next day.
Thanks
Regards
Sri
User | Count |
---|---|
82 | |
12 | |
10 | |
10 | |
10 | |
9 | |
8 | |
7 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.