Symptom
You used an oData URL like https://my[your system URL].sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/RP[your report ID]QueryResults?&$filter=[your filter/selection characteristic] eq 'value for filter/selection' for example and received the error message 'Invalid parametertype used at function eq'.
Environment
-
SAP Cloud for Customer
- SAP Business by Design
Cause
You are using an incorrect oData URL and the selection or filter used in the query does not work.
Resolution
Please check the report metadeta via oData and here the parameter type for the field you would like to use.
Metadeta oData Query: https://my[your system URL].sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/$metadata?entityset=RP[your report ID]QueryResults.
You can also use the Build Odata Queries feature to check the report metadeta.
When you check the metadeta, please search for the field you used in your link and the parameter type.
-
If it shows Edm.String, the values have to be used in ' '.
- If it shows Edm.Int64, the values have to be used without the inverted comma in the oData Query.
See Also
More information can be found in the following blog: OData for SAP Business by Design Analytics.
Keywords
odata, error message, odata query, parameter, exception, odata URL, selection, filter parameter type , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To