Best Practices in Presentation Layer(OBIEE)

• Catalog should map to one Business Model & Mapping Layer (BMM) Layer objects only.
• Use Parent Folders and Sub folders to group Facts and similar Dimensions together.
• Avoid the use of Aliases when a new Presentation Column is created.
• The Presentation Columns in a table should be sorted alphabetically if no specific order is asked by the customer.
• Get Customer Sign-off of the Presentation layer structure before building reports. This will avoid later replacements of columns which affects the reports constructed.
• Make proper use of the Permissions in this layer.
• Don’t use Double quotes (“) in Column name, though its permitted.
• Presentation columns should not have the same name as Presentation Table.
• Eliminate unneeded objects to reduce user confusion.
• Limit Number of objects in folder to 7-12.
• Use Object  description field to convey information to users when they hover the mouse in Answers on a Presentation column.
• Keep names short to have space on reports.
• Give the meaning table names and columns names to identify easily on subject areas.
• Try to create separate folder for each data mart (HR, Operation, SCM, sales) if it is coming from same Business Model & Mapping Layer.
• Remove primary key columns and other unnecessary columns that doesn't going to use in the creation of the reports.