Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 3.2.2 GA (3.8.0 GA Suite Release), 3.3.0 GA (4.1.0 GA Suite Release), 3.4.1 GA (4.5.0 GA Suite Release)
    • Component/s: None
    • Labels:
      None
    • Environment:
      3.8.0-GA to 4.5-RC
    • Customer Case:
    • QA Validation Status:
      Validated by QA
    • CI Build:
      Nightly
    • SP:
      SP03

      Description

      Currently in 3.8 but this issue happens through 4.5RC. Please attach the schema and datadump to recreate scenario. To recreate the NullPointerException please run through the following steps:
      1. Choose "Program Opportunity Analysis" virtual cube. Build a report with "Program Channel", "Program Name", "Program Cost", "(MT) Pipeline Created, (MT) Opportunities Created, and Average Pipeline Amount. Also add subtotal to the report Please refer to "original_report.png" attachment. The Average Pipeline Amount is a calculated member. Its definition is (MT) Pipeline Created / (MT) Opportunities Created. Please refer to "calculated_member.png" attachment.

      2. Add "# of Opportunities Associated with Program" metrics to the report, and the exception occurred. Please refer to "exception.png" attachment. It also generated exception in pentaho.log file

      3. Click on "Undo" button. Uncheck the "Calculate subtotals using number formula" checkbox in the calculated member definition. Add "# of Opportunities Associated with Program" metrics to the report. The exception occurred again.

      4. Click on "Undo" button". Remove "Subtotal" from the report definition. Then add "# of Opportunities Associated with program" to the report. The report is OK without exception. Please refer to "No-Subtotal.png" attachment.

      5. Remove the calculated member from the report, and add subtotal back in the report. The report is OK without exception. Please refer to "remove_calculated_member_add_subtotal.png" attachment.

      6. Remove "Program Channel" from the report, and add calculated member back in the report. The report is OK without exception. Please refer to "remove_channel_member_add_calculated_member.png" attachment.

      7. Add a filter to Exclude "Selling Sun Glasses" program from the report, and add program channel back in the report. The report is OK without exception. Please refer to "exclude_selling_sun_glass_progrm.png" attachment.
      1. Mondrian1125.xmi
        5 kB
        Li Deng
      2. stdout_20120515.log
        170 kB
        Li Deng
      1. screenshot-1.jpg
        337 kB

        Activity

        Hide
        Brandon Bruce added a comment -
        Please retest this on the nightly build.
        Show
        Brandon Bruce added a comment - Please retest this on the nightly build.
        Hide
        Li Deng added a comment -
        Follow the steps and no longer encounter the error.
        Show
        Li Deng added a comment - Follow the steps and no longer encounter the error.
        Hide
        Li Deng added a comment -
        Attached the schema file.
        Show
        Li Deng added a comment - Attached the schema file.
        Hide
        Brandon Bruce added a comment -
        reopened to add 4.8.1 subtask and then reclosed
        Show
        Brandon Bruce added a comment - reopened to add 4.8.1 subtask and then reclosed
        Hide
        Curtis Boyden added a comment -
        Validated in 4.8.1
        Show
        Curtis Boyden added a comment - Validated in 4.8.1

          People

          • Assignee:
            Marc Batchelor
            Reporter:
            Marc Batchelor
          • Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: