Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mayur
hi,
see i would like to answer it through on example:
consider the case where u retrive the data from the table xyz
by writing the "SELECT STATEMENT" & get the output ( say 5 rows) now their is the condition ....where u need this output(5 rows) for report/query..etc..
now, in such condition you can create an object of the above statement i.e "Select Statement" and store it in Derived table
& hence next time u will not require to write sql again...
& even a complex sql is effectively implemented...
finally this will enhance ur performance & a effective development logics ....
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
8. How much supervision have you typically received in your previous job?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain when to use local filter and when to use global filter?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What Is Snow Flake Schema?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
What is the profile and package?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is thumbnail?
Explain is there any default username & pwd for bo designer & supervisor?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
