Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-11414 Improve the BI component
  3. OFBIZ-10947

Have DateDimension have a dimensionId that is based on the natural key

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • Release Branch 16.11, Trunk, Upcoming Branch
    • None
    • bi

    Description

      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.

      Attachments

        Issue Links

          is depended upon by

          Sub-task - The sub-task of the issue OFBIZ-11438 Improve InventoryItemStarSchema

          • Major - Major loss of function.
          • Open

          Sub-task - The sub-task of the issue OFBIZ-11459 Improve the InventoryItemFact regarding dimensions

          • Major - Major loss of function.
          • Patch Available

          Activity

            People

              pierresmits Pierre Smits
              pierresmits Pierre Smits
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated: