Unable to Create Linked Server for SSAS Provider MSOLAP
Recently I ran into an odd scenario. Net new SQL servers were built in Dev, QA and Prod. I had to create Linked Servers to SSAS. All of these were on SQL …
Read MoreTag: SSAS
SQL Server Analysis Services Tabular Model Management using Powershell
This is a relatively a short blog providing a general introduction to SQL Server Analysis Services Tabular Model management using Windows Powershell. You can discover and learn more about Powershell from …
Read MoreSQL Server Analysis Services – Using the DMV MDSCHEMA_ACTIONS in SSAS
In last blog which was about Microsoft SQL Server Analysis Services – Tabular Model Actions which can be found here, described how to create new Actions in the Tabular Model using …
Read MoreSQL Server Analysis Services – Assign a Default Measure in SSAS Tabular Model Solution
It has been rather long time since I had posted any content online. Perhaps I was lazy. Well this post is on SQL Server Analysis Services (SSAS) and precisely here we …
Read MoreSQL Server: Understanding the RELATED function in DAX
DAX Functions for Querying BISM tabular models Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 …
Read MoreSQL Server: Configuring SQL Server 2012 Denali SSAS Engine in tabular mode
Configuring SQL Server 2012 Denali SSAS Engine in tabular mode Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released …
Read More