[00:00:00.00]
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.
[00:00:22.07]
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 available.
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.
[00:01:21.23]
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.
[00:01:43.03]
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.
[00:02:15.14
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.
[00:02:38.25]
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.
[00:03:12.25]
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.
[00:03:42.19]
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.
