[Mondrian] MDX from Excel 2007

[Julian Hyde]

Logged a bug for this one:
http://sourceforge.net/tracker/index.php?func=detail
<http://sourceforge.net/tracker/index.php?func=detail&aid=1728980&group_
id=35302&atid=414613> &aid=1728980&group_id=35302&atid=414613.
 
Julian


  _____  

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:

 

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/20070531/ea322714/attachment.html