error when filtering multi-level hierarchy in chart

posted on November 4th, 2016

Answered

Maria Cristina Debuayan asked on November 4, 2016

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.

Attachments:
chart-filter-error.png

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

error when filtering multi-level hierarchy in chart

4 answers

Please login or Register to Submit Answer