BO Webi report in running fine in Dev but takes a long time
to run in Production environment, how to reduce this
processing time.

Answer Posted / shamanth

It purely depends on the envi. in which you are running the
report.

1)DEV may have few records used for dev. and testing
purpose,where as Prod will have more data in real time
scenario.
2)Also make sure that u have exported all indexes
(Clustered,non-clustered) from DEV to Prod.
3)Also if concurrent users running the same instance then
the performance mioght be slow...

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What Is The Difference Between Oltp And Olap?

682


Explain how many universes can be created in a project?

620


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

9882


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1588


Explain how we drill up week to month?

643






Explain what is the difference between business requirement document and use case document.

579


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1817


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

1973


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1001


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

1628


Explain what are the steps to be taken to schedule the report?

639


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

1749


What is the profile and package?

1767


how get the grand total in master-detail report?

1819


What is a bo repository?

596