Create and Manage Perspectives (SSAS Tabular)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Perspectives define viewable subsets of a model that provide focused, business-specific, or application-specific viewpoints of the model. The tasks in this topic describe how to create and manage perspectives by using the Perspectives dialog box in the model designer.
This topic includes the following tasks:
To create perspectives, you will use the Perspectives dialog box, where you can add, edit, delete, copy, and view perspectives. To view the Perspectives dialog box, in SQL Server Data Tools (SSDT), click on the Model menu, and then click Perspectives.
To add a perspective
To add a new perspective, click New Perspective. You can then check and uncheck field objects to be included and provide a name for the new perspective.
If you create an empty perspective with all of the field object fields, then a user using this perspective will see an empty Field List. Perspectives should contain at least one table and column.
To edit a perspective
To modify a perspective, check and uncheck fields in the perspective’s column, which adds and removes field objects from the perspective.
To rename a perspective
When you hover over a perspective’s column header (the name of the perspective), the Rename button appears. To rename the perspective, click Rename, and then enter a new name or edit the existing name.
To delete a perspective
When you hover over a perspective’s column header (the name of the perspective), the Delete button appears. To delete the perspective, click the Delete button, and then click Yes in the confirmation window.
To copy a perspective
When you hover over a perspective’s column header, the Copy button appears. To create a copy of that perspective, click the Copy button. A copy of the selected perspective is added as a new perspective to the right of existing perspectives. The new perspective inherits the name of the copied perspective and a - Copy annotation is appended to the end of the name. For example, if a copy of the Sales perspective is created, the new perspective is called Sales – Copy.