🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Having issue while using drill through for flexmonster accelerator for mondrian

Clifford asked on July 29, 2019

I encountered an issue when trying to drill through data in the middle using the sample below:

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


4 answers

Vera Didenko Vera Didenko Flexmonster 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,

Clifford 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.

Vera Didenko Vera Didenko Flexmonster 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 Didenko Vera Didenko Flexmonster 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,

Please login or Register to Submit Answer