SQL Server Analysis Services 2012 Cube Development Cookbook

Defining perspectives

As mentioned earlier in this chapter, Analysis Services perspectives are similar to views defined in the relational database. Each multidimensional SSAS project could contain multiple cubes, several measure groups, hundreds of measures, many hierarchies, and thousands of attributes. Many cube users might only need a subset of these attributes to get their job done. Including unnecessary options in the reports and analytical views could simply confuse data consumers; instead, you should try to expose only the essential attributes to each user group by defining perspectives. Unlike relational views, perspectives should not be used for implementing security; they are simply intended to conceal the complexity of your solution. ...