Limit the number of Data Providers Used

Push down operations towards the Database/Universe which means

Retrieve aggregated data instead of AGGREGATION within the document

Do not (accidentally) disable the cache mechanism of Web Intelligence

Web Intelligence has a great CACHING mechanism for documents that have already been viewed. Using Cache improves the load time of documents; HOWEVER there are a few functions within Web Intelligence that will prevent the use of the Cache. 

These functions are:

• Current Time ()
• Current Date ()
• Username ()
• Avoid Auto-Fit When possible
• Avoid CHARTS with a HIGH number of Data Points
• Limit use of “Scope of Analysis”
• Build lean reports by having as little calculations as possible.
• Use Query filters instead of Report Filters
• Ensure Query Stripping is utilized

Limit the number of Data Providers Used

Push down operations towards the Database/Universe which means

Retrieve aggregated data instead of aggregation within the document

Do not (accidentally) disable the cache mechanism of Web Intelligence

Web Intelligence has a great caching mechanism for documents that have already been viewed. Using Cache improves the load time of documents; however there are a few functions within Web Intelligence that will prevent the use of the Cache. 

These functions are: