This Confluence has been LDAP enabled, if you are an ASF Committer, please use your LDAP Credentials to login. Any problems file an INFRA jira ticket please.

Child pages
  • Customer Dimension

Access to add and change pages is restricted. See: https://cwiki.apache.org/confluence/display/OFBIZ/Wiki+access

Skip to end of metadata
Go to start of metadata

Introduction

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

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

Key Summary T Created Updated Due Assignee Reporter P Status Resolution
Loading...
Refresh

  • No labels