O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing perspectives

As your models grow in size and complexity, it is easy for users to be overwhelmed by the amount of data, dimensions, and measures. Perspectives enable you to create views of the model that are limited in size based on your requirements. Using our example, you could create a perspective that limits the data to being greater than 2010 and weather accidents that occurred under rain and severe winds.

Getting ready

Download the code for the Crash_Data database from the Packt website and load into a SQL Server database named Crash_Data_DB.

How to do it...

In this recipe, you will create a new perspective to limit the dimensions and measures that are exposed. Users who have access to this partition, will only see the selected data. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required