Pierre Smits created OFBIZ-10947:
------------------------------------
Summary: Have DateDimension have a dimensionId that is based on
the natural key
Key: OFBIZ-10947
URL: https://issues.apache.org/jira/browse/OFBIZ-10947
Project: OFBiz
Issue Type: Improvement
Components: bi
Affects Versions: Release Branch 16.11, Trunk, Release Branch 17.12,
Release Branch 18.12
Reporter: Pierre Smits
Assignee: Pierre Smits
Currently the record sequencer (delegator.getNextSeqId) is used to determine
the dimensionId for the DateDimension. This is unnecessary as the date (when
correctly formatted) can be used.
When formatted as 'yyyyMMdd' a dimensionId could be 20190423, which is a
correctly 'sequenced' primary key.
It also makes it easier to set the foreign-key in fact tables by generating it
based on the date, than by retrieving the dimensionId based on a retrieval
through the getDimensionIdFromNaturalKey service.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
