| 查看: 291 | 回复: 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 |
回复此楼» 猜你喜欢
317求调剂
已经有7人回复
-
复试调剂，一志愿南农083200食品科学与工程
已经有4人回复
-
一志愿太原理工安全工程300分，求调剂
已经有3人回复
-
284求调剂
已经有11人回复
-
食品工程专硕求调剂
已经有3人回复
-
324求调剂
已经有7人回复
-
一志愿武汉理工，总分321，英一数二，求老师收留。
已经有4人回复
-
287求调剂
已经有7人回复
-
325求调剂
已经有5人回复
-
343求调剂
已经有4人回复
