mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [with member [Store].[CA plus USA] as 'Aggregate({[Store].[All Stores].[USA].[CA], [Store].[All Stores].[USA]})', solve_order = 1.0 member [Time].[Q1 plus July] as 'Aggregate({[Time].[1997].[Q1], [Time].[1997].[Q3].[7]})', solve_order = 1.0 select {[Measures].[Customer Count], [Measures].[Unit Sales]} ON COLUMNS, ({[Store].[CA plus USA]} * {[Time].[Q1 plus July]}) ON ROWS from [Sales] ]

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 p_thiyagu, 1 year ago
Mondrian Error:Internal error: Error while executing query [with member [Store].[CA plus USA] as 'Aggregate({[Store].[All Stores].[USA].[CA], [Store].[All Stores].[USA]})', solve_order = 1.0 member [Time].[Q1 plus July] as 'Aggregate({[Time].[1997
via Pentaho BI Platform Tracking by p_thiyagu, 1 year ago
Mondrian Error:Internal error: Error while executing query [with member [Store].[CA plus USA] as 'Aggregate({[Store].[All Stores].[USA].[CA], [Store].[All Stores].[USA]})', solve_order = 1.0 member [Time].[Q1 plus July] as 'Aggregate({[Time].[1997
via Pentaho BI Platform Tracking by Eric McDermid, 1 year ago
Mondrian Error:Internal error: Error while executing query [with set [RM] as '[Gender].Members' select Reverse([RM]) ON COLUMNS from [Sales] ]
via Pentaho BI Platform Tracking by Eric McDermid, 1 year ago
Mondrian Error:Internal error: Error while executing query [with set [RM] as '[Gender].Members' select Reverse([RM]) ON COLUMNS from [Sales] ]
via Pentaho BI Platform Tracking by rehdie_easyplex, 1 year ago
Mondrian Error:Internal error: Error while executing query [select {[Measures].[Unit Sales]} ON COLUMNS, Filter({[Store2].[All Stores].[USA].[CA].[Beverly Hills], [Store2].[All Stores].[USA].[CA].[Beverly Hills].[Gourmet Supermarket]}, ([Measures].[Unit Sales] > 0.0)) ON ROWS from [Sales] where [Store Type].[All Store Types].[Small Grocery] ]
via Pentaho BI Platform Tracking by eduandrade, 1 year ago
Mondrian Error:Internal error: Error while executing query [select {[Measures].[MaxOverMeasure]} ON COLUMNS, {[Employees].[All Employees], [Employees].[All Employees].Children} ON ROWS from [HR] ]
java.lang.UnsupportedOperationException:
at mondrian.rolap.agg.CompoundQuerySpec.addMeasure(CompoundQuerySpec.java:85)
at mondrian.rolap.agg.CompoundQuerySpec.nonDistinctGenerateSql(CompoundQuerySpec.java:122)
at mondrian.rolap.agg.AbstractQuerySpec.generateSqlQuery(AbstractQuerySpec.java:159)
at mondrian.rolap.agg.CompoundQuerySpec.compoundGenerateSql(CompoundQuerySpec.java:158)
at mondrian.rolap.RolapAggregationManager.generateMultiSql(RolapAggregationManager.java:447)
at mondrian.rolap.FastBatchingCellReader.getCompound(FastBatchingCellReader.java:129)
at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:480)
at mondrian.olap.fun.AggregateFunDef$1.evaluateDouble(AggregateFunDef.java:80)
at mondrian.calc.impl.AbstractDoubleCalc.evaluate(AbstractDoubleCalc.java:42)
at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:494)
at mondrian.olap.fun.AggregateFunDef$1.evaluateDouble(AggregateFunDef.java:80)
at mondrian.calc.impl.AbstractDoubleCalc.evaluate(AbstractDoubleCalc.java:42)
at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:494)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:817)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:898)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:898)
at mondrian.rolap.RolapResult.executeBody(RolapResult.java:728)
at mondrian.rolap.RolapResult.(RolapResult.java:390)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:414)
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
at mondrian.olap.Util.newInternal(Util.java:1104)
at mondrian.olap.Util.newError(Util.java:1120)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:442)
at mondrian.test.TestContext.executeQuery(TestContext.java:390)
at mondrian.test.TestContext.assertQueryReturns(TestContext.java:615)
at mondrian.test.FoodMartTestCase.assertQueryReturns(FoodMartTestCase.java:124)
at mondrian.rolap.FastBatchingCellReaderTest.testAggregateDistinctCount4(FastBatchingCellReaderTest.java:1051)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

Users with the same issue

You are the first who have seen this exception.

Write tip

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