how to extract data for 0FI_GL_50

[Former Member]

hi guys,

we need to use datasource 0FI_GL_50, delta is not supported for this datasource, how can we extract data from ecc?

[Former Member]

Hi Ester,

If the datasource doesn't support delta load.....then you can't help this.

For ODS it will not be a problem if you keep the aggregation type as "Overwritten"....

But if you want Aggregation Type summation in the ODS level then you have to delete the content of the ODS before loading.....

For Infocube level duplicate records will be there......but you can avoid duplicate records in the following way...........

Use a Full DTP to load from ODS to cube and in the Process Chain you include the Process " Delete Overlapping Requests from infocube".....it will delete the previous request.......then there will be no duplication of records......

Actually what I feel is......there shoukd be three stage of loading.....

a) In the first level a ODS should be there with Aggregation Type Overwrite, so no need to delete the content..

b) 2nd level ODS with Aggregation type Summation, deleteion of the content required...

c) Then from ODS to cube.....include the step " Delete Overlapping Requests from infocube" at the end..

Regards,

Debjani.....

[sathiendiran_balu]

HI ,

Full load is not supported by this extractor 0FI_GL_50 , you have to always do a full load to the standard DSO 0FIGL_D40 - General Ledger: Line Items, and subsequently can load delta to the cube

Regards,

Sathya