error when filtering multi-level hierarchy in chart
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 for the question.
To help us identify the issue faster, could you please share your database sample, Mondrian schema, and report by email?
Already sent the required data in email.
Thank you, we have received it.
We will update you with any progress.
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.