Introduction

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

Description

The account dimension is derived from:

  1. PartyRoleNameDetail entity

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

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