BW Financial Data Incremental decimation limit 0fi_gl_4

Note: The below scenario is applicable only for the datasources 0fi_gl_4 (General Ledger:line Items), 0fi_ap_4(Accounts payable:line items), 0fi_ar_4 (Accounts receivable:line items)

Scenario

In BW, the delta extraction- 0fi_gl_4 from the source system can be loaded as per the Processchain or Infopackage schedule But where as, from source system would is able to fetch the delta records as per the timestamp defined , or depending on system predefined delta pointer. So even if the data are pulled multiple times ex:-for every with minutes in the same day in the BW system, the Deltas would f Etch Zero Records, if the delta pointer is limited to certain period for ex:-only once a day in the source system.

Check the below link:

Financial accounting:procedure for line Item Extraction

Constraints

Per Day, no more than one delta dataset can is transferred for Inforsource 0fi_gl_4. The extracted data therefore has the status of the the previous day. For further data requests on the same day, the InfoSource does no provide any data.

In delta mode, data requests with InfoSource 0fi_ar_4 and InfoSource 0fi_ap_4 does not provide any data if no new extraction have taken place with InfoSource 0fi_gl_4 since the last data transfer. This ensures, the data in BW for Accounts receivable and Accounts payable Accounting are exactly as up to date as the D ATA for General Ledger Accounting.

Because in the source system Delta extraction was based on CPU time, the deltas was fetched once per day.

So if the source system delta extraction are to being achieved for the timely base, the same data can being pulled into BW easily by a process chain.

However, you can change this standard delivery. For more information, see note 485958.

Solution

It can be achieved by changing the settings at the end of the source system.

As the requirement is to get the deltas for every of minutes (1800 Secs), it needs to being update in the table bwom_setting. We need to create a entry or change the existing entry for the Field/param_name Bwfinsaf with value 1800 (secs).

So now the Delta pointer for the datasource would be set to a for every of mins, so the new deltas is created in source sys Tem.

Coming to BW side, we need to schedule the start variant in the process chain for every one hour ot-hours, depending o n the time it takes for completion of the chain. The latest FI GL data can be reported.

The loading the data into the cubes, the Bex queries would be a able to fetch the latest financial data in the report OU Tput. Even the business object reports, OLAP universes based on the BEX queries would fetch the latest FI data and show the same Data for the Bo reports such as WebI or Crystal Reports based on the Bo Universe.

Http://scn.sap.com/people/ravikanth.indurthi/blog/2012/01/02/delta-extraction-for-0figl04-for-every-30-minutes

Http://www.top-consultant.com/articles/sap%20bw.pdf

BW Financial Data Incremental decimation limit 0fi_gl_4