I am interested in a more effective way to get my data from PPM into Tableau. We are using an on-demand solution and we have connected to PPM via the OData Service. However, this only allows us to connect to one table at a time. Tableau does not allow joining on these different data sources and only allows data blending - which is not meeting our join requirements because we have ~5 tables we want to pull data from.
Is there a way to write a custom SQL query with the OData service so that we can derive a table in Tableau with all of our required data ?