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 maually can i define ? If thousends of records exists in a table?

1 Answers   Infotech,


1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment

3 Answers   Hexaware,


what is universe testing(not mention check integrity)

1 Answers  


IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?

3 Answers   Accenture,


what is slice & dice?

3 Answers   Cognizant, Saama Tech, TCS,






can anybody explain me in detail about software development life cycle of business objects in detail?

1 Answers  


Did you face any problems while creating reports? Name? Solutions?

0 Answers   IBM,


What is the difference between Sychronisatio and join?

2 Answers   Mind Tree,


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

0 Answers  


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

0 Answers   Arkema pte Ltd,


User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.

1 Answers  


in xir2 how to send reports to end user

2 Answers   TCS,


Categories