Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

error when filtering multi-level hierarchy in chart

Maria Cristina Debuayan asked on November 4, 2016

I have a multi-level date hierarchy with levels year, month and day.
When I filter certain year, month or day in chart, I got mondrian internal error.
Filter in grid is working okay. Please refer to the attached screen capture.
I am using flexmonster-proxy-mondrian-4
Please let me know if you need more details.
Thank you.


4 answers

Ian Sadovy Ian Sadovy Flexmonster November 4, 2016

Hello Maria,  

Thank you for the question.
To help us identify the issue faster, could you please share your database sample, Mondrian schema, and report by email?  


Maria Cristina Debuayan November 4, 2016

Hi Ian,
Already sent the required data in email.

Ian Sadovy Ian Sadovy Flexmonster November 4, 2016


Thank you, we have received it.
We will update you with any progress.


Ian Sadovy Ian Sadovy Flexmonster December 16, 2016

Hi Maria,   

Hope you are fine. 
We have investigated your case and here are our findings:  

  • The issue is reproduced when you are trying to filter hierarchy that is used in the cumulative measure formula. For instance, [Master].[YMD] in rows and GapYMD in measures. Or [Master].[YM] in rows and GapYM in measures. And so on.
  • Since that is a Mondrian internal error, we cannot provide a fix for this issue. The query is correct and works correctly for other cases.
  • But we can advise you a workaround – create a hidden clone of [Master].[YMD] to use in the GapYMD formula. Please check a sample here – (lines 178-182 and 425-428)

Hope it works.  

Kind regards,

Please login or Register to Submit Answer