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?

Answers were Sorted based on User's Feedback



HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the pe..

Answer / padmalatha0923

we can create objects using derived tables
if derived tables increses then only performance decreses
but if we include one object form this table the entire query from this table is executed.we can see this in query panel

Is This Answer Correct ?    0 Yes 0 No

HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the pe..

Answer / 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

HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the pe..

Answer / raj

Use only when you need complex joins and calculations between tables in the BO universe then go with Derived table.To Update / Change the derived table structure in the universe is very easy

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

How to Avoid the overlaping the blocks in WEBI.

3 Answers  


How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.

1 Answers   Oracle,


How to create universe in business objects enterprise 11.5

1 Answers  


How to create an popup in the WEBI report if the report is showing partial result?

2 Answers   Banking, IBM,


How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.

1 Answers   Cap Gemini, TCS,






When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?

4 Answers   Wipro,


can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2 Answers   iFlex,


Explain when we use aggregate awareness function in designer?

0 Answers  


how can we build one report from two data bases

4 Answers   IBM,


What is top business?

0 Answers  


please anyone explain me the derived table with the problem tables.

1 Answers   CTC,


How do u Receive requiremnts from the client?

3 Answers  


Categories