Introduction

The facility dimension is intended for those fact tables and star schemas that need to capture performance measurements related to facilities.

Description

The facility dimension is derived from:

  1. Facility entity


and consists of following elements (fields):

name

alias

type

description

dimensionId
id-longthe unique identifier of the record
facilityIdfacilityidthe natural (primary) key from table 1 (see above): facilityId
facilityName
description

The name of the facility. 






Related tickets