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

I have a report with some hyperlinks,any issue will i get when i migrate this report?

1 Answers   Zensar,


What is security domain in Business Objects?

4 Answers   Polaris,


How to restrict password to a user while sending a document in .pdf format

0 Answers   Mphasis,


how did u give developed universe to ur client?

1 Answers  


how to creat 2 way drilling mode.can any one know this

0 Answers  






Can we get the data from two different databasess in reporting level?

1 Answers   Infotech,


what are the complex reports you have created. Tell me with example?

7 Answers   Insurance, TCS,


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...

0 Answers  


@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?

4 Answers   iGate,


How do u Receive requiremnts from the client?

3 Answers  


What is meant by data federator and what is the use of it?

2 Answers   TCS,


what is tuning of business reports ?

5 Answers   Business Intelligence Analytics, Oracle, TCS,


Categories