Software Quality – OS BI for Bugzilla – now on Pentaho 3.0 - part 2

The first part of this post can be found here


The Software Quality Report (SQR) were build for version 1.2 of the Pentaho BI Platform.

In this document is the list of changes and fixes for the Penatho BI Platform 3.x from version 1.2 of the Pentaho BI Platform.

 

  1. Pre-Requirements

    • Pentaho Reporting (Reporting)
      can be downloaded at:
      http://sourceforge.net/project/showfiles.php?group_id=51669
       

  1. Run the installation process found in the InstallPentahoBi_WithSQR.odt document
     

  2. Populate the SQR repository is done using the Pentaho Data Integration tool (Kettle).
     

    • The code (Transformations \ Jobs) for this process was compiled to version 1.2 of the Pentaho BI Platform.
      It is recommended to recompile all code (Transformations \ Jobs) for verion 3.x

      • open each transformation \ job found in the $PENTAHO_ROOT/biserver-ce/pentaho-solutions/software-quality/data/etl folder.
         

      • save each transformation \ job
         

    • Some of the transformations \ jobs have bugs in them the below fixes have been made to the transformations \ jobs :
       

      • drop_tables_and_views.kjb
         

        1. Edit the “Drop Views” SQL Script

          Add “if exists” to all drop statements
          e.g.
          drop view v_current_issues;
          Will be changed to:
          drop view if exists v_current_issues;

        2. Edit the “Drop Tables” SQL Script

          Add “if exists” to all drop statements

          e.g.
          DROP TABLE int_issue;
          Will be changed to:

          DROP TABLE if exists int_issue;

      • bugz_int_issue_step3.ktr
         

        1. The STATUS_NAT_ID field is converted to number (and sometime holds space)
          A step to remove the space from the field needs to be added
           

          You can add a calculator \ java script expression to remove the spaces between the “Stream Lookup” and the “Calculator” steps
           

      • summary_fact_issue_monthly.ktr
         

        1. The PRODUCT_NAME and ISSUE_TYPE_NAME cannot be null so another condition is needs in the java_script transformation:


        Change:

        if (prevRow != null &&

        PRODUCT_NAME.getString().equals(prevRow.getString("PRODUCT_NAME", "")) &&

        ISSUE_TYPE_NAME.getString().equals(prevRow.getString("ISSUE_TYPE_NAME", ""))

        ) {


        To be:

        if (prevRow != null &&

        !PRODUCT_NAME.isNull() && !ISSUE_TYPE_NAME.isNull() &&

         

        PRODUCT_NAME.getString().equals(prevRow.getString("PRODUCT_NAME", "")) &&

        ISSUE_TYPE_NAME.getString().equals(prevRow.getString("ISSUE_TYPE_NAME", ""))

        ) {
         

  1. Running the reports using the Pentaho “report-designer”
    biserver-ce/pentaho-solutions/software-quality/reports/

    • Some of the reports s have bugs in them the below fixes have been made to the reports
      The reports can be found in the
      $PENTAHO_ROOT/biserver-ce/pentaho-solutions/software-quality/reports/

       

 

Thank you for your interest!

We will contact you as soon as possible.

Send us a message

Oops, something went wrong
Please try again or contact us by email at info@tikalk.com