2738161 - Error Message 'Property Not Found in Type' Appears During an OData Query

You are using 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 001.2019 for example and receive the error message 'Property 001.2019 not found in type RP[your report ID]QueryResult'.

• SAP Cloud for Customer
• SAP Business by Design

You are using an incorrect OData URL and the selection or filter used in the query does not work. This usually happens for the Accounting Period/ Year field.

Please check the value used in the report selection. In the OData URL the period was entered with the UI format, for example 001.2019. This format is incorrect for OData and the right format would be 012019.

Correct OData Query: 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 012019

You can also enter the format like this 0012019 or 12019.

More information can be found in the following blog: OData for SAP Business by Design Analytics.

odata, error message, odata query, odata URL, selection, filter parameter type, property not found, value not valid for variable, generate data query , KBA , accounting period , period/ year , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions