3732698 - User Having issue while running analytics Odata query.

User getting empty results when running a O data query even though he has the required authorization.

 SAP Cloud for Customer core applications 2508

Run the O data query in the browser and login with user XYZ it is returning the data. However with the user ABC it is retuning zero data even though both users have same authorization.

User 'ABCc' running the query which is generated by 'XYZ' in his system. Here XYZ maintained time zone in UTC and user ABC system time zone is Indian time zone.

When a query is generated by a user in his system which has a specific time zone and another user with different time zone trying to run the query then it results zero data.

Based on time zone, when they use date fields as filters, the date format is different in the query which  results empty data.

Example : datetime format is 'CDOC_CHANGEDATETIME%20ge%20'05.03.2026' in query generated by user XYZ, and it will be in format "(CDOC_CHANGEDATETIME%20ge%20%2720260305102751.0000000%27)" for user ABC.

The same query can be generated by affected user in his system then it will work as expected and give results correctly.

Another way is  using that date field in filter they can generate query and replace the date format in the existed query then the same query will work.

Example ("CDOC_CHANGEDATETIME%20ge%20'05.03.2026' " replace it with "(CDOC_CHANGEDATETIME%20ge%20%2720260305102751.0000000%27)" ) then the same query will work.

O data not working, O data issue, O data results zero data, authorization issue in O data, user cannot run O data query, O data, user with authorization cannot run the query, O data issue, O data query not working. , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , AP-RC-ANA-BYD , ByD Analytics , Problem