SSRS, Reporting Services, SQL Server, Business Inteligence, Pentaho, T-SQL
I deployed OLAP database to SSAS on customers servers many times. Few times I got stuck of that I was not able to create object trough XMLA script and I was so close, and I didn’t know that.
Of course, it depends on your permissions, but in my case, just run Management Studio like Administrator. What is the key to succeed
Sometimes the solution is so easy.
Once I came to customer to implement OLAP solution I found that I am not able to deploy my OLAP XMLA database script since customer Analysis services installed on server was switched in tabular mode and my OLAP database was designed for multidimensional mode. This post is not focused on difference between tabular and multidimensional mode. But in short. Analysis services supports tree modes. Multidimensional, Pivot for Sharepoint and Pivot mode. Mode is set trough installation process. Here I come with quick “how to” switch from tabular to multidimensional mode. Hopefully it saves time to you when you come to the same situation.
Go to SSAS installation directory, in my case it was situated on C:\Program Files\Microsoft SQL server\MSAS14.MSSQLServer\OLAP\Config\ and find msmdsrv configuration settings file. Open it in notepad or another texts editor.
Find DeploymentMode tag and change it to 0. 2 is for Tabular mode,0 for multidimensional mode, 1 for Pivot for Sharepoint.
After you finish editing configuration file restart SSAS service. You can do it through Windows->Services or using SQL Management Studio as shown on picture bellow.
