Is there a way to run queries on all datasets in a workspace via XMLA/SSMS?
Does anyone know how to get run MDX on all datasets in a workspace via SSMS? I've successfully connected to the XMLA endpoint via SSMS (per MS doc). I can then run queries like this just fine when I connect to a specific dataset/database in the workspace:
SELECT * FROM $System.TMSCHEMA_PARTITIONS
However, I can't figure out how to run this at a "global" level for all datasets/tables at once without having to explicitly connect to EACH dataset first. Hoping someone else has a brilliant idea on how to solve for this.