| 查看: 358 | 回复: 0 | |||
[交流]
分享小知识：What the difference between data validation and data reconciliation?
|
|
问题：What the difference between data validation and data reconciliation? 解答：Data validation is nothing but: Validation allows solid data entry regarding special rules. According to previous rules, the system can evaluate an entry and a message can appear on the user's terminal if a check statement is not met. A validation step contains prerequisite statement and check statement. Both of them are defined using Boolean Logic or calling an ABAP/4 form. Data Reconcialtion: Reconcilation is the process of comparing the data after it is transferred to the BW system with the source system. The procedure to do reconcilation is either you can check the data from the SE16 if the data is coming from a particular table only or if the datasource is any std datasource then the data is coming from the many tables in that scenario what I used to do ask the R/3 consultant to report on that particular selections and used to get the data in the excel sheet and then used to reconcile with the data in BW . If you are familiar with the reports of R/3 then you are good to go meaning you need not be dependant on the R/3 consultant ( its better to know which reports to run to check the data ). How to do Reconciliation? There are two ways for Reconciliation: 1) Create Basic Cube and load the data from the source system. In the same way create another cube of type Virtual cube. After creating those two cubes, create one multiprovider by using the Basic Cube and Virtual Cube, in the Identification of the Multiprovider select two cube. Then go to reporting create the query and write on formule to compare the values of these two cubes. 2) See the contents of the basic cube which is there is BW. In that screen one Button is there as "SAVE AS". Click that button and select as "Spread sheet". Save as .xls. In the Source system side also go to T-Code RSA3, select your data source which you assigned to the basic cube. Click on execute and see the contents. Now again here also select the "SAVE AS" button and select the spread sheet and save under .xls file. Ok now your two flat file are ready. Now move one file into other by using "move copy". Now two flat files are in one excel sheet only in different sheets. Now write a formula to compare the values of sheet 1 and sheet 2 in either in sheet1 or sheet2. Get help for your SAP BW problems SAP BW Forum - Do you have a SAP BW Question? SAP BW Books SAP Business Warehouse Certification, Interview Questions and Configuration Reference Books Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.erpgreat.com |
回复此楼» 猜你喜欢
40+中年人失业后，还能找到好工作吗？
已经有15人回复
-
二审4个多月了还是Awaiting Reviewer Scores
已经有5人回复
-
申请科研项目纯靠实力能成功吗？
已经有12人回复
-
用NBS溴化时溶剂除了CCl4外还有什么
已经有6人回复
-
极限拉扯，如何抉择
已经有15人回复
-
OpenAI又攻克数学难题了，离AI做有机合成还有多远？
已经有13人回复
-
课题组会帮你通过考核么？
已经有7人回复
-
招收博士生一名
已经有3人回复
