Answer Posted / smita chatterjee
There are some basic ways of testing the universe:
1. built in feature of check integrity and 5 other check options which check for parsing, looping, context etc.
2. The other way of checking whether a universe is properly working is by creating dummy report and verifying with the back end data.
The method of testing reports is :
1. Data checking: where we tally the report data with the database data by help of the database client like sql server or toad which can aid to check the underlying data whether the source is JDE or Terradata or DB2 or Oracle.
2. Integration Testing where we insert or update data from an UI and then check the impact on our report.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Start a batches with in a batch?
Explain what are slowly changing dimensions?
What are partition points?
What are the approaches used by optimizer during execution plan?
What is Sequence clustering algorithm?
Can decision tree be implemented using SQL?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What are the various file formats involved in reportnet?
Give some difference between oltp and olap.
Why null values are mapped as 0 in fact tables?
What is the use of incremental aggregation? Explain me in brief with an example?
What are the different types of scd's used in data warehousing?
What are the advantages and disadvantages of reporting directly against the database?
What is difference between e-r modeling and dimensional modeling?
What is MODEL is Data mining world?
