October 2012
Intermediate to advanced
238 pages
5h 17m
English
Content preview from What's New in SQL Server 2012Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...