Best Practices of Presentation Layer in OBIEE

1. Presentation catalog should map to one Business model & mapping layer(BMM) layer objects only.
2. Use parent folders and sub-folders to group facts and similar dimensions together.
3. Avoid the use of aliases when a new presentation column is created.
4. The presentation columns in a table should be sorted alphabetically if no specific order is asked by the customer.
5. Make proper use of the permissions in this layer like authentication and authorization.
6. Don’t use special symbols (“) in column name, though its permitted.
7. Presentation columns should not have the same name as presentation table.
8. Eliminate unneeded objects to reduce user confusion.
9. Limit number of objects in folder to 7-12 (for performance tuning only).
10. Use object description field to convey information to users when they hover the mouse in answers on a presentation column.
11. Keep names short to have space on reports and give the meaningful table names and columns names to identify easily on subject areas. Remove primary key columns and other unnecessary columns that does not going to use in the creation of the reports.
12. Try to create separate folder for each data mart(HR, operation, SCM, sales) if it is coming from same logical layer.
13. Get costumer sign off of the presentation layer structure before building reports. This will avoid later replacements of columns which affects the reports constructed.

BMM Layer Best practices in OBIEE

Physical Layer Best practices in OBIEE