Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

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

Table of Contents

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

Jira
serverASF JIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
maximumIssues20
jqlQueryproject = OFBIZ AND labels = ProjectDimension ProjectTaskDimension ORDER BY status DESC, key DESC
serverId5aa69414-a9e9-3523-82ec-879b028fb15b