Mandatory cds filters missing in Fiori Overview Page Analytic Card

pradeep_nellore — Thu, 20 Jul 2023 16:11:27 GMT

Dear Community,

I have started to build a Fiori overview page based on some standard CDS views. I have used C_FutureAcctRbls as Global Filter and created a card based on this and it works perfectly. I have created another card based on cds C_PromiseToPayOverview which shares similar mandatory params as C_FutureAcctRbls. The card is displaayed, but it does not fetch any data. Console says ---Incomplete URL; parameter or mandatory filter missing . The GET request does not pass any mandatory parameters. I tried with another CDS and its same behavior. It looks i am missing a small part but cant figure it out.

I have come across https://answers.sap.com/questions/13585270/mapping-global-filter-parameters-in-overview-page.html explaining a similar issue but not helping in my case.

 "card05": {
                "model": "C_COLLECTIONPROGRESSQ_CDS",
                "template": "sap.ovp.cards.charts.analytical",
                "settings": {
                    "title": "Collection Progress",
                    "selectionAnnotationPath": "com.sap.vocabularies.UI.v1.SelectionVariant#params",
                    "entitySet": "C_COLLECTIONPROGRESSQResults",
                    "dataPointAnnotationPath": "com.sap.vocabularies.UI.v1.DataPoint#collprogressCollAmtDataPointQual",
                    "subTitle": "Collection Progress",
                    "presentationAnnotationPath": "com.sap.vocabularies.UI.v1.PresentationVariant#collprogressPresVarQual",
                    "chartAnnotationPath": "com.sap.vocabularies.UI.v1.Chart#collprogressChart",
                    "identificationAnnotationPath": "com.sap.vocabularies.UI.v1.Identification#collectionProgressIdenQual"
                }
            }

Somehow i feel its linked to annotation-->"selectionAnnotationPath": "com.sap.vocabularies.UI.v1.SelectionVariant#params". Its defined like below in annotaton file.

 <Annotation Term="UI.SelectionVariant" Qualifier="params">
                      <Record Type="UI.SelectionVariantType">
                        <PropertyValue Property="Parameters">
                            <Collection>                                
                                <Record Type="UI.Parameter">
                                    <PropertyValue Property="PropertyName" PropertyPath="P_KeyDate"/>
                                    <PropertyValue Property="PropertyValue" String="Parameters/P_KeyDate"/>
                                </Record>
                                <Record Type="UI.Parameter">
                                    <PropertyValue Property="PropertyName" PropertyPath="P_DisplayCurrency"/>
                                    <PropertyValue Property="PropertyValue" String="Parameters/P_DisplayCurrency"/>
                                </Record>
                                <Record Type="UI.Parameter">
                                    <PropertyValue Property="PropertyName" PropertyPath="P_ExchangeRateType"/>
                                    <PropertyValue Property="PropertyValue" String="Parameters/P_ExchangeRateType"/>
                                </Record>
                                <Record Type="UI.Parameter">
                                    <PropertyValue Property="PropertyName" PropertyPath="P_NetDueInterval1InDays"/>
                                    <PropertyValue Property="PropertyValue" String="Parameters/P_NetDueInterval1InDays"/>
                                </Record>
                                <Record Type="UI.Parameter">
                                    <PropertyValue Property="PropertyName" PropertyPath="P_NetDueInterval2InDays"/>
                                    <PropertyValue Property="PropertyValue" String="Parameters/P_NetDueInterval2InDays"/>
                                </Record>
                                <Record Type="UI.Parameter">
                                    <PropertyValue Property="PropertyName" PropertyPath="P_NetDueInterval3InDays"/>
                                    <PropertyValue Property="PropertyValue" String="Parameters/P_NetDueInterval3InDays"/>
                                </Record>
                            </Collection>
                        </PropertyValue>
                    </Record>               
                    </Annotation>

Can you please help to identify what could have been missed?

Best Regards

Pradeep

Re: Mandatory cds filters missing in Fiori Overview Page Analytic Card

nawakan — Fri, 21 Jul 2023 03:20:28 GMT

I encountered the same problem as you but the problem is slightly different, I missed "selectionAnnotationPath" in manifest.json. After putting it, it works for me! Thank you for your code.

...
I think your problem is in the annotation file, it should be look like this:
...
<Record Type="UI.Parameter">

</Record>

...
PropertyValue is its default value.

Re: Mandatory cds filters missing in Fiori Overview Page Analytic Card

pradeep_nellore — Fri, 21 Jul 2023 07:18:28 GMT

Thanks. It worked.

Re: Mandatory cds filters missing in Fiori Overview Page...

harishkollipara — Thu, 09 May 2024 20:41:42 GMT

I have a similar issue. But in my case, I am using CDS with parameters and Overview Page.

But global filer in the Overview Page does not show my parameters in the filter criteria.

Not sure what am I missing.

My CDS:

My metadata.json

My OVP:

Any thoughts?

Re: Mandatory cds filters missing in Fiori Overview Page...

Phanindra — Wed, 04 Sep 2024 06:27:41 GMT

Hi Harish,

Did you find the solution for OVP ? we have similar requirement bug we are getting error. Kinldy share your inputs

Question Re: Mandatory cds filters missing in Fiori Overview Page... in Technology Q&A

Mandatory cds filters missing in Fiori Overview Page Analytic Card

Re: Mandatory cds filters missing in Fiori Overview Page Analytic Card

Re: Mandatory cds filters missing in Fiori Overview Page Analytic Card

Re: Mandatory cds filters missing in Fiori Overview Page...

Re: Mandatory cds filters missing in Fiori Overview Page...