Erreur Jasper Analysis

[bacomina]

Bonjour,
j'ai fait un rapport qui est basé sur une connexion Mondrian, avec requete MDX.
le rapport doit etre relancé tous les jours car les données sont mises à jour quotidiennement; Pour eviter le problème du cache, j'ai desactivé le cache sur le cube ainsi le requete est completement reexecutée à chaque fois.

le problème c'est que j'ai quand même l'erreur:

com.jaspersoft.ji.ja.JasperAnalysisException: Internal error: Error while executing query [with member [Measures].[CHF prev day] as '[Accounting Date.All Accounting Date].PrevMember'
member [Measures].[CHF MTD] as '([Accounting Date.All Accounting Date].CurrentMember.Parent.PrevMember.LastChild, [Measures].[CHF])'
member [Measures].[CHF YTD] as '([Accounting Date.All Accounting Date].CurrentMember.Parent.Parent.PrevMember.LastChild.LastChild, [Measures].[CHF])'
member [Measures].[at sight] as '([Maturity Date.All Maturity Date].[All Maturity Date].[1900].[1].[1], [Measures].[CHF])'
member [Measures].[Q1] as 'Sum(([Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10] : ParallelPeriod([Maturity Date.All Maturity Date].[month], (- 3.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10])), [Measures].[CHF])'
member [Measures].[Q2] as 'Sum((ParallelPeriod([Maturity Date.All Maturity Date].[month], (- 3.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10].NextMember) : ParallelPeriod([Maturity Date.All Maturity Date].[month], (- 6.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10])), [Measures].[CHF])'
member [Measures].[Q3] as 'Sum((ParallelPeriod([Maturity Date.All Maturity Date].[month], (- 6.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10].NextMember) : ParallelPeriod([Maturity Date.All Maturity Date].[month], (- 9.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10])), [Measures].[CHF])'
member [Measures].[Q4] as 'Sum((ParallelPeriod([Maturity Date.All Maturity Date].[month], (- 9.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10].NextMember) : ParallelPeriod([Maturity Date.All Maturity Date].[month], (- 12.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10])), [Measures].[CHF])'
member [Measures].[Y2] as 'Sum((ParallelPeriod([Maturity Date.All Maturity Date].[year], (- 1.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10].NextMember) : ParallelPeriod([Maturity Date.All Maturity Date].[year], (- 2.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10])), [Measures].[CHF])'
member [Measures].[Y3] as 'Sum((ParallelPeriod([Maturity Date.All Maturity Date].[year], (- 2.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10].NextMember) : ParallelPeriod([Maturity Date.All Maturity Date].[year], (- 3.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10])), [Measures].[CHF])'
member [Measures].[Y4] as 'Sum((ParallelPeriod([Maturity Date.All Maturity Date].[year], (- 3.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10].NextMember) : ParallelPeriod([Maturity Date.All Maturity Date].[year], (- 4.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10])), [Measures].[CHF])'
member [Measures].[Y5] as 'Sum((ParallelPeriod([Maturity Date.All Maturity Date].[year], (- 4.0), [Maturity Date.All Maturity Date].[All Maturity Date].[2011].[3].[10].NextMember) : [Maturity Date].LastChild.LastChild.LastChild), [Measures].[CHF])'
member [Entity].[All Entitys].[CUST] as 'Aggregate({[Entity].[All Entitys].[BZH], [Entity].[All Entitys].[CYB], [Entity].[All Entitys].[BGU], [Entity].[All Entitys].[SGP], [Entity].[All Entitys].[HKP], [Entity].[All Entitys].[LDN], [Entity].[All Entitys].[LJE], [Entity].[All Entitys].[LGG]})'
select {[Measures].[CHF], [Measures].[CHF prev day], [Measures].[CHF MTD], [Measures].[CHF YTD]} ON COLUMNS,
{[BS_CATEGORY.CATEGORY].[All BS_CATEGORY.CATEGORYs].[Client Deposit LVLDN], [BS_CATEGORY.CATEGORY].[All BS_CATEGORY.CATEGORYs].[Client "Loan"], [BS_CATEGORY.CATEGORY].[All BS_CATEGORY.CATEGORYs].[Banks (out) Borrow], [BS_CATEGORY.CATEGORY].[All BS_CATEGORY.CATEGORYs].[Banks (out) Lend], [BS_CATEGORY.CATEGORY].[All BS_CATEGORY.CATEGORYs].[Nostro Portfolios], [BS_CATEGORY.CATEGORY].[All BS_CATEGORY.CATEGORYs].[FP Deposits at bank], [BS_CATEGORY.CATEGORY].[All BS_CATEGORY.CATEGORYs].[FP Current Accounts], [BS_CATEGORY.CATEGORY].[All BS_CATEGORY.CATEGORYs].[FP Borrowing], [BS_CATEGORY.CATEGORY].[All BS_CATEGORY.CATEGORYs].[Fiduciary (In EFGI)], [BS_CATEGORY.CATEGORY].[All BS_CATEGORY.CATEGORYs].[Fiduciary (Outside)]} ON ROWS
from [CUBE_GLOBAL_POSITION]
where ([Accounting Date.All Accounting Date].[All Accounting Date].[2011].[3].[10], [Entity].[All Entitys].[CUST])
]
at mondrian.resource.MondrianResource$_Def0.ex_aroundBody3$advice(MondrianResource.java:97)
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1)
at mondrian.olap.Util.newInternal(Util.java:1472)
at mondrian.olap.Util.newError(Util.java:1488)
at mondrian.rolap.RolapConnection.execute_aroundBody0(RolapConnection.java:589)
at mondrian.rolap.RolapConnection.execute_aroundBody1$advice(RolapConnection.java:118)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:1)
at net.sf.jasperreports.olap.JRMondrianQueryExecuter.createDatasource(JRMondrianQueryExecuter.java:83)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:681)
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:601)
at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1247)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826)
at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:557)
at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59)
at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.jaspersoft.ji.ja.JasperAnalysisException: Internal error: member [Accounting Date.All Accounting Date].[All Accounting Date].[2011].[3].[10] not found among its siblings
at mondrian.resource.MondrianResource$_Def0.ex_aroundBody1$advice(MondrianResource.java:101)
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1)
at mondrian.olap.Util.newInternal(Util.java:1465)
at mondrian.rolap.SmartMemberReader$SiblingIterator.<init>(SmartMemberReader.java:489)
at mondrian.rolap.SmartMemberReader.getLeadMember(SmartMemberReader.java:323)
at mondrian.rolap.RolapSchemaReader.getLeadMember(RolapSchemaReader.java:438)
at mondrian.olap.DelegatingSchemaReader.getLeadMember(DelegatingSchemaReader.java:129)
at mondrian.olap.fun.BuiltinFunTable$21$1.evaluateMember(BuiltinFunTable.java:636)
at mondrian.calc.impl.MemberValueCalc.evaluate(MemberValueCalc.java:52)
at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:449)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:894)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1032)
at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1032)
at mondrian.rolap.RolapResult.executeBody(RolapResult.java:792)
at mondrian.rolap.RolapResult.<init>(RolapResult.java:413)
at mondrian.rolap.RolapConnection.execute_aroundBody0(RolapConnection.java:560)
... 12 more

Je ne comprends pas cette erreur etant donné que la date 10/03/2011 est bien présent dans les données et que le cache est désactivé sur le cube.

Merci de votre aide.