Here are some general design recommendations for improving Web Analysis document load times. Please note that these recommendations do not represent limitations of the product, but general guidelines to allow a document to load faster. All references to a “query” are referring to one Report Data Source in a document.
No more than four (4) queries per document.
No more than 100,000 of cells returned on a query.
No more than four (4) OLAP selection/subscription controls that have “dynamic” enabled per Web Analysis document and should only contain a maximum of 5000 members for each.
No more than 1000 pages on a query.
No more than twenty (20) Traffic Lighting definitions with a maximum of seven (7) levels per query.
No more than twenty (20) Show/Hide definitions per query.
No more than twenty (20) Calculations per query.
No more than twenty (20) Data Formatting definitions per query.
Only one (1) Retrieve Top/Bottom per query.
No more than twenty (20) Restrict Data conditions per query.
No more than 1/2 MB of total size of graphics on a Web Analysis document. This includes graphics used on pinboards.
When LROs or Integration Services Drill Through report are not necessary, disable the Show Linked Reporting Object Indicators to improve performance.
When using advanced member selections to apply database formatting on a database connection, limit the use on small outlines no more than 10,000 members.