Answer Detail: RE: What are the steps to taken care to improve the Report performance?

GeekInterview.com > Interview Questions > Data Warehousing > BO Designer

Print |

Question: What are the steps to taken care to improve the Report performance?

September 09, 2005 01:35:13	#1
jagadeswarreddy.palagani	Member Since: Visitor Total Comments: N/A
RE: What are the steps to taken care to improve the Report performance?
In DESIGNER Level 1)eliminate the unnecessory joins 2)use conditions as much as at the database level 3)edit the SQL query in the Query Panel as per requirment In REPORTER level 1)eliminate the filters as much as possible 2)try to reduce the user variables