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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Indexing? how did u implement indexing?

2568


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1267


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

2348


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?

11018


Difference between zabo and webi?

1153


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4780


What would you consider as your biggest achievement and why?

1063


Explain when we use aggregate awareness function in designer?

1091


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

2472


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:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3886


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3639


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1214


Explain which versions are used in the bo dashboard work?

1125


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?

1071


what is xcelsius architecture?

4639