[Mondrian] MDX from Excel 2007
Julian Hyde
julianhyde at speakeasy.net
Tue Jun 12 16:14:49 EDT 2007
PS Anton log a bug for this and assign to Will. The easiest thing for us
would be a patch to XmlaBasicTest.ref.xml with an extra TestCase element
containing the XML request and response.
The easier you make this for us, the sooner we can fix it. :)
Julian
> -----Original Message-----
> From: mondrian-bounces at pentaho.org
> [mailto:mondrian-bounces at pentaho.org] On Behalf Of Will Gorman
> Sent: Tuesday, June 12, 2007 6:29 AM
> To: Mondrian developer mailing list
> Subject: Re: [Mondrian] MDX from Excel 2007
>
> Anton,
>
> Would it be possible to post the expected results from Excel
> 2007 / MSAS
> 2000 on this query? I'm in the process of getting access to a MSAS
> server but it may be a few days.
>
> Thanks!
>
> Will
>
> On Wed, 2007-05-30 at 19:17 +0400, 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).
> >
> >
> >
> > Anton
> >
> >
> >
> > P.S. IMHO it may concern Pentaho Spreadsheet Services
> >
> >
> > _______________________________________________
> > Mondrian mailing list
> > Mondrian at pentaho.org
> > http://lists.pentaho.org/mailman/listinfo/mondrian
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
More information about the Mondrian
mailing list