on 12-11-2008 5:36 AM
Hi Experts,
This is the first time I am posting any question.
I am currently working in sales cube. Delta Data from billing item ( Data source 2LIS_13_VDITM ) is scheduled in process chain and has been working fine for last 3 months. Every day in morning 5 A.M scheduled job fetches data from SAP/r3 and posts it to BIW cube.
One day on 5 dec 4 pm by mistake i initialized the info package in update mode " Initialize without data transfer ". so the next day when the scheduler fetched the data biliing documents created between 9am to 4 pm on 5 dec wa missing from the cube. Help me populate these data without breaking the delta.
One more thing I dont have a DSO ie data is going directly to cube from PSA.
Thanks in advance.
HI Sanjay,
Delete the request on 5th Dec.
And fill the setup tables with the selection on date as 5th Dec.
Next go for the Repair full request.
The objective for deletion of request is to avoid the duplication of the records if it is an ODS u need not even do that.
Regards,
Shashikanth.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can go for Full repair request with out disturbing the Delta mechanism. But make sure that No other locks occur when you are doing Full repair request.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi SAnjay,
Better go for full repair requset
If the request fails in the data target,in order not to distrub the deltas we can go for the repair full request. this brings up the full data (like full load in a cube) and this does not affect the changelog table, so that the deltas can be performed normally.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raj,
I have missing data in cube only from 9am to 4 pm on 5 dec. All the billing documents that are made after 4 pm are present in the cube.
To make sure that all the bilings dine on 5dec I want to upload full data on 5 dec. So, do I need to delete request of 5 dec from the cube ?
Thanks and regrds,
Sanjay Kumar.
Hi sanjay,
Please go through few of these threads that trhows you a brief view of ful repair request and to use it
https://www.sdn.sap.com/irj/scn/advancedsearch?query=howtodofullrepair+request&cat=sdn_all
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.