Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Create and Manage Perspectives (SSAS Tabular)

SQL Server 2012

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.