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 / 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 |
What is the difference between the prompt and cascading prompt
Explain how we drill up week to month?
Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.
date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2
Instead of cms which server you have to use?
In Business Objects 4.1 version what is the alternative name for broadcast agent?
how to restrict up to three levels in hierarchy when u do drill mode?
1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?
1.what is context? How u create? With example.
can we cretae views in universe level?
2.What is loop? How resolve the loop?explain it?
11 Answers TCS, UHG,
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record