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

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 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 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 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 'WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales]'
at mondrian.mdx.UnresolvedFunCall.getType(UnresolvedFunCall.java:82)
at mondrian.olap.SetBase.getType(SetBase.java:140)
at mondrian.mdx.NamedSetExpr.getType(NamedSetExpr.java:123)
at mondrian.olap.ValidatorImpl.canConvert(ValidatorImpl.java:253)
at mondrian.olap.fun.SetFunDef$ResolverImpl.resolve(SetFunDef.java:428)
at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:190)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2027)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:83)

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.