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

Improve the BI component

    XMLWordPrintableJSON

    Details

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

      Description

      Improving the BI component enhances the feature set of OFBiz.

      The BI component is essential for doing analysis (trend and otherwise) on data captured from transactions, while avoiding heavy (query) loads on the transaction system. An additional benefit is that data analysts don't need access/permissions to the transaction system.

      This is a placeholder ticket to capture all underlying tickets (tasks)

        Attachments

          Issue Links

          1.
          Have a Time dimension Sub-task Patch Available Pierre Smits  
          2.
          Have a service to load records in the Catalog dimension Sub-task Closed Unassigned  
          3.
          Have an AssetUtilisationFact entity Sub-task Open Pierre Smits  
          4.
          Have a service to load records in the asset dimension Sub-task Patch Available Pierre Smits  
          5.
          Have an AssetDimension Sub-task Patch Available Pierre Smits  
          6.
          Have a service to load records in the sales promo dimension Sub-task Patch Available Pierre Smits  
          7.
          Have a SalesPromo Dimension Sub-task Patch Available Pierre Smits  
          8.
          Have a service to load records in the project task dimension Sub-task In Progress Pierre Smits  
          9.
          Have a ProjectTask Dimension Sub-task Patch Available Pierre Smits  
          10.
          Have a service to load records in the carrier dimension Sub-task Patch Available Pierre Smits  
          11.
          Have a service to load records in the account dimension Sub-task Patch Available Pierre Smits  
          12.
          Have an Account Dimension Sub-task Patch Available Pierre Smits  
          13.
          Improve the SalesInvoiceItemFact regarding dimensions Sub-task Patch Available Pierre Smits  
          14.
          Have a service to load records in the supplier dimension Sub-task Patch Available Pierre Smits  
          15.
          Have a service to load records in the store dimension Sub-task Patch Available Pierre Smits  
          16.
          Have a service to load records in the sales channel dimension Sub-task Patch Available Pierre Smits  
          17.
          Have a service to load records in the pos terminal dimension Sub-task Patch Available Pierre Smits  
          18.
          Have a service to load records in the project dimension Sub-task Patch Available Pierre Smits  
          19.
          Have a PoSTerminal Dimension Sub-task Patch Available Pierre Smits  
          20.
          Have a service to load records in the customer dimension Sub-task Patch Available Pierre Smits  
          21.
          Have a service to load records in the organisation dimension Sub-task Patch Available Pierre Smits  
          22.
          Have a service to load records in the facility dimension Sub-task Patch Available Pierre Smits  
          23.
          Have a Project Dimension Sub-task Patch Available Pierre Smits  
          24.
          Have an Organisation Dimension Sub-task Patch Available Pierre Smits  
          25.
          Have a service to load records in the TimeEntryFact entity Sub-task Open Pierre Smits  
          26.
          Have a TimeEntryFact entity Sub-task Open Pierre Smits  
          27.
          Have DateDimension adhere to ISO 8601 standard Sub-task Closed Unassigned  
          28.
          Have a Carrier dimension Sub-task Patch Available Pierre Smits  
          29.
          service 'loadSalesOrderItemFact' has hard coded currencyUomId Sub-task Closed Pawan Verma  
          30.
          Improve SalesOrderItemFact table Sub-task Patch Available Pierre Smits  
          31.
          Documentation: SalesInvoiceItemStarSchema Design Updates Sub-task Patch Available Pierre Smits  
          32.
          Have an Employee dimension Sub-task Patch Available Pierre Smits  
          33.
          Have a Supplier dimension Sub-task Patch Available Pierre Smits  
          34.
          Have a Brand dimension Sub-task Closed Pierre Smits  
          35.
          Have a SalesChannel dimension Sub-task Patch Available Pierre Smits  
          36.
          Have a Facility dimension Sub-task Patch Available Pierre Smits  
          37.
          Improve the SalesInvoiceItemStarSchema Sub-task Patch Available Pierre Smits  
          38.
          Have a ProductCategory Dimension Sub-task Closed Pierre Smits  
          39.
          Have a Catalog Dimension Sub-task Closed Pierre Smits  
          40.
          Have a Store Dimension Sub-task Patch Available Pierre Smits  
          41.
          have CurrencyDimension have a dimensionId that is based on the natural key Sub-task Patch Available Pierre Smits  
          42.
          Have a service to load records in the CountryDimension Sub-task Patch Available Pierre Smits

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 10m
          43.
          Have a Country Dimension Sub-task Closed Pawan Verma

          100%

          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 20m
          44.
          Have DateDimension have a dimensionId that is based on the natural key Sub-task Patch Available Pierre Smits  
          45.
          Have a seca to load records in the CustomerDimension Sub-task Closed Pierre Smits  
          46.
          loadSalesInvoiceFact doesn't get invoked on setInvoiceStatus Sub-task Closed Pierre Smits  
          47.
          Have a Customer Dimension Sub-task Patch Available Pierre Smits  
          48.
          getDimensionIdFromNaturalKey should return '_NF_' when no Dimension record found Sub-task Patch Available Pierre Smits  
          49.
          Improve InventoryItemStarSchema Sub-task Open Pierre Smits  
          50.
          Improve the InventoryItemFact regarding dimensions Sub-task Patch Available Pierre Smits  
          51.
          Make ReportBuilder more dynamic Sub-task Patch Available Pierre Smits  
          52.
          Improve the ProductDimension Sub-task Open Pierre Smits  
          53.
          prepareProductDimensionData does not load correct fields in ProductDimension Sub-task Closed Pawan Verma  
          54.
          Moving field type of dimensionId fields from 'id' to 'integer' Sub-task Patch Available Pierre Smits  
          55.
          Improve loadSalesOrderItemFact Sub-task Patch Available Pierre Smits  
          56.
          Improve SalesOrderItemStarSchema Sub-task Patch Available Pierre Smits  
          57.
          Replace BI main page content in labels with content data Sub-task Patch Available Pierre Smits  
          58.
          improve loadSalesOrderItemFact re dimension and fact entity changes Sub-task Patch Available Pierre Smits  
          59.
          The loadDateDimension service is loading incorrect weekOfYear field. Sub-task Closed Pierre Smits

          0%

          Original Estimate - 24h
          Remaining Estimate - 24h
          60.
          Have a function to manage the configuration of the BI component Sub-task Patch Available Pierre Smits  
          61.
          Move dwh update services from ECA based to scheduled based Sub-task Patch Available Pierre Smits  
          62.
          Make initialisation of the DWH more dynamic Sub-task Patch Available Pierre Smits  
          63.
          Have entities, functions and services to support Procurement Analysis Sub-task Patch Available Pierre Smits  

            Activity

              People

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

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - 24h Original Estimate - 24h
                  24h
                  Remaining:
                  Time Spent - 40m Remaining Estimate - 24h
                  24h
                  Logged:
                  Time Spent - 40m Remaining Estimate - 24h
                  40m