Home | Ciber
Knowledge page of Ciber Netherlands

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.

clip_image002

1.1 Business Model Name

clip_image004

Format: “BM_”+ModelName

1.2 Logical Display Folder Name:

clip_image006

Format: “LD_” + FolderName

1.3 Logical Table Name:

clip_image008

Format: <<TableType>>+ table name

TableType:

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

1.4 Logical Dimension / Hierachy Name:

clip_image010

Format: TableName + “Dim”

1.5 Logical Join

clip_image012

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

No comments yet. Be the first.

Leave a reply