Create and Manage Perspectives
Collapse the table of content
Expand the table of content

Create and Manage Perspectives (SSAS Tabular)


Applies To: SQL Server 2016

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.

Perspectives (SSAS Tabular)
Hierarchies (SSAS Tabular)

Community Additions

© 2016 Microsoft