Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


if we run a report it is taking so much time to display the
report,what to do to increase th performance of the report

Answers were Sorted based on User's Feedback



if we run a report it is taking so much time to display the report,what to do to increase th perfo..

Answer / srikanth

Remove unnecessary objects and variables if any.make sure
you remove alerters if any unless it is the
requirement.Take the report query and run in Database.See
how much time its taking.From report query check whether
in 'where' clause columns have indexes.If not discuss with
oracle admin and add indexes.

Is This Answer Correct ?    5 Yes 0 No

if we run a report it is taking so much time to display the report,what to do to increase th perfo..

Answer / ilaw

If the question is not pertaining to query optimization, I
would prefer not to use much of formatting on the page. One
can keep the report without any page formatting as this
would take a very long time. Try not to use the slice &
dice panel as this would also take considerably long time...

Is This Answer Correct ?    1 Yes 0 No

if we run a report it is taking so much time to display the report,what to do to increase th perfo..

Answer / vams_gk

if we run a report it is taking so much time to display the
result to be fallowed as :

1) use aggrigate tables(contains pre caliculated data)
2)pre defined conditions,LOV's
3)in a real time senario query contains a large if
statements.some times we need to wait max of 30 min to run
perticular statement...not all

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Business Objects Interview Questions

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?

2 Answers  


How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.

1 Answers   Cap Gemini, TCS,


what do u mean by merged dimensions in Business Objects

2 Answers   Business Intelligence Analytics, TCS,


. User wants to modify a report and wants to add additional data. How will you approach.

2 Answers  


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

0 Answers  


what are the debuggings in the business objects?

1 Answers   IBM,


how to improve the performance of the report

3 Answers  


What problems you have faced while creating an universe? tell me an incident and how you went about solving it?

1 Answers   Fidelity,


When we can use multiple sql statement for each measure? and multiple sql statement for each context?

2 Answers  


What is the short cut join?

2 Answers   Wipro,


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

0 Answers  


define universe parameters?

5 Answers  


Categories