how to optimize the query perfomance in b.o?

Answer Posted / srinivas

hi

u can select the limit size of exegution is increase button
in universe parameters

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1749


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4449


What three things do you consider to be the most important factors for a manager?

599


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1401


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1691






What we need to discuss with designer before starting the universe designing.

1822


What is object stores?

583


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1626


What are the data types present in bo? What happens if we implement view in the designer and report?

622


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1757


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?

557


Explain in detail about type 1?

658


What are the steps to be taken to schedule the report?

558


Can Bo generates the Report from the cubical data Explain?

1628


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

1783