Locockpit setuptable issue.

[Former Member]

Hi,

I have to load 3yrs data for these data source 2lis_02_HDR,ACC,ITM . but user is not agreeing the down time for loading the these datasource to bw system. i gone through some of documents like first load init without data transfer and followed by full repair load and deltas going to delta queue . shaill i go head in this procedure is there .Can any one suggest me on this issue.

Regards

RK

[Former Member · Accepted solution]

To add to that, you will be better off if you applied a selection based on some field while performing the Repair Full Load.

For ex. if you have the Order Number range or if you have the Document Dates available, you can apply a filter on these and load limited amount of data, during a single load.

[former_member209032]

Hi,

If you are not directly loading to a cube and if your ODS has all the keyfigure as overwrite then you can follow your process.

Regards,

Raghavendra.

[Former Member]

hi,

the extractor 2LIS_02_HDR has delta type - ABR i.e. this data source extracts the with After , before and reverse image.

In your case if you are extracting data from this data source to DSO and then cube, then you can do as mentioned do a new init w/o data transfer, do full repair and then delta. this will not corrupt data as the DSO will have KF in overwrite mode and even if the PO numbers are extracted twice (in full repair and delta) the final snapshot will still match with R/3 system.

Downtime is needed in the setup of extractors which are sending additive delta and the same record cannot be a part of setup table and delta, in your case it is not sending additive so no worries.

regards,

Arvind.

[Former Member]

Hi,

Thank you very much for your replies .I will updated to you on this issue.

Regards

Rk