Delta extraction for 0FI_GL_04 for every 30 minutes
来源:互联网 发布:房地产大数据挖掘 编辑:程序博客网 时间:2024/05/18 02:13
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 for 0FI_GL_4 from the source system can be loaded as per the processchain or infopackage schedule but where as, from source system will be able to fetch the delta records as per the timestamp defined, or depending on system predefined delta pointer. So even if the data is pulled multiple times Ex:- for every 30 minutes in the same day in the BW system, the deltas will fetch 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 be transferred for InforSource 0FI_GL_4. The extracted data therefore has the status of the previous day. For further data requests on the same day, the InfoSource does not provide any data.
In delta mode, data requests with InfoSource 0FI_AR_4 and InfoSource 0FI_AP_4 do not provide any data if no new extraction has taken place with InfoSource 0FI_GL_4 since the last data transfer. This ensures that the data in BW for Accounts Receivable and Accounts Payable Accounting is exactly as up to date as the data for General Ledger Accounting.
Because in the source system delta extraction is based on CPU Time, the deltas are fetched once per day.
So if the source system delta extraction is to be achieved for the timely base, the same data can be 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 back end in the source system.
As the requirement is to get the deltas for every 30 minutes (1800 Secs), it needs to be update in the table BWOM_SETTING. We need to create an entry or change the existing entry for the field/Param_Name BWFINSAF with value 1800 (secs).
So now the Delta pointer for the datasource will be set to for every 30 mins, So that new deltas are created in source system.
So now the Delta pointer for the datasource will be set to for every 30 mins, So that new deltas are created in source system.
Coming to BW side, we need to schedule the start variant in the process chain for every one hour ot two hours, depending on the time it takes for completion of the chain. So now the latest FI GL data can be reported.
So after loading the data into the cubes, the Bex queries will be able to fetch the latest financial data in the report output. Even the business object reports, OLAP universes based on the Bex queries will 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.
- Delta extraction for 0FI_GL_04 for every 30 minutes
- Delta Merge for SAP HANA
- 转载:30 Minutes Flex Test-Drive for Java Developers
- For every boy(not man)^^
- Get Minutes for Match Event Back!!!
- using OpenCV with python for descriptor extraction
- [EMNLP2017]Adversarial Training for Relation Extraction
- 论文浅尝 | Distant Supervision for Relation Extraction
- I am ready for every challenge..
- 5-tips-for-creating-good-code-every
- init: Id "x" respawning too fast: disabled for 5 minutes
- INIT: Id "con" respawning too fast: disabled for 5 minutes
- messages报logger: Waiting minutes for filesystem containing crsctl
- init: Id "co" respawning too fast: disabled for 5 minutes
- init: Id "co" respawning too fast: disabled for 5 minutes
- BW---HOW to basis Lo Extraction for SAP-BW
- BW---HOW to basis Lo Extraction for SAP-BW
- 读论文之ObjectProposals for Text Extraction in the Wild
- Oracle提高sql执行效率的建议
- iOS开发:创建真机调试证书
- LNMP 1.2
- Android中间向两端,两端向中间并发前进的进度条,Android自定义ProgressBar进度条
- 国民CP:艺术收藏品与P2P配
- Delta extraction for 0FI_GL_04 for every 30 minutes
- Android自动化测试(UiAutomator)简要介绍
- MVC快速入门
- swift实作app 交流分項十(動畫特效)
- mysql行转列(拆分字符串场景)
- 邓白氏编码官方查询地址
- 事务总结
- nodejs初学-----helloworld
- OCP-1Z0-051-2015-27题