HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
Answer Posted / manoj
Derived Tables decrease the performance because even if you
include one single object from this table the entire query
from the table is executed .
You can see this in the sql Query panel.
hence i would avoid using any derived tables unless
mandatory
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the data types present in bo? What happens if we implement view in the designer and report?
what will be the contents for a functional requirements specifications
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?
Explain what are the steps to be taken to schedule the report?
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?
Can we create universe with no cache??
Explain how we drill up week to month?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What is the difference between business requirement document and use case document.
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What is the functional & architectural differences between business objects and web intelligence reports?
Explain about a time when you discovered a more efficient way to do a work task?
Explain what three things do you consider to be the most important factors for a manager?
How we drill up week to month?
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...