oData + Reporting + Related Entities

  We need to build couple of reports in SSRS that need data from multiple entities of a Mendix application. We have created a Published oData Service containing all the required entities for our SSRS reports. Beyond having associated entity's ID, we don't see attributes of the associated entities. We are looking for design choices/ patterns on how to 'join' the related entities for the above SSRS reports.
1 answers

This article describes how to expose data to BI tools using odata, and how to create relationships between datasources: https://docs.mendix.com/howto6/exposing-data-to-bi-tools-using-odata