asked on July 29, 2019
I encountered an issue when trying to drill through data in the middle using the sample below:
https://www.flexmonster.com/demos/js/pivot-table/
When you try to drill through data from (Row: Drink/ Column: Profit) Or any other data in between it will show:
mondrian gave exception while parsing query
I tried it in my code and I get the following exception for using accelerator v2.7.10
Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'DRILLTHROUGH SELECT {[Measures].[Current Balance]} ON columns FROM [Test Cube] WHERE ({[Test Dimen 2].[Branch By Region].[Region 1]},{[Test Dimen].[Product].[AUTO FINANCING]})'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:100)
at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:588)
at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:81)
... 48 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '(<Set>, <Set>)'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:989)
at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:205)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1998)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79)
at mondrian.olap.QueryAxis.validate(QueryAxis.java:291)
at mondrian.olap.Query.resolve(Query.java:584)
at mondrian.olap.Query.resolve(Query.java:445)
at mondrian.olap.Query.<init>(Query.java:199)
at mondrian.olap.Query.<init>(Query.java:160)
at mondrian.parser.QueryPartFactoryImpl.makeQuery(QueryPartFactoryImpl.java:38)
at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1241)
at mondrian.parser.MdxParserImpl.drillthroughStatement(MdxParserImpl.java:1488)
at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1077)
at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:188)
at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96)
... 50 more
⋅ July 29, 2019
Hello, Clifford,
Thank you for writing to us and for explaining the problem in detail.
Our development team will research this issue and we will inform you about the results with the ETA 27th of August.
You are welcome to contact us in case any questions arise.
Best Regards,
Vera
⋅ July 31, 2019
While you are working with this, I also notice that mondrian drill through would not include Measures but other type of data like MS Analysis Service/Elastic Search would show the individual Measures after drill through.
⋅ July 31, 2019
Hello, Clifford,
Thank you for pointing this out to us.
We would like to explain that the measures are not returned in the drill-through pop-up window because Mondrian does not return them.
Flexmonster represents everything that Mondrian has returned.
Please let us know if you have further questions.
Best Regards,
Vera
⋅ August 28, 2019
Hello, Clifford,
We are happy to let you know that the issue with exception “Mondrian gave exception while parsing query” when trying to drill through data was fixed.
This is provided in the 2.7.13 version of Flexmonster: https://www.flexmonster.com/release-notes/.
You are welcome to update the component.
Here is our updating to the latest version guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
A kind reminder is to update Flexmonster Accelerator also: https://www.flexmonster.com/doc/updating-to-the-latest-version/#!accelerator.
Please let us know if everything works.
Best Regards,
Vera