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
- 3 Answers
- 7659 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.
what is dashboards? what is metrics?
can any body tell me how to create Hyperlinks in BO XI R2?
how did u give developed universe to ur client?
what is incompactabulity error in sap bo
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.
WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT
9 Answers Business Intelligence Analytics, SRA,
Hi, How to navigate one report to another report in webi? Thanks in Advance
Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski
what are cascading prompts explain with steps
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
Teradata 
