I am trying to query the SSAS DMVs through a linked server and am not having much luck with the query syntax...
The Linked Server works fine (as I can browse the catalog) but I get an error when trying the following query
SELECT *
FROM SSAS.[Self Service Reporting].[$SYSTEM].DBSCHEMA_TABLES
The error is An invalid schema or catalog was specified for the provider "MSOLAP" for linked server "SSAS".
Any idea?
Thanks
Eric