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

Intersect should return any VisualTotals members in right-hand set

    Details

    • 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

      Anton Nikitin wrote:

      > Today I was experimenting with Excel 2007 pivot
      > tables and found that it generates a bit crazy MDX
      > statements.
      >
      > For example, very simple GUI navigation steps cause
      > the following MDX:
      >
      > WITH
      > SET [XL_Row_Dim_0] AS 'VisualTotals(Distinct(Hierarchize(

      {Ascendants([Customers].[All Customers].[USA]), Descendants([Customers].[All Customers].[USA])}

      )))'
      > SELECT
      > NON EMPTY Hierarchize(

      {[Time].[Year].members}

      ) ON COLUMNS ,
      > NON EMPTY Hierarchize(Intersect({DrilldownLevel(

      {[Customers].[All Customers]}

      )}, [XL_Row_Dim_0])) ON ROWS
      > FROM [Sales]
      > WHERE ([Measures].[Store Sales])
      >
      > Mondrian doesn't correctly processes this one (results
      > differ from MSAS 2000).

      Assuming this query is typical of Excel 2007, let's make sure it works. Will, assigning to you.

      Julian

        Attachments

          Activity

            People

            • Assignee:
              jhyde Julian Hyde
              Reporter:
              cpamiller Calum Miller
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: