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

Improve the BI component

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • Trunk, Upcoming Branch, 22.01.01
    • None
    • bi

    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

          is related to

          Sub-task - The sub-task of the issue OFBIZ-10948 Convert DimensionServices.xml minilang to groovy

          • Major - Major loss of function.
          • Closed

          Sub-task - The sub-task of the issue OFBIZ-11030 Convert FactServices.xml minilang to groovy

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. OFBIZ-10955 field type Integer is missing in definitions

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #11

          Wiki Page

          Wiki Page Loading...

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

          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 Closed Michael Brohl  
          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 Closed Michael Brohl  
          48.
          		 getDimensionIdFromNaturalKey should return '_NF_' when no Dimension record found Sub-task Closed Michael Brohl  
          49.
          		 Improve InventoryItemStarSchema Sub-task Closed Michael Brohl  
          50.
          		 Improve the InventoryItemFact regarding dimensions Sub-task Closed Michael Brohl  
          51.
          		 Make ReportBuilder more dynamic Sub-task Closed Michael Brohl  
          52.
          		 Improve the ProductDimension Sub-task Closed Michael Brohl  
          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 Closed Michael Brohl  
          55.
          		 Improve loadSalesOrderItemFact Sub-task Closed Michael Brohl  
          56.
          		 Improve SalesOrderItemStarSchema Sub-task Closed Michael Brohl  
          57.
          		 Replace BI main page content in labels with content data Sub-task Closed Michael Brohl  
          58.
          		 improve loadSalesOrderItemFact re dimension and fact entity changes Sub-task Closed Michael Brohl  
          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 Closed Michael Brohl  
          61.
          		 Move dwh update services from ECA based to scheduled based Sub-task Closed Michael Brohl  
          62.
          		 Make initialisation of the DWH more dynamic Sub-task Closed Michael Brohl  
          63.
          		 Have entities, functions and services to support Procurement Analysis Sub-task Closed Michael Brohl  

          Activity

            People

              pierresmits Pierre Smits
              pierresmits Pierre Smits
              Votes:
              0 Vote for this issue
              Watchers:
              3 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