HI, Can any body explain me ? If we careate objects using
derived tables it will decreasess the performence? If we
are not creating the objects using the derived tables then
what is the use of having the derived tables?
Answer Posted / gowthami
In some scenario’s we cannot meet the requirement. In that case using derived table we can create own query with needed objects and can write the formula to achieve the requirement which cannot be done in general.
If there is no other way to achieve the requirement only the derived table can do. We can go for derived table. But it will decrease the performance of universe (more no of derived tables)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What are the steps to be taken to schedule the report?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
what is xcelsius architecture?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Explain how many universes can be created in a project?
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
Explain when to use local filter and when to use global filter?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What is a bo repository?
What is the difference between datawarehousing and businessintelligence?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?