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

Improve the SalesInvoiceItemStarSchema

    XMLWordPrintableJSON

Details

    Description

      The star schema should be improved to include elements from:

      • Customer dimension -for aggregations per customer
      • Country dimension - for aggregations per country
      • Date dimension - for aggregations per date
      • Store dimension - for aggregations per store
      • Channel dimension - for aggregations per sales channel
      • Time dimensions - for aggregations per time slot

      Attachments

        Issue Links

          depends upon

          Sub-task - The sub-task of the issue OFBIZ-10944 Have a Customer Dimension

          • Major - Major loss of function.
          • Closed

          Sub-task - The sub-task of the issue OFBIZ-10954 Have a Country Dimension

          • Major - Major loss of function.
          • Closed

          Sub-task - The sub-task of the issue OFBIZ-10986 Have a Store Dimension

          • Major - Major loss of function.
          • Closed

          Sub-task - The sub-task of the issue OFBIZ-10987 Have a Catalog Dimension

          • Major - Major loss of function.
          • Closed

          Sub-task - The sub-task of the issue OFBIZ-10988 Have a ProductCategory Dimension

          • Major - Major loss of function.
          • Closed

          Sub-task - The sub-task of the issue OFBIZ-10991 Have a SalesChannel dimension

          • Major - Major loss of function.
          • Closed

          Sub-task - The sub-task of the issue OFBIZ-10998 Have a Time dimension

          • Major - Major loss of function.
          • Closed

          Sub-task - The sub-task of the issue OFBIZ-11082 Improve the SalesInvoiceItemFact regarding dimensions

          • Major - Major loss of function.
          • Closed
          is depended upon by

          Sub-task - The sub-task of the issue OFBIZ-11012 Documentation: SalesInvoiceItemStarSchema Design Updates

          • Major - Major loss of function.
          • Patch Available

          Activity

            People

              mbrohl Michael Brohl
              pierresmits Pierre Smits
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: