OBIEE Naming Conventions – Business Model Layer

This Article is only a guideline to an OBIEE naming convention for the repository. The most important aspect of a naming convention is that you use it consistently. The used naming convention should be readable for any future development.

1.1 Business Model Name

Format: “BM_”+ModelName

1.2 Logical Display Folder Name:

Format: “LD_” + FolderName

1.3 Logical Table Name:

Format: <<TableType>>+ table name

TableType:

• “Dim” = Dimension Table
• “Fact” = Fact Table
• “Bridge” = Bridge Table

1.4 Logical Dimension / Hierachy Name:

Format: TableName + “Dim”

1.5 Logical Join

Format: “RLS_”+Driving Table Name + “_”+ Receiving Table Name + <<Join Type if not inner join>>

Join Type if not inner join:

• RO = Right Outer Join
• LO = Left Outer Join