Problem We have an ad-hoc reporting system that implemented in .ASPX and MVC. This website retrieves data through MDX queries. However, we are having a problem when we want to modify the MDX queries, we must re-build and deploy our application. It requires a long downtime period in our system. Approach To avoid the issue, … Continue reading How to execute a MDX query in SQL store procedure
Scenario SQL Server Analysis Service (SSAS) supports only Window Authentication mode. If you want to connect SSAS remotely from your local machine using some client tools such as SQL Server Management Studio (SSMS), Tableau or others... you will encounter an issue of connecting to SSAS. This is because these tools run under you local account … Continue reading How to connect Microsoft SQL Server Analysis Service remotely?
Create linked server to Analysis Services Server Create a T-SQL script to gather all CUBE(s) and generate XMLA script. There are two ways to gather CUBE(s) Use OPENQUERY to gather information via the linked server which we have just created Use a text file and BULK INSERT statement. The txt file contains all CUBE(s) nameDECLARE … Continue reading How to backup all CUBE(s) via T-SQL script