Quality Assurance and Testing Services: Strategy of Oracle BI Testing

16 comments
This Document gives an overview of OBIEE Testing and commonly used in BI Components while doing validation.

1. Testing in Levels: In a typical OBIEE project, it is advisable to test in multiple areas rather than attempting to test everything at once.

a) The first set of tests can verify the accuracy of the column to column transport of the data between the source and target. This verification is typically done using SQL statements on the source and target databases.

b) The next step is to verify the accuracy of the repository (the .RPD file.) These tests will include testing with appropriate dimensional filters on the metrics and the formula used to compute those metrics. Testers can build two sets of comparable queries within the repository interface.

c) The next step in testing will be to verify the dashboard / reports against comparable queries on repository metrics. In these tests, testers verify dashboard charts / reports against corresponding results from queries they execute on metrics of the repository.

d) Finally, the functional interface tests will cover tests to verify the lookups, performance, ease of use, look and feel etc.

The first three types of tests are performed by testers who can create simple SQL statements.

Structure and organization of test cases:

The choices on test cases naming convention and structure can help organize the test artifacts better and aid a great deal in implementing the overall testing strategy.

For example: If the test cases are grouped based on the nature of the tests, like, source to target verification, RPD metrics tests, functional, security, performance and usability, it would be easier to pick and choose the tests based on the testing context and tester capabilities.

1. User acceptance criteria:
Users typically have an existing legacy mechanism to verify if what is displayed in the new solution makes sense. Testers should dig into this and understand how the end users built the project acceptance criteria. Testers should challenge the assumptions made by the business community in deriving the acceptance criteria. This activity helps get an end user perspective built into the testing efforts from early on.

2. Validating Master Detail Report: 
Master Details linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views.

3. Time series functions validation: Time series functions provide the ability to compare business performance with previous time periods, allowing you to analyze data that spans multiple time periods.

Time series functions enable comparisons between current sales and sales a year ago, a month ago, and so on.

a. Ago: With ago function we can compare period to period
b. To date: Time series functions enable comparisons between current sales and sales a year ago, a month ago, and so on.
c. Period rolling: The PERIODROLLING function does not have a time series grain; instead, you specify a start and end period in the function.

4. Oracle bi-publisher validation: Oracle BI Publisher known as XML Publisher offers efficient scalable reporting solution available for complex, distributed environments. It provides a central architecture for generation and delivering information to employees', customer and business partners both security and in the right format.





16 comments

November 6, 2012 at 8:53 PM

Thanks for sharing the post..This post have all the possible topics regarding Quality Assurance Testing Services.. Any on e can get best knowledge from your post..Really nice

Qa Tester Ottawa

Reply
July 19, 2019 at 5:58 PM

This is such a nice blog for me. Really amazing and very informative blog. thanks for sharing.
Facebookvideodownloader.org
Videodownloaderfb.com

Reply
September 7, 2020 at 1:23 AM

I truly delighted in investigating your site. great asset... Please visit best site storiesig about instagram stories

Reply
March 11, 2021 at 12:24 AM

Online betting in India not only provide information about the top-rated cricket betting sites but also provide predictions for all major tournaments.

Reply

Thank you for sharing this post. This post covers every possible topic related to Quality Assurance Testing Services. Your post can benefit anyone who reads it. Very nice.

https://www.safelinkchecker.com/site/bestofbettingsites.com

https://www.safelinkchecker.com/site/bestofbettingsites.com

Reply
April 5, 2021 at 11:57 PM

This is risky, but like most of the risky strategies, if you get it right, you can make a pretty decent win on it.To help you do all the research about cricket betting tips and strategies cricket betting india will help and guide you with it, so the rate of success is increased, because not only you need your luck by your side but also enhanced skills and knowledge of all the process.
https://www.mifare.net/support/forum/users/cricket-betting/

Reply
April 22, 2021 at 8:41 AM

We enjoy sneaking around and gathering information on online cricket betting, cricket betting tips, cricket betting terminology, and many more coming your way. You can visit cricket betting india for knowing the latest news about online betting in India.
https://help.orrs.de/user/cricketbettingindia

Reply
May 4, 2021 at 7:49 AM

Cricket betting india provides unique and continuously tracked on online betting in India, including cricket betting tips. On Cricket betting india we provide you with the most up-to-date information on cricket betting in India.
https://hypothes.is/users/junejo

Reply
May 13, 2021 at 6:13 AM

Thanks for writing such an excellent article. I stumbled onto your blog and read a few post. I like your style of writing. Keep sharing informative post. To know about cricket betting online, visit today! https://justpaste.it/winamax-tv

Reply
May 18, 2021 at 3:08 AM

I've read a few of your stories now, and I really like your writing style. Thank you a million times over, and please keep up the good work. https://hub.toot.cat/profile/narantour

Reply
May 19, 2021 at 5:42 AM

best betvictor casino games offers a wide spectrum of ways for carrying out online betting. You should choose an online betting sites that offers your preferred method of transacting money.
Techsupportforum

Reply
May 31, 2021 at 11:19 PM

I came across to your blog and found it well written with great writing skills. I'd love to bookmark this in my list. Keep sharing the good stuff. click now

Reply
June 18, 2021 at 3:55 AM

This is a fantastic blog. We greatly value your blog post. You will discover a diversity of approaches after reading your post. Thank you for bringing this blog to our attention. It's a fantastic blog post. Thank you for sharing this with us. https://www.kongregate.com/accounts/email_marketing

Reply
November 18, 2021 at 11:18 PM

Using the services of a contractor mortgage broker is essential in many ways. Using the services of a contractor mortgage broker has several benefits for contractors, which are briefly mentioned in this article. A contractor mortgage broker is a bridge between borrowers and lenders. They tailor lenders 'criteria to the borrowers' financial conditions and potential.
https://www.atoallinks.com/2021/how-do-you-apply-for-mortgages-using-vested-stock-income/

Reply
November 22, 2021 at 2:54 AM

Your article is truly informative. More than that, it??s engaging, compelling and well-written. I would desire to see even more of these types of great writing. Please contact our visa advisors to determine your eligibility for the visa you desire to apply for. Visa and immigration regulations is well-understood by UK Visa Consultants.

Reply
April 18, 2022 at 2:29 AM

Are you expecting a new addition to the family in the near future? If you've already selected baby clothes for your baby to wear to at home after he's been discharged from the hospital, it's likely that you'll require more baby dresses online shopping than you imagine! A newborn will require a few outfit changes every day during the first few months. It's not easy to finish everything after the new baby is born (due to sleep deprivation and constant schedule changes) We recommend having your baby's clothes organized prior to the time. There's everything from newborn clothes to toddler and infant clothes at Anthrilo
https://www.scoop.it/topic/kids-clothes-by-anthrilo

Reply
Post a Comment