Physical Layer Best practices in OBIEE

PHYSICAL LAYER

• Don't import foreign keys from the database.
• Avoid circular joins by using alias tables.
• Use a different connection pool for different data sources.
• Use a different connection pool for variables,data sources and security configuration.
• Establish the joins in the physical layer based on the data-modelling or client requirement.
• Use the max no.of users for each connection pool.
• Delete the unused physical objects from the layer by using Remove unused physical object utility.
• Update the row-count by using Update physical layer to check the database connection.
• Avoid hints in the physical table level
• Don't establish join between fact and fact table
• Avoid to create a view or physical select statement in the physical layer
• Remove the unused connection pools,it might lead to BI server crash as it continuously ping to the connection.
• Better to disable the database features in the DB-features configuration file.
• Always use a data-ware house or OLAP(online analytical processing) system as a database for geenrating reports.
• Use proper naming convention for physical table and alias table also.
• Always define your catalog under projects.
• Ensure to check "execute queries asynchronously" option in the connection pool details.

BMM Layer best Practices

Presentation Layer Best Practices