BO Testing

Hello BOB,

Please help me in figuring out what constitutes unit , integration , system testing from a univese and reporting development point of view.

Thanks
BIUser


BIUser (BOB member since 2004-08-04)

Hi, and welcome. :bob:

You might try looking around a bit. I found this topic which might give you a start. Also a more specific question will generate more specific answers.


Dave Rathbun :us: (BOB member since 2002-06-06)

Thanks Dave.

These are some of the objectives for various phases of testing from Universe point of view. Can we adopt this grouping to BO? Can we refine this list?

Unit Test

§ Test Universe Parameters – Definition, Strategy, SQL and Control tabs.
§ Test Universe Structure – tables & joins as per ERD.
§ Test objects – Definition, Properties, formulas (decode, sum , max, avg , variance formula etc ) , Aggregate Navigation , Object compatibility, Universe logic (business) by running ad-hoc queries with appropriate combination of objects.
§ Test Custom LOVs if any.
§ Test for loops and traps – Create and Test contexts by running ad-hoc queries using objects from various tables in a context.
§ Test Hierarchy – Create custom hierarchy if required. Run ad-hoc query with Scope-Of –Analysis and ensure report Drill path is as per the chosen Scope.
§ Ensure universe is built on the lines of BO best practices and guidelines.

Integration Test

Test the universe from Infoview for the following

§ Universe accessibility.
§ Universe Data source validation.
§ Custom List of Values.
§ Universe Security.
§ Universe functionality by running various ad-hoc queries.
§ Validate data against D/W Test Results.
§ Query performance.

§ Test impacted reports pointing to the changed universe (universe change)

System Testing

Test the universe from Infoview for the following

§ Universe accessibility.
§ Custom List of Values.
§ Universe Security.
§ Universe functionality and data by running various ad-hoc queries.
§ Query performance.

Your thoughts wil be greatly appreciated.

Thanks


BIUser (BOB member since 2004-08-04)