Parameter for Field Label Instead of Technical Name in the Result of Odata Report Query

[former_member730062]

Dear Experts,

We are creating odata query url in order to expose report data from C4C to Power BI. Is there any parameter which provide us field label instead of field technical name in relevant service output since it takes some time to map field technical name and related label name for report in the Power BI. For instance; we need Changed By, instead of CCHANGED_BY in the result. In my opinion its not possible but I wanted to be sure not to miss something (like a different url parameter) about this.

Thanks

Mertkan

[SchneiderIgor · Accepted solution]

Dear Mertkan,

Hope you are doing well. 🙂

These descriptions (e.g. Changed By) will not be available within report response itself, it just brings entity results. In order to check those label descriptions (e.g. Changed By instead of CCHANGED_BY), you can get the metadata of the analytical object. It also includes technical field names, data types and annotations.

Example: <your system hostname>/sap/byd/odata/<shortened name of work center>_analytics.svc/$metadata?entityset=RP<report ID>QueryResults

It can also be generated following these steps: Go to Business Analytics work center > Go to Design Reports work center view > Search for the XYZ report > Click on Build OData Queries > Click on Generate Metadata Query.

It is also explained by this following blog post along with some different aspects for OData queries:

OData for SAP Business ByDesign

Hope this helps 😄

Best regards,

Igor

[former_member730062 · Accepted solution]

Dear Igor,

Many thanks for detailed information:)

Mertkan