How to pass parameters to MDX script through ADOMD libraries?

In the previous article, I provided the simple example to start working on ADOMD libraries. The small application was implemented to execute the MDX file. The MDX query returns data from Jan to September in 2014 and the same period in 2013 (Year-To-Date report) Now, we need a flexible method that allows us to choose … Continue reading How to pass parameters to MDX script through ADOMD libraries?

How to execute MDX query with ADOMD libraries

In previous article, I introduced the solution to execute a MDX query by SQL store procedure. However, it has some limitation such linked server performance, user permission... There are other approaches to overcome those disadvantages of the store procedure. In this article, I will introduce ADOM.NET library which also support executes a MDX file. It … Continue reading How to execute MDX query with ADOMD libraries

How to connect Microsoft SQL Server Analysis Service remotely?

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?