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
Explain what is the advantages data mining over traditional approaches?
What is data validation strategies for data mart v?
Where the applications and where ware house management system is used?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is Discover and Execute in XMLA?
Fact table is in normalized or de-normalized form?
Explain the definition of normalized and denormalized view?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is real-time datawarehousing?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is the purpose of Dataware Control?
What is the use of tabular model, tabular sql, tabular reference in real time application?
How to pivot row data using informatica?
Why is business intelligence (bi) important in data warehousing?
What is a fact, dimension, measure?