Versions Compared

Old Version 1

changes.mady.by.user Pierre Smits

Saved on

compared with

New Version Current

changes.mady.by.user Pierre Smits

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: updated the description

Introduction

The time dimension is intended for those fact tables and star schemas that need to capture performance measurements related to time slots in a day.

Table of Contents

Description

The time dimension is not derived from any OFBiz entity as it is a generic dimension, and as such contains all time elements in a day. These elements are minute based, leading to 1440 records.

and consists of following elements (fields):

name

alias

type

description

dimensionId
id-longthe unique identifier of the record
timeValue
timethe natural key, in hh:mm format
hr
integer

the hour value of the time value

mm
integerthe minute value of the time value


Related tickets

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