asked on December 21, 2022
Hi
I got an error message when searching for dimensions. By using the way to connect to the data source via Mondrian, do you have a suggestion for me?
Thank you for your help.
Below is the payload that flexmonster calls to Mondrian.
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" flexmonster="true">
<SOAP-ENV:Body>
<Executexmlns="urn:schemas-microsoft-com:xml-analysis">
<Command>
<Statement>
<![CDATA[WITH SET [SearchMembersSet] AS 'FILTER(EXCEPT([COUNTRY].members, [COUNTRY].[All COUNTRYs]), (INSTR(1, lcase([COUNTRY].CurrentMember.Caption), "al") > 0))'
SET [SearchParentsSet] AS 'EXCEPT(GENERATE([SearchMembersSet], ASCENDANTS([SearchMembersSet].Current)), [COUNTRY].[All COUNTRYs])'
SET [SearchSet] AS 'HIERARCHIZE(DISTINCT({[SearchMembersSet], [SearchParentsSet]}))'
MEMBER [Measures].[CountSearchSet] AS 'COUNT([SearchSet])'
SELECT NON EMPTY {[Measures].[CountSearchSet]} ON COLUMNS FROM [TRADE]]]>
</Statement>
</Command>
<Properties>
<PropertyListflexmonster="true">
<DataSourceInfo>Provider=Mondrian;DataSource=TISTradeThaiExport</DataSourceInfo>
<Catalog>TRADE</Catalog>
<AxisFormat>TupleFormat</AxisFormat>
<Content>Data</Content>
<Format>Multidimensional</Format>
</PropertyList>
</Properties>
</Execute>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
⋅ December 22, 2022
Hello,
Thank you for reaching out to us.
Our team would like to have more details regarding this issue. Firstly, could you please tell us if the issue occurs after filtering the report? If so, does it happen with all filter types or only specific ones? Also, we would like to have the following details about the issue:
Knowing this information would greatly help to find a solution.
In addition, could you please tell us if you are using other data sources than Mondrian and if using Mondrian is a hard requirement for your project?
Looking forwards to hearing from you.
Best Regards,
Maksym
⋅ December 22, 2022
Hello,
Just checking in to ask if your new ticket, "The data in the report cannot be filtered" is somehow related to the issue described in this ticket.
Looking forward to hearing from you.
Best Regards,
Maksym
⋅ December 23, 2022
Hi,
I've attached the mondrian log and screen the menu I'm using to search for information and the error occurs. When I enter text "af" in the search box to search for a list of countries, the system shows error popup. And this matter not relate to https://www.flexmonster.com/question/the-data-in-the-report-cannot-be-filtered/
⋅ December 23, 2022
Hi,
Below is the error message from Mondrian. I try to search the list of countries by text "af".
Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement 'WITH SET [SearchMembersSet] AS 'FILTER(EXCEPT([COUNTRY].members, [COUNTRY].[All COUNTRYs]), (INSTR(1, lcase([COUNTRY].CurrentMember.Caption), "af") > 0))'
SET [SearchParentsSet] AS 'EXCEPT(GENERATE([SearchMembersSet], ASCENDANTS([SearchMembersSet].Current)), [COUNTRY].[All COUNTRYs])'
SET [SearchSet] AS 'HIERARCHIZE(DISTINCT({[SearchMembersSet], [SearchParentsSet]}))'
MEMBER [Measures].[CountSearchSet] AS 'COUNT([SearchSet])'
SELECT NON EMPTY {[Measures].[CountSearchSet]} ON COLUMNS FROM [TRADE]'
⋅ December 23, 2022
Hello,
Thank you for providing further details about the issue.
Our team needs more time to investigate your case, and we will respond as soon as possible.
Kind Regards,
Maksym
⋅ December 28, 2022
Hello,
Thank you for giving us some time.
Our team has checked the provided screenshots and was able to provide the fix available in this build:
https://flexmonster.s3.amazonaws.com/twirote/flexmonster-2022-12-28-11-29.zip
Please let us know if the issue is fixed for the case you described.
Best Regards,
Maksym
⋅ January 5, 2023
Hi,
Thanks for your review and fix issue. I have switched to the source code you have sent me and when I try to search the list of countries by text “กร” but mondrian still have the problem.
Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement 'WITH SET [SearchMembersSet] AS 'FILTER(EXCEPT([COUNTRY].members, {[COUNTRY].[All COUNTRYs]}), (INSTR(1, lcase([COUNTRY].CurrentMember.Caption), "กร") > 0))'
SET [SearchParentsSet] AS 'EXCEPT(GENERATE([SearchMembersSet], ASCENDANTS([SearchMembersSet].Current)), {[COUNTRY].[All COUNTRYs]})'
SET [SearchSet] AS 'HIERARCHIZE(DISTINCT({[SearchMembersSet], [SearchParentsSet]}))'
MEMBER [Measures].[CountSearchSet] AS 'COUNT([SearchSet])'
SELECT NON EMPTY {[Measures].[CountSearchSet]} ON COLUMNS FROM [TRADE]'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
at mondrian.olap.Parser.parseInternal(Parser.java:759)
at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74)
... 34 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:No function matches signature 'INSTR(<Numeric Expression>, <String>, <String>)'
⋅ January 5, 2023
Hi,
Thank you for your feedback.
Could you please tell us which version of Mondrian you are currently using?
Looking forward to hearing from you.
Best Regards,
Maksym
⋅ January 9, 2023
Hi,
I use Mondrian version 3.0.0.10550
Thank you for your help.
⋅ January 12, 2023
Hello,
Thank you for sharing your Mondrian version.
Our team fixed this issue in the latest version of Flexmonster (v.2.9.42). You are welcome to check the updating guide for reference: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if the fix worked for you.
Best Regards,
Maksym