BEx Analyzer Best Practices

Text Body:
1. understand how many users you have and what data they use: -analyze your OLAP SQL via transaction RSRT and other DB tools -use the BW Statictics cubes to analyze front-end performance -use aggregates instead of cubes 2. Size the system correctly -make sure you have enough memory 3. limit the result set returned by a query: -filter reports -use mandatory variables to limit the result set returned 4. optimize your InfoProviders: -minimize navigational attributes -use smaller InfoProviders and MultiProviders -create secondary indeces -partition InfoProviders, and create queries based on time -archive unused or minimally used data -compress your cubes