cancel
Showing results for 
Search instead for 
Did you mean: 

Mandatory cds filters missing in Fiori Overview Page Analytic Card

pradeep_nellore
Participant
0 Kudos
867

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

View Entire Topic
nawakan
Discoverer
0 Kudos

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">

<PropertyValue Property="PropertyName" PropertyPath="Parameters/P_KeyDate"/>

<PropertyValue Property="PropertyValue" String="20230721"/>

</Record>

...
PropertyValue is its default value.

pradeep_nellore
Participant
0 Kudos

Thanks. It worked.