#15 crosstabs with two measures

[Juan José Ortilles]

First of all congrats for the project!
I've trying it and it seems that crosstabs are not correctly working.
I expose the case:

Environment : Excel 2013 connecting to mondrian xmla

If you put a dimension in a row, a dimension in a column and one measure it works. But if you put two measures it produces an inconsistent query.

The sampledata example would be:

If you try to put a second measure to the query attached in the picture it generates this mdx:

SELECT NON EMPTY CrossJoin(Hierarchize(AddCalculatedMembers({DrilldownLevel({[Positions].[All Positions]})})),
CrossJoin({[Measures].[Actual],[Measures].[Budget]}))
DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS ,
NON EMPTY Hierarchize
(AddCalculatedMembers({DrilldownLevel({[Region].[All Regions]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON ROWS
FROM [Quadrant Analysis] CELL PROPERTIES VAL
UE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS

[Alexandra Davidoiu (Iancu)]

Hi,

Thank you.

You can find a fix in this discussion https://sourceforge.net/p/xmlaconnect/discussion/general/thread/cc8d9a95/#fe2a.

The next setup will include this fix.

[Alexandra Davidoiu (Iancu)]

should work in version 58