#19 Excel 2010 sliders are not handled correctly

[bruno pennec]

Hello,

This piece of software is really wonderful.
With it, no more reports, users can get data to build theirs graphics into Excel.

But it seems I find one limit with Excel 2010, with sliders.
I try to add a slider to coordinate some Olap PivotTable, and I have got the following error :

ERROR [Session ] mondrian.xmla.XmlaServlet#doPost: Errors when handling XML/A message
mondrian.xmla.XmlaException: XMLA MDX parse failed
...
Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'with set XLUniqueNames as { [Temps].[FY calendar].[2016] }
set XLDrilledUp as
Generate(XLUniqueNames,
{ IIF([Temps].CAST( [FY calendar].currentmember.Properties("LEVEL_NUMBER") AS INTEGER ) <= 4,
[Temps].[FY calendar].currentmember,
Ancestor([Temps].[FY calendar].currentmember,
[Temps].CAST( [FY calendar].currentmember.Properties("LEVEL_NUMBER") AS INTEGER ) - 4)) } )
member [Measures].XLPath as
Generate(
Ascendants([Temps].[FY calendar].currentmember),
[Temps].[FY calendar].currentmember.UniqueName,
"XLPSEP")
select { [Measures].XLPath } on 0,
__XLDrilledUp on 1
from [Visites]
cell properties value'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)
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:359)
at mondrian.server.Locus.execute(Locus.java:88)
at mondrian.server.Locus.execute(Locus.java:73)
at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:356)

I suppose that the .CAST attribute is the orgin of error, because it is not a Standard MDX function and the Mondrian CAST seems to have a different syntax.

How can I handle this ?

Best Regards,
Bruno