SAP BEx Query in ODATA not populating key property "ID"

[former_member186643]

Hi experts,

• we have a very simple SAP Bex query containing one dimension and one measure.
• OLE DB for OLAP and ODATA checkboxes are selected

• There is an ODATA Service defined on that query
• Type: Controller for MDX (SAP BW) 2.0

It is described here:

Now, when we run this service selecting dimension and measure, the key property field "ID" in the result set is empty. Maybe that causes an issue when we try to bind the service to a vizframe in sapui5 as the charts only show the last record?

With other queries, where there is ID filled, we have no problems:

Has anyone experienced similar behavior and how can we resolve this? Why is the ID field sometimes populated and sometimes it is not?

Many thanks,

Thomas Heinrich

This issue has been resolved: The Problem was that the query setting for the dimension was set to "Show as Text". To generate an ID in OData, the key obviously has to be displayed as well. When we changed the query to show key and text, the result was as expected and the ID was populated.

[former_member186643 · Accepted solution]

This issue has been resolved: The Problem was that the query setting for the dimension was set to "Show as Text". To generate an ID in OData, the key obviously has to be displayed as well. When we changed the query to show key and text, the result was as expected and the ID was populated.