There are no magical solutions and no one-click options for solving performance issues in analytical systems. The secret is root cause analysis, and if you work with Oracle Business Intelligence, Christian Berg's 2 Minute Tech Tip will get you there.