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. ...
Get Tabular Modeling with SQL Server 2016 Analysis Services Cookbook 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.
