Answer Posted / v.sivakumar
To make it simple short cut joins are used to reduce the
joins in the Query which will increase the performance of
the query
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Can we create universe with no cache??
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...
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?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain about a tricky situation for which you found a very simple solution?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
what are the day to day activities of BO administrator ?
Explain how to schedule the report in b.o?
Explain when we use aggregate awareness function in designer?
Explain what task is 98% of the required work of a business analyst?
What Is The Difference Between Oltp And Olap?
Explain about a task that really tested your analytical abilities?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
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?