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

Native Top Count cannot handle empty members

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 3.5.0 GA (4.8.0 GA Suite Release)
    • Fix Version/s: 6.1.0 GA
    • Component/s: 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.
    • Sprint Team:
      Maintenance

      Description

      Native top count will always strip out empty members from its set argument.

      Using Foodmart sales cube, having 'unit sales' only under [Customers].[USA].

      select [Measures].[Unit Sales] on 0,
      TopCount(
      Crossjoin([Product].[Product Category].Members
      , [Customers].[City].Members),
      10) on 1
      from [Sales]
      where [Time].[1997].[Q3]

      This should return Canadian cities but instead ignores members with no entries in the fact table and returns US cities.

      A simpler case, using the third argument in top count:

      select [Measures].[Unit Sales] on 0,
      TopCount(
      [Customers].[Country].Members,
      2,
      [Measures].[Unit Sales]) on 1
      from [Sales]
      where [Time].[1997].[Q3]

      Will only return the first row if evaluated natively, instead of the two that are expected:

      [Measures].[Unit Sales]
      [Customers].[USA] 65,848
      [Customers].[Canada]

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              AKarneichyk Alena Karneichyk (Inactive)
              Reporter:
              tgf Tiago Gomes Ferreira
              Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: