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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is aggregate table and aggregate fact table ... Any examples of both?

603


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

543


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

584


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

588


Can we Save (save as) WEBI Doc as DESKI?

7064






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

1745


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

3256


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1718


8. How much supervision have you typically received in your previous job?

1830


How were the reports scheduled and how to resolve unexecuted documents?

2210


how to prepare the documentation in business objects and where to get the requirement?

1782


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2597


Explain when to use local filter and when to use global filter?

603


Explain how we drill up week to month?

639


how to create metric universe ?

1893