Home | Ciber
Knowledge page of Ciber Netherlands

OBIEE Naming Conventions – Physical Layer

clip_image002

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 Database Name

clip_image004

Format: “DB_”+DatabaseName

1.2 Connection Pool Name

clip_image006

Format: “CP_”+ DatabaseName + Read / write attributes

Read / write attributes:

  • “RO” = Read Only
  • “RW” = Read Write

1.3 Physical Display Folder Name

clip_image008

Format: “PD_” + Foldername

1.4 Physical Catalog Name

clip_image010

Format: Official Database name (Microsoft) or Schema Name (Oracle)

Depending on the database this can be case sensitive.

1.5 Physical Schema Name (Microsoft)

clip_image012

Format: Official Schema name (Microsoft). Depending on the database version this can be case sensitive.

1.6 Physical table name

clip_image014

Format: Official table name. Depending on the database version this can be case sensitive. Be aware of trailing spaces.

1.7 Alias table name

clip_image016

Format: TableName + “_A” + 2 digit sequence number start = 01(for each table)

1.8 Physical Foreign Key

clip_image018

Format: Table01+ “_”+ Table02 + “FKey”

No comments yet. Be the first.

Leave a reply