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

Topcount aggregate incorrect for constrained measure

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • 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.
    • Sprint Team:
      Maintenance

      Description

      The MDX below produces an incorrect value. The result is the sum of the top 10 based on My Sales instead of Unit Sales.

      with
      MEMBER [Measures].[My Sales] AS '([Measures].[Store Cost],[Store].[All Stores].[USA].[OR])'
      MEMBER [Product].[topcount] AS ' AGGREGATE(TOPCOUNT(

      {[Product].[Product Name].MEMBERS}

      , 10, [Measures].[Unit Sales]), [Measures].[My Sales])'
      select {
      {[Measures].[My Sales]}}
      on AXIS(0),

      {[Product].[topcount]}

      on AXIS(1)
      from [Sales]

        Attachments

          Activity

            People

            Assignee:
            pavel_hrakovich Pavel Hrakovich (Inactive)
            Reporter:
            walkerku walkerku
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: