In this chapter we will be focusing on the new features that catapult both SQL Server and Analysis Services straight into the 21st century. Some of these features we have not touched upon, particularly surrounding the advances in PowerPivot and SharePoint. These are specialist topics, and are big enough to demand a book of their own.
When we first read about the new Analysis Services features, one of the first things that immediately came to our attention was the new tabular architecture model. There are now three models to choose from when configuring SQL Sever Analysis Services, so we will explore all three to help you understand which one you need. We will examine how to set up the three models, how to find out which one is running and how to change the model.
You will learn how to override the string store limit of 4 GB and upgrade projects from earlier versions of SQL Server to take advantage of this new storage capability.
We found this chapter particularly...