Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-10998

Have a Time dimension

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Patch Available
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Trunk, Release Branch 17.12, Release Branch 18.12
    • Fix Version/s: None
    • Component/s: bi

      Description

      The component would benefit from a time dimension for future fact tables and star schema view entities.

      Per comments in OFBIZ-10990:

      As for time. yes we can add a static time dimension having are all time increments between 00:00:00 and 23:59:59. If only using the minute discriminator this would be a table consisting of 1440 records.

      Businesses are not that much interested in sales/purchases/etc. per second, whereas IT more often is (transactions per second), but at least the time dimension will allow doing that in fact tables and star schemas. Businesses are interested in stuff like: how do our sales in the morning compare to sales in the afternoon, and how do our morning sales trend over time....

        Attachments

        1. OFBIZ-10998.patch
          2 kB
          Pierre Smits

          Activity

            People

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

              Dates

              • Created:
                Updated: