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
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 |
what is main functional differences between BO and COGNOs?
What is the prm file ? can anybody explain me ?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
How many universes can be created in a project?
What is ment by For each For all function. In which case we use the option in BO?
1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.
REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST
What are the major problems will occur while migrating to the one version to another version?
4.what is repository? types
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.
hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks