Perspective

Perspective

Overview

In a SQL Server Analysis Services (SQL) database, a perspective is a limited view of a cube. Perspectives enhance a user's experience by limiting the cube's visible objects to those objects relevant to the user's work. For example, a business that sells products through brick-and-mortar stores and online may have a cube with separate measure groups for reseller sales (sales at a store) and for internet sales (sales online). An employee in the Internet division of the company is probably only interested in internet sales, so an Analysis Services database developer could create an Internet Sales perspective that hides everything except the dimensions and measure groups related to internet sales.

It is very important to know that perspectives do not secure a database. Users can freely select data from one perspective or another and from the cube itself; perspectives do not stop users from accessing the data that they hide. Perspectives exist solely to enhance the user experience by making the cube appear less complex and more relevant. Security in Analysis Services is achieved through roles.


See Also

 


Other Languages

This article is also available in the following languages:

Brazilian Portuguese (pt-BR)

Leave a Comment
  • Please add 6 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Richard Mueller edited Revision 7. Comment: Removed (en-US) from title, added tag

  • Fernando Lugão Veltem edited Revision 4. Comment: added portuguese version

  • Ed Price MSFT edited Revision 3. Comment: Added "See Also" section.

  • Matt Burr MSFT edited Original. Comment: Added a link to SQL BOL tutorial on creating a Perspective.

Page 1 of 1 (4 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Matt Burr MSFT edited Original. Comment: Added a link to SQL BOL tutorial on creating a Perspective.

  • Ed Price MSFT edited Revision 3. Comment: Added "See Also" section.

  • Fernando Lugão Veltem edited Revision 4. Comment: added portuguese version

  • Richard Mueller edited Revision 7. Comment: Removed (en-US) from title, added tag

Page 1 of 1 (4 items)