Versions Compared

Old Version 1

changes.mady.by.user Pierre Smits

Saved on

compared with

New Version 2

changes.mady.by.user Pierre Smits

Saved on

Key

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

Introduction

The carrier dimension is intended for those fact tables and star schemas that need to capture performance measurements related to in- and out-bound shipments from and to facilities.

Table of Contents

Description

The carrier dimension is derived from:

  1. PartyRoleNameDetail entity

, and consists of following elements (fields):

namealiastypedescription
dimensionId
id-longthe unique identifier of the record
partyId
idthe natural (primary) key from table 1 (see above): partyId
partyName
description

The name of the party. Value is dependent on the partyTypeId of the PartyRoleNameDetail entity:

  1. if partyRoleTypeId = PARTY_GROUP: groupName
  2. if partyRoleTypeId = PERSON: lastName, firstName


Related tickets

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