I have a simple schema : Code:<Schema name="testTXN" measuresCaption="Sales Results"> <Dimension type="TimeDimension" name="Time" caption="By time"> <Hierarchy name="timeHier" hasAll="true" allMemberName="All time" allMemberCaption="All time day" allLevelName="All time" primaryKey="tradingdate"> <Table name="calendar"> </Table> <Level name="Year" column="calendaryear" type="Numeric" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never"> </Level> <Level name="Month" column="calendarmonth" type="Numeric" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never"> </Level> <Level name="DayDate" column="tradingdate" type="Date" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never"> </Level> </Hierarchy> <Hierarchy name="timeHierWeekly" hasAll="true" allMemberName="All time" allMemberCaption="All time week" allLevelName="All time" primaryKey="tradingdate"> <Table name="calendar"> </Table> <Level name="Year" column="calendaryear" type="Numeric" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never"> </Level> <Level name="Month" column="calendarmonth" type="Numeric" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never"> </Level> <Level name="Week" column="calendarweek" type="Numeric" uniqueMembers="false" levelType="TimeWeeks" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Dimension type="StandardDimension" name="Transactiontype" caption="By transaction type"> <Hierarchy name="transactiontypeHier" hasAll="true" allMemberName="All transactions" allMemberCaption="All transactions" allLevelName="All transactions" primaryKey="transactiontype" primaryKeyTable="transactiontype"> <Table name="transactiontype"> </Table> <Level name="transLevel" column="transactiontype" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" caption="Transaction types"> </Level> </Hierarchy> </Dimension> <Cube name="Sales" cache="true" enabled="true"> <Table name="txnheader" schema="public"> </Table> <DimensionUsage source="Time" name="Time" foreignKey="tradingdate"> </DimensionUsage> <DimensionUsage source="Transactiontype" name="Transactiontype" foreignKey="transactiontype"> </DimensionUsage> <Measure name="SUMQTY" column="totalqty" datatype="Numeric" formatString="#,##0" aggregator="sum" caption="Qty sold"> </Measure> <Measure name="SUMDUE" datatype="Numeric" formatString="#,###.##" aggregator="sum" caption="Net Amount"> <MeasureExpression> <SQL dialect="generic"> cast(valuedue as numeric) </SQL> </MeasureExpression> </Measure> </Cube> </Schema> I also defined a simple analysis view : Code:[code]select NON EMPTY {[Measures].[sUMQTY], [Measures].[sUMDUE]} ON COLUMNS, NON EMPTY Hierarchize({[Time.timeHier].[All time].Members}) ON ROWS from [sales] When I display the view, I am able to add the "transactiontype" dimension to the result. Then, if I display the MDX query, it looks like : Code:[code]select NON EMPTY {[Measures].[sUMQTY], [Measures].[sUMDUE]} ON COLUMNS, NON EMPTY {([Time.timeHier].[All time], [Transactiontype.transactiontypeHier].[All transactions])} ON ROWS from [sales] But... :( When I try to replace to initial MDX view definition by this request, either in the jasperserver or using the MDX query tool, I obtain the following error : Mondrian Error:Failed to parse query 'select NON EMPTY {[Measures].[sUMQTY], [Measures].[sUMDUE]} ON COLUMNS, NON EMPTY {([Time.timeHier].[All time], [Transactiontype.transactiontypeHier].[All transactions])} ON ROWS from [sales] ' Mondrian Error:Error while parsing MDX statement 'select NON EMPTY {[Measures].[sUMQTY], [Measures].[sUMDUE]} ON COLUMNS, NON EMPTY {([Time.timeHier].[All time], [Transactiontype.transactiontypeHier].[All transactions])} ON ROWS from [sales] ' Mondrian Error:No function matches signature '(<Level>, <Level>)' What do I miss ?