The three models
Whether you are a BI developer or the DBA charged with keeping Analysis Services up and running, you need to know about the three different server models. These models determine the types of solutions that can be delivered in your organization.
The three models are Multidimensional and data mining (the default mol), Tabular, and PowerPivot for Shareoint. You can only run one model per instance. If you need more than one, you can run all three models as separate instances on the same server, if you so wish. If you later find that you have installed the wrong model, you can uninstall it and re-install another. The three models function in different ways and we will explore each model in the upcoming section.
Tip
Check with your business ...
Get What's New in SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
