Introduction

The asset dimension is intended for those fact tables and star schemas that need to capture performance measurements related to (fixed) assets.

Description

The asset dimension is derived from:

  1. FixedAsset entity


and consists of following elements (fields):

namealiastypedescription
dimensionId
id-longthe unique identifier of the record
assetId
idthe natural (primary) key from table 1 (see above).
assetName
description

The name of the assetl. 






Related tickets