Menu
Download Free Trial

error when filtering multi-level hierarchy in chart

Answered

Hi,
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

Public
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?  

Regards,
Ian

Public
Maria Cristina Debuayan November 4, 2016

Hi Ian,
 
Already sent the required data in email.
Thanks.

Public
Ian Sadovy Flexmonster November 4, 2016

Maria,

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

Regards,
Ian

Public
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 – http://take.ms/pgwnu (lines 178-182 and 425-428)

Hope it works.  

Kind regards,
Ian

Please login or Register to Submit Answer