Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-703

Wrong behaviour using NOT EMPTY clause in MDX queries with compound slicers

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Duplicate
    • Affects Version/s: 3.5.0 Suite Release
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Hi all,

      I get a strange behaviour while making an MDX query on modrian using the NOT EMPTY clause together with compound slicers.

      The problem is summarized below:

      • If I made an MDX query applying the compound slicers functionality but without using the NOT EMPTY clause the result given by the system is correct
      • as soon as I apply to the same query the NOT EMPTY clause the query gives me a different set of rows. The set of rows returned applying the NOT EMPTY clause doesn't contains all the rows returned without appying it (they are less in number respect to the case without using the NOT EMPTY clause).

      I attached a sample that can help you in reproducing the problem. Copy the attached .analisysview.xaction file under Steel-Wheels, refresh repository cache and open the analisys. After you viewed the results without the NOT EMPTY clause, press the NOT EMPTY button on the toolbar and you'll see a different set of lines as described above.

        PractiTest Integration




          Attachments

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              sramazzina Sergio Ramazzina
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: