BusinessObjects Semantic Layer - Best Practices Accessing Databases
When it comes to optimization of a BI deployment and of the performance of queries on very large databases (VLDBs), each situation has specific issues and specific solutions. The Business Objects semantic layer allows for personalized optimization settings while adapting to any data model and source type. Optimizations can be added at different levels: database, connectivity, universe, and report. Improvements and additional tunings can be done during the whole lifecycle of the BI solution with a minimal or even null impact on the final user workflows (but for an improved performance).