| 查看: 347 | 回复: 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 |
回复此楼» 猜你喜欢
博士去二本高校当辅导员，如何调整心态？
已经有8人回复
-
27细胞生物学申博
已经有5人回复
-
面上有专家说实验设备不是我们单位的
已经有5人回复
-
江苏省自然基金 什么时候出结果
已经有6人回复
-
广西大学-广州大学招聘博士后 欢迎广大优秀人才！！！
已经有11人回复
-
闲聊
已经有3人回复
-
如何查询2026年获批项目名称？
已经有3人回复
-
两块石头
已经有10人回复
-
售SCI一区T0P文章，我:8O.55.1.O.54,科目全,可伽急
已经有15人回复
-
面上没中，邀请各位路过的虫友分析一下分数
已经有13人回复
