Question Re: Help Needed to Resolve Visual Filter Configuration Is... in Technology Q&A

Help Needed to Resolve Visual Filter Configuration Issue in SAP Fiori Elements ALP

salvakz — Mon, 06 May 2024 02:10:30 GMT

Hi Everyone,

I am currently facing an issue with the Analytical List Page (ALP) in SAP Fiori Elements. I'm trying to configure a visual filter but am encountering a specific error message:

"The dimension MonthYear or the measure TotalPriceNet or both are either NOT given in the chart, or IS given but undefined in metadata. Corresponding chart cannot be displayed as VisualFilter."

I have checked my OData service and the metadata seems to include definitions for both "MonthYear" and "TotalPriceNet". However, despite this, the visual filters refuse to display, and I am continuously running into the above error. Here are the steps I've already taken:

Verified that "MonthYear" and "TotalPriceNet" are included in the $metadata document of my OData service.
Checked the annotations related to visual filters to ensure they are correctly pointing to these dimensions and measures.
Reviewed the configurations in the manifest.json file to ensure all settings related to visual filters are correct.
Tried refreshing metadata and clearing browser cache to see if there was a loading issue.

Unfortunately, none of these steps have resolved the problem. I suspect there might be an issue with how the annotations are set up or possibly a version mismatch between the OData service and Fiori Elements.

Does anyone have experience with this type of issue or suggestions on what else I might try? Any advice or tips would be greatly appreciated as I am quite stuck at this point.

Image error:

And my CDS Annotation:

Thank you in advance for your help!

Re: Help Needed to Resolve Visual Filter Configuration Is...

sireesha_varada — Mon, 06 May 2024 05:11:53 GMT

Hello,

By looking at the screenshot, the qualifier name mismatch for VisualFilter is there.

Please make visualFilterDate a qualifier instead of visualDate in UI.Chat annotation.

Thanks for posting the question.

Re: Help Needed to Resolve Visual Filter Configuration Is...

salvakz — Tue, 07 May 2024 07:08:13 GMT

Thanks for help, I think it's not my problem. Sorry my image CDS annotation is not displayed fully. My complete annotation below:

{

qualifier: 'VisualFilter',

text: 'Filter: Travels by Status',

visualizations: [{

type: #AS_CHART,

qualifier: 'visualDate'

}]

}

variant qualifier is 'VisualFilter' but in visualizations property qualifier refer to correct UI.Chart with qualifier visualDate

Re: Help Needed to Resolve Visual Filter Configuration Is...

Rohitautodesk — Tue, 05 Nov 2024 18:26:42 GMT

@salvakz. I am facing the same issue. Were you able to fix this issue?