Error when creating a slicer in Excel

[João Victor Calvo Fracasso]

Dear all,

I am connecting with Excel 2010 on a Pentaho BI suite.

When I insert a new slicer I receive a box with this error on Excel :

“XMLA MDX parse failed”

In Tomcast console I received the message
cell properties value
'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:972)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:100)
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:362)
at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:360)
at mondrian.server.Locus.execute(Locus.java:86)
at mondrian.server.Locus.execute(Locus.java:71)
at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:356)
... 76 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:No function matches signature 'NonEmpty(<Set>, <Set>)'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:969)
at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:205)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2023)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79)
at mondrian.olap.Formula.accept(Formula.java:106)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:155)
at mondrian.olap.Query.resolve(Query.java:551)
at mondrian.olap.Query.resolve(Query.java:446)
at mondrian.olap.Query.<init>(Query.java:200)
at mondrian.olap.Query.<init>(Query.java:161)
at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927)
at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1241)
at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1074)
at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:188)
at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96)
... 81 more

How can I correct it?

Thanks,

João

[Alexandra Davidoiu (Iancu)]

Hi João,

Sorry for the late response… Your problem is generated by Mondrian ( “mondrian.olap.MondrianException: Mondrian Error:No function matches signature 'NonEmpty(<Set>, <Set>)'”). Your version of Mondrian does not have support for the function 'NonEmpty(<Set>, <Set>) used by Excel.

Our provider doesn’t have any control of the select statements used by Excel to retrieve data. Excel generates the select statement and our provider passes it to Mondrian.

I will ask the Mondrian team if/when they have implemented this function.

[jhonew32]

[smithhalsey042]

When attempting to create a slicer in Excel, you may encounter an error. This issue can arise due to various reasons, such as compatibility issues with the version of Excel you are using, problems with the data source, or incorrect formatting of the pivot table or table you're trying to create the slicer for. To resolve this, ensure that your Excel version supports of aznameify slicers, verify that your data source is correctly formatted and connected, and check that your pivot table or table is set up properly. If the problem persists, consider restarting Excel or updating to the latest version to see if that resolves the issue.

[strurgeongenera]

If you encounter an error when creating a slicer in Excel, it is typically related to compatibility or data configuration issues. Slicers require a structured data source, such as a table or PivotTable. Ensure your data is formatted as an Excel Table or linked to a PivotTable before attempting to create a slicer Geekzilla Autos. Additionally, slicers are only available in certain versions of Excel, such as Excel 2010 and later for Windows, and Excel 2016 and later for Mac. If you still face issues, check whether your Excel version supports slicers, and verify that the data range does not contain blank rows or columns. Addressing these factors can usually resolve slicer-related errors.

[jhone smith]

Slicers can only be applied to tables or PivotTables, so attempting to create one from a plain data range will trigger an error. Additionally, if you're using a PivotTable based on an external data source or if the workbook remini ไม่จำกัด has corrupted elements, slicers might not function properly. To resolve this, ensure your data is formatted as an Excel Table (using Insert > Table) or based on a properly configured PivotTable.