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


Please Help Members By Posting Answers For Below Questions

What are the data types present in bo? What happens if we implement view in the designer and report?

614


Explain what are the steps to do to use alerts in bo?

608


What is package in BO

2681


How to open a universe with out using the Designer ??

6600


What is the dense rank?

671






what will be the contents for a functional requirements specifications

1780


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

9875


What is object stores?

583


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?

550


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1745


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

1825


how many reports have u created ? explain a few.

1655


Can Bo generates the Report from the cubical data Explain?

1626


Explain what sort of existing documents should business analysts refer to when starting on a new project?

597


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

599