cancel
Showing results for 
Search instead for 
Did you mean: 

Populate missing data in cube

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi,

I am trying to fill setup table for billing, I am getting message " DataSource 2LIS_13_VDHDR contains data still to be transferred " although there is no data in setup tables. I have double-checked it.

Delta process is running.

Rgds,

Sanjay Kumar.

Former Member
0 Kudos

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.

rajkumar_kandula
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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.

rajkumar_kandula
Active Contributor
0 Kudos

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