asked on December 21, 2021
Hi Team,
I want to filter data by passing customer id, project id and timeframes (month-year). I added this part of reportFilter object(filter/members). Also we want to display chart by showing customername/month-year in x-Axis (added as part of rows parameters). On executing, i get the following hierarchy error. Pls find the attached image
⋅ December 22, 2021
Hi Shahul,
Thank you for raising this support ticket.
The error you reported can only happen in Flexmonster when you put the same field in rows/columns and report filters through code – this action is restricted in UI. The reason for this restriction is that if you need to filter a specific field, you can do so when it is placed in rows/columns, you don't need to place it in report filters as well.
Another reason for this restriction is that the MDX queries generated by such field duplication are invalid. This is exactly what the mentioned error pop-up is about – the error you see in the window is thrown on the MDX level before the data even reaches Flexmonster.
That being said, we'd recommend removing the field from the report filters – instead, use the regular filtering available when the field is placed in rows/columns.
Please let us know if this helps.
Best regards,
Mykhailo
⋅ December 29, 2021
Hi Shahul,
How are you?
Just checking in to ask if you've found our previous response helpful. Is there still anything we can help you with?
We'd be happy to hear your feedback.
Best regards,
Mykhailo
⋅ January 6, 2022
Shahul,
Hope you're doing well.
We were wondering if you had a chance to read out response to your inquiry. Has the issue been solved on your end?
Please let us know your thoughts.
Best regards,
Mykhailo
⋅ January 13, 2022
Hi Mykhailo,
Sorry for late reply, I fixed it to get expected result by adding few parameters in filters and few members in rows. Thanks for your response.
Regards,
Shahul
