mondrian.olap.MondrianException: 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] '

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

Solutions on the web

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] '
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]'
mondrian.olap.MondrianException: 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] '
at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:959)
at mondrian.olap.Util.lookup(Util.java:1079)
at mondrian.olap.Id.accept(Id.java:103)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1981)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79)
at mondrian.olap.QueryAxis.resolve(QueryAxis.java:213)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:140)
at mondrian.olap.Query.resolve(Query.java:561)
at mondrian.olap.Query.resolve(Query.java:446)
at mondrian.olap.Query.(Query.java:200)
at mondrian.olap.Query.(Query.java:161)
at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927)
at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1184)
at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1016)
at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:185)
at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57)
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 com.axege.test.analysis.TestMondrian.main(TestMondrian.java:33)

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.

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