Versions Compared

Key

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

Introduction

The country 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 country dimension is derived from:

  1. geo entity

The discriminating factor is the geoTypeId (value = "COUNTRY")

and consists of following elements (fields):

name

alias

type

description

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

The name of the country

geoCode
short-varchar
abbreviation
short-varchar
telCountryCode
short-varchar
ccTld
short-varchar


Related tickets

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