Using Tabular Models - SQL Server Analysis Services 2012 Cube Development - page 352

Implementing perspectives
Perspectives are similar to views in relational databases. Perspectives allow you to
create views of the model that may serve a specific function or help a specific user
group. For instance, you could create perspectives that only show finance measures
and dimensions. You can reduce the number of visible tables and the fields for users
to make the user experience better.
Note
While tempting, you should not use perspectives as a security tool. They are not
designed for security but for ease of use and visual organization of the model.
Getting ready
You will be expanding on the model we have been working on throughout this chapter.
We will be creating a perspective that focuses on product orders and hides most of
the customer data.
How to do it…
Similar to partitions in the previous recipe, you can open the Perspectives dialog
from the toolbar or menu and then perform the following steps:
1. In the Perspectives dialog, click on the New Perspective button. You can
name this perspective Product Order . There is a series of checkboxes in
the new column next to the table and the field definition on the right.
2. Because this perspective focuses on products, select the Product and
Product Category tables. If you expand the Product table, you will see
that all fields have been selected. Next, expand the Internet Sales table,
and select some fields that you feel are relevant to this perspective, such as
Order Date , Order Quantity , Sales Amount , Average Sales , Total
Cost , and Total Sales .