Introduction

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

Description

The project dimension is derived from:

  1. WorkEffort entity


and consists of following elements (fields):

namealiastypedescription
dimensionId
id-longthe unique identifier of the record
taskId
idthe natural (primary) key from table 1 (see above): workEffortId, from records where the workEffortTypeId = "TASK"
taskName
description

The name of the project task. 

description
description





Related tickets