Set up SSAS (Analysis Services) on Denali

Set up SSAS (Analysis Services) on Denali

I have setup a virtual machine on Hiper-V to analyze the SQL Server Denali CTP3 bits. One of the β€œnew” features I was interested on was the upgrade on the SSAS side. As probably most of you have been reading, there is a double path on the Analysis Services area, to go on the tabular or the OLAP model. To solve that it has been defined the BISM (Business Intelligence Semantic Model), you can find additional information β€˜La biblioteca de PowerPivot’ from my SolidQ Colleagues. What I have found has really surprised me because you have to decide on the installation path (as you can see in the figure below) if you want to setup a tabular or a multidimensional instance. That means that the SSAS engine is totally different and you have to setup separate instances names even if you want to have both models in your company. (more…)