[Mondrian] MDX from Excel 2007

[Anton Nikitin]

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

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