[Mondrian] MDX from Excel 2007

Julian Hyde julianhyde at speakeasy.net
Thu May 31 10:52:12 EDT 2007

Logged a bug for this one:
id=35302&atid=414613> &aid=1728980&group_id=35302&atid=414613.


From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Anton Nikitin
Sent: Wednesday, May 30, 2007 8:17 AM
To: 'Mondrian developer mailing list'
Subject: [Mondrian] MDX from Excel 2007

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:



    SET [XL_Row_Dim_0] AS
Customers].[USA]), Descendants([Customers].[All Customers].[USA])})))'  


    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




P.S. IMHO it may concern Pentaho Spreadsheet Services

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070531/ea322714/attachment.html 

More information about the Mondrian mailing list