Create and Manage Perspectives (SSAS Tabular)
APPLIES TO:SQL Server Analysis ServicesAzure Analysis Services
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.