Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Chapter 5.  Administration of Tabular Models

In this chapter, we will cover the following recipes:

• Managing tabular model properties
• Managing perspectives
• Managing partitions
• Managing roles
• Managing server properties
• Managing Analysis Services memory

Introduction

In the previous chapters, we focused on the recipes that would create a new model focused on the data and how it is organized and displayed. This chapter focuses on recipes that will modify the model properties, how data is stored in partitions, role-based security and server properties. You will learn about the tabular model properties and the most common properties to modify. In addition, there are many ways to change how the model is seen and used by the users. These techniques include adding ...