Best Practices in OBIEE Physical Layer

1. Use alias for every Dimensional Warehouse tables.
2. Set Connection Pool Maximum Connections to 10. Increasing the number of connections will increase the multiple connections to database so Increase it as per the recommendations by DBA. More connections will result multiple idle sessions which will in turn decrease the performance.
3. Set the appropriate Database Features in the Connection Pool Properties. Sometimes you will encounter the errors related to database features. Align with DBA to find actual features.
4. Turn of cache for the tables which dont require cacheing.
5. Use alias tables to remove Circular Joins.
6. Check for the Data Types for each columns.