[OFBIZ-10953] have CurrencyDimension have a dimensionId that is based on the natural key

• Type: Sub-task
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Trunk, Upcoming Branch
• Component/s: bi
• Labels: CurrencyDimension birt currency dimension dwh
• Assignee: Pierre Smits
• Reporter: Pierre Smits
• Created: 24/Apr/19 13:51
• Updated: 11/Jan/22 08:48

Description

Currently the record sequencer (delegator.getNextSeqId) is used to determine the dimensionId for the CurrencyDimension. This is unnecessary as the uomId from the UOM table can be used for currency.

It also makes it easier to set the foreign-key in fact tables by generating it based on the date provided, than by retrieving the dimensionId based on a retrieval through the getDimensionIdFromNaturalKey service.