3428908 - No Code Selection Available For Latin Language In OData Query

The user has a report on Business Partner that includes script information, specifically Latin script. However, they are unable to extract address information from an OData query in Latin because no script code is available to filter the Address Information in Latin.

SAP Business ByDesign

1. Go to  Business Analytics workcenter
2. Go to Design Reports view
3. Select the Report (For Example: Business Partner Report)
4. Select Build OData Queries
5. Go to Filters Tab
6. Select Generate Data Query/Metadata Query

Observe the data is not retrieved in Latin Language.

In SAP Business ByDesign Analytics, the Code for Latin is registered as "#" in the system. This is expected system behavior.  However, when selecting the filter by "#", OData will not be interpreted correctly.

Here Address is taken as an example, this could happen with the other fields as well.

Use Filter (CADDRESS_REPRESENTATION_CODE lt 'A') and (CMAIN_ADDRESS eq true). This will give the correct result and return only LATIN address. 

https://<Host Name>/sap/byd/odata/ana_businessanalytics_analytics.svc/<ReportName>?$filter=(CADDRESS_REPRESENTATION_CODE lt 'A') and (CMAIN_ADDRESS eq true)

NOTE: In OData ' ' is not recognized in query parameters.

Latin Language, OData Query, Business Analytic, Script code, Code Selection , KBA , AP-RC-ADR , Address , Problem