MDX request to System SSAS cube does not display the results

CAUDMONT Amaury 0 Reputation points
2024-07-18T12:22:16.54+00:00

Hello,

I'm trying to do some requests to analyse the usage of our cubes.

All requests on $SYSTEM.DISCOVER_SESSIONS made in Microsoft SQL Server Studio or even in PowerShell are working well.

However, everytime I try to request $SYSTEM.DISCOVER_CONNECTIONS, the query is failing, I can only retrieve the XML of the result in PowerShell, but never the result of the query. It's the same with MSSS, The toolbar is totally empty after sending the query.

Is it a bug? How can we access $SYSTEM.DISCOVER_CONNECTIONS data?

Thanks

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,270 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.