Versions Compared

Key

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

Introduction

The customer dimension is intended for those fact tables and star schemas that need to capture performance measurements in the sales domain.

Table of Contents

Description

The customer dimension is derived from:

  1. PartyRoleNameDetail entity

The discriminating factor is the roletypeId (value = "CUSTOMER")

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 = CustomerDimension ORDER BY status DESC, key DESC
serverId5aa69414-a9e9-3523-82ec-879b028fb15b