mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )'

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Pentaho BI Platform Tracking by Sulaiman Karmali, 1 year ago
Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers
via Pentaho BI Platform Tracking by Sulaiman Karmali, 1 year ago
Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers
via Pentaho BI Platform Tracking by Pedro Vale, 1 year ago
Mondrian Error:Failed to parse query 'WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales]'
via Pentaho BI Platform Tracking by Pedro Vale, 1 year ago
Mondrian Error:Failed to parse query 'WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales]'
via Pentaho BI Platform Tracking by damien hostin, 1 year ago
Mondrian Error:Failed to parse query 'select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children) ON ROWS from [HR] where [Time].[1997] '
via Pentaho BI Platform Tracking by damien hostin, 1 year ago
Mondrian Error:Failed to parse query 'select {[Measures].[Org Salary], [Measures].[Count]} ON COLUMNS, Crossjoin({[Position].[All Position]}, [Employees].[Sheri Nowmer].Children) ON ROWS from [HR] where [Time].[1997] '
mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'set [TopSelection] as 'TopCount(FILTER([Customers].[All Customers].Children,[Measures].[Sales]>0), Parameter("TopCount", NUMERIC, 10, "Number of Customers to show"), [Measures].[Sales])' Member [Customers].[All Customers].[Total] as 'Sum([TopSelection])' Member [Customers].[All Customers].[Other Customers] as '[Customers].[All Customers] - [Customers].[Total]' select NON EMPTY {[Measures].[Sales],[Measures].[Quantity] } ON COLUMNS, { [TopSelection], [Customers].[All Customers].[Other Customers]} ON ROWS from [SteelWheelsSales] where ( strToMember(Parameter("sLine", STRING, "[Product].[All Products].[Classic Cars]")), strToMember(Parameter("sMarket", STRING, "[Markets].[All Markets].[Japan]")), strToMember(Parameter("sYear", STRING, "[Time].[All Years].[2003]")) )'
at mondrian.parser.JavaccParserValidatorImpl.convertException(JavaccParserValidatorImpl.java:99)
at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:59)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96)
at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:765)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:55)
at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:444)
at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145)
at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54)
at org.pentaho.reporting.ui.datasources.mondrian.MondrianPreviewWorker.run(MondrianPreviewWorker.java:99)
at java.lang.Thread.run(Thread.java:680)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.