Symptom
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.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Analytics workcenter
- Go to Design Reports view
- Select the Report (For Example: Business Partner Report)
- Select Build OData Queries
- Go to Filters Tab
- Select Generate Data Query/Metadata Query
Observe the data is not retrieved in Latin Language.
Cause
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.
Resolution
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.
Keywords
Latin Language, OData Query, Business Analytic, Script code, Code Selection , KBA , AP-RC-ADR , Address , Problem