The next thing I'm going to do in this POC environment is actually to install an additional Analysis
Services instance that includes the Multidimensional mode Analysis Services.
The reason I'm going to do this is because in my Proof-of-Concept solution I might want to use
Multidimensional, or at least test it. If I don't install it, I can't do that.
In addition to doing that, while I'm installing it, I'm also going to load SQL Server Data Tools, so I have
some kind of development environment. I'll also install Integration Services in case I want to test that. I
may not leave those services running (in the case I'm short on RAM), however I like to have them
So this entire lesson is 100% optional. If you're only need is to run PowerPivot and Power View
solutions, you can skip this completely. But if you want to have a more complete environment, you'll
want to add these items as well.
Again, we're going to perform a new installation of SQL Server 2012, because I don't want to mix other
things into the original POWERPIVOT instance. Again I'll choose "Evaluation", click "Next" on "License
Terms". Select "Feature Installation" again.
For the instance feature selection, I want to install Analysis Services. Then while I'm here I'll go ahead
and install Integration Services as well. Other features I might want to install are Data Quality Client,
Master Data Services, and Data Quality Services...and any others.
For this lesson we'll just focus on Analysis Services and Integration Services components to round out
the basic BI components in the environment.
Once I've selected features, I click "Next", and I do need to specify an instance name. I'm going to use
"MD" for "Multidimensional". This will provide some naming separation between the different Analysis
Services instances. Then click "Next". Then "Next" on the Disk Space page.
Since this is an environment that's intended to be used on a single server, I'll just use the default service
accounts for SSAS. I won't bother using my domain service account for these. But if you'd rather use
the domain service account you certainly can.
I could choose "Multidimensional" or "Tabular". I'll choose "Multidimensional", and add myself as an
instance administrator. Then I'll walk through the remaining forms of the wizard.
We'll let that install, and when it's finished we'll have a multidimensional Analysis Services. We already
have SSRS and PowerPivot. One additional thing we might add to this configuration is yet another
instance of Analysis Services running in Tabular mode. But this isn't 100% necessarily since we can use
PowerPivot for SharePoint for basic Tabular demonstrations.
The wizard is complete, and I can see both of those services have been installed correctly. Now I’ll close
the wizards and exit. If I run Management Studio from the start menu, I can connect to the
Multidimensional Analysis Services instance and make sure it's running--and it is.