HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?

Answer Posted / ashok

by using derived table we can improve the query performance
because that is not created in database it can be designed
at universe designer only.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1693


Explain what is the difference between slice and dice and cross tab report?

811


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2605


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1742


When we use aggregate awareness function in designer?

729


any difficulitis have you phase while creating bo reports and how did u solve it

3174


How many universes can be created in a project?

777


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?

769


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

801


What is thumbnail?

736


How to generate the report from excel sheet?

836


How to execute the plsql procedure from the report by clicking with mouse?

807


Explain about a task that really tested your analytical abilities?

1001


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

828


What are the join problems comes appart from loop,chasm & fan Traps

1788