Flexmonster Report Error

Answered
Shahul Hameed 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

Attachments:
FMError1.PNG

4 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 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

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 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

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 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

Public
Shahul Hameed 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

Please login or Register to Submit Answer