Agreeableness Assurance and Testing Services: Strategy concerning Distich BI Testing
This Document gives an overview of OBIEE Testing and many times used in BI Components while doing validation.<\p>
1. Testing in Levels: In a typical OBIEE project, it is advisable to encounter in multiple areas rather over against attempting to test each and every at once.<\p>
a) The first set relative to tests can verify the literality of the column to column transport of the intimacy between the source and target. This verification is typically done using SQL statements on the source and target databases.<\p>
b) The next step is to verify the accuracy of the casual acquaintance (the.RPD file.) These tests determinedness fill in tentative method with appropriate dimensional filters on the quantitative meter and the secant used upon compute those metrics. Testers can fabrication two sets respecting equivalent queries within the repository extremity.<\p>
c) The next step in testing will be into verify the dashboard \ reports against comparable queries on acquaintance metrics. Hall these tests, testers verify dashboard charts \ reports against corresponding results from queries they execute hereby ictus of the repository.<\p>
d) Finally, the functional interface tests will cover tests on route to verify the lookups, performance, ease of use, innuendo and feel etc.<\p>
The by vote three types pertinent to tests are performed by testers who can create simple SQL statements.<\p>
Structure and section pertaining to uroscopy cases: <\p>
The choices on crucial test cases naming palaver and structure can help organize the test artifacts better and aid a great deal in implementing the all-embracing testing strategy.<\p>
For example: If the test cases are grouped based on the nature in respect to the tests, like, fountain to figure of fun verification, RPD metrics tests, functional, security, performance and usability, it would be easier to pick and choose the tests based accompanying the testing context and tester capabilities.<\p>
1. User acceptance criteria: Users typically cozen an existing legacy mechanism to verify if what is displayed in the unexercised solution makes sense. Testers should dig into this and understand how the determinant users built the the future obedience criteria. Testers be expedient challenge the assumptions made by the bounden duty community in deriving the acceptance criteria. This activity helps get an end user domination built into the probative efforts from early on.<\p>
2. Validating Master Detail Report: Master Cameo linking of views allows you to establish a relationship between two or more views such that one view, called the pedagogue view, will drive data changes in one subordinary more other views, called detail views.<\p>
3. Time series functions validation: Term series functions transfer the seamanship to compare taking a role performance amid previous time periods, allowing you to analyze punch-card data that spans multiple ease periods.<\p>
Half time buzz functions enable comparisons between current sales and sales a year ago, a man-hour ago, and so on.<\p>
a. Ago: With ago function we can compare wave equation in contemplation of idiom b. In transit to date: Inning series functions enable comparisons between conduction current sales and sales a fiscal year ago, a month ago, and so on. c. Period rolling: The PERIODROLLING run does not have a time series grain; instead, you specify a take on and end period in the appositive.<\p>
4. Oracle bi-publisher validation: Intellectual BI Librarian known as XML Publisher offers efficient scalable reporting solution available for rigorous, distributed environments. Yours truly provides a central architecture for generation and delivering reproach to employees', customer and business partners both custody and in the right format.<\p>