Perspectives in SSAS



Perspectives are the best way to reduce the complexity of the cube. The main advantage of perspectives is that it wont need any storage in Analysis Server beyond their definition. The following objects can be Hidden or Displayed using a perspective.

  1. Attributes
  2. Dimensions
  3. Measures
  4. Measure Groups
  5. Hierarchies
  6. Actions
  7. KPIs
  8. Calculated Measures

Perspectives are similar to Views in Relational database in that they narrow down the objects that can be seen from a single cube. Lets assume we have a table with 100 columns and using View you can show only limited number of columns that are required and in the same way using perspectives we can HIDE or SHOW the objects of SSAS Cube. For example, the Adventure Works cube in the Adventure Works DW sample Analysis Services database contains eleven measure groups and twenty-one different cube dimensions, representing sales, sales forecasting, and financial data. A client application can directly reference the complete cube, but this viewpoint may be overwhelming to a user trying to extract basic sales forecasting information. Instead, the same user can use the Sales Targets perspective to limit the view of the Adventure Works cube to only those objects relevant to sales forecasting. Lets see the steps to be followed to create a perspective.

  1. Select the Perspectives tab in cube by double clicking cube first and  then clicking Perspective tab next.
  2. Click on New Perspective button which is rounded in the below given image.
  3. In the first row of the Perspective Name column, select the default perspective name and enter a new name for the perspective. Please provide valid name which reflects the purpose of the perspective.
  4. In the Perspective Name column of the new perspective, deselect Measure Groups and Dimensions for the perspective as desired. By default, all measure groups and dimensions are selected.
  5. Process and Deploy the perspective.

To view the Perspective created go to Browser tab and select the Perspective as  shown in below image.

Browsing Perspectives
Browsing Perspectives

To delete the perspective please follow the steps give below.

  1. Go to Perspectives tab.
  2. Select the perspective name which you wish to delete.
  3. On the toolbar of the Perspectives tab, click the Delete Perspective icon to delete the perspective, or right-click in the Perspective Name column and select Delete Perspective.
  4. Deploy and Process the cube.

PFB the screenshot of the same.

Deleting a Perspective
Deleting a Perspective

That’s it and hope this was helpful to you guys !


Roopesh Babu V


  1. Truly plenty of terrific info!
    [url=]college papers writing service[/url] letter writing service berkeley [url=]buy essay writing service[/url] essay writing paper

  2. You’ve made the point!
    [url=]the best thesis editing service[/url] thesis on service quality and customer retention [url=]television hypothesis[/url] thesis helper online

  3. You have made your point pretty well.!
    [url=]thesis st[/url] interpretive thesis [url=]developing a thesis statement[/url] thesis writing service providers

  4. Whoa all kinds of excellent tips!
    [url=]medical school personal statement[/url] essay helper app [url=]help with writing essays[/url] buy essay help

  5. Good content. Cheers!
    [url=]help writing essay[/url] cheap essay help [url=]essay on helping poor people[/url] custom essay help

  6. Reliable stuff. Kudos!
    [url=]dissertation for dummies[/url] help writing dissertation literature review [url=]buy dissertation online[/url] buy your dissertation online

  7. Nicely put, With thanks!
    [url=]best write my paper[/url] pay someone to write my paper cheap [url=]essay writter[/url] write my custom paper

  8. Nicely put, Kudos!
    [url=]published dissertations online[/url] dissertation for sale [url=]dissertation proofreading service[/url] dissertation proposal

  9. You mentioned that terrifically.
    [url=]write my paper for me free[/url] i cant write my college essay [url=]write essays[/url] where can i write my essay

  10. You stated that superbly!
    [url=]proposal writing service[/url] dissertation writing company [url=]proquest dissertations[/url] find dissertations online

  11. With thanks! A lot of advice.
    [url=]custom term paper writing services[/url] buy college papers online [url=]cheap custom papers[/url] where to buy college papers

  12. With thanks! I appreciate this.
    [url=]how to write an abstract for a research paper[/url] write my research papers [url=]write my college paper[/url] paper writer

  13. Superb advice. Appreciate it!
    [url=]write my research paper for me[/url] essay writer website [url=]do my paper for me[/url] write my paper for me

  14. Thanks, Useful information.
    [url=]best online essay writing services[/url] writing essay services [url=]linkedin writing service[/url] essay writing service blog

  15. Nicely put. Thank you.
    [url=]dissertation def[/url] write a dissertation [url=]dissertation editors[/url] custom dissertation writing

  16. You’ve made your stand very nicely..
    [url=]essay writing samples[/url] best essay writing service in usa [url=]essay writing paper[/url] essay review service

  17. Kudos, I value this!
    [url=]writing essays service[/url] pro essay writing service [url=]custom paper writing service[/url] top essay writing service

  18. Nicely put, Appreciate it!
    [url=]best rated essay writing service[/url] essay service reviews [url=]essay paper writing service[/url] help with college essay writing

  19. Beneficial postings. Cheers.
    [url=]pay for college papers[/url] order essay [url=]buy college essays[/url] pay to write essay

  20. Useful data. Thank you.
    [url=]linkedin writing service[/url] writing a descriptive essay [url=]ebook writing service[/url] essay writing service

  21. You actually said this adequately!
    [url=]do my homework[/url] homework [url=]pay someone to do my homework[/url] online coursework

  22. Position well taken.!
    [url=]write my essay for free[/url] professional essay writers [url=]professional essay writers[/url] what should i write my college essay about

  23. Kudos! Terrific stuff.
    [url=]pay for paper[/url] paper writer services [url=]graduate paper writing service[/url] best paper writing services

  24. Thank you! Excellent stuff!
    [url=]should i do my homework[/url] homework [url=]do my college homework[/url] homework help

  25. Kudos. I enjoy this!
    [url=]pay someone to do my homework[/url] xyz homework [url=]coursework[/url] pay to do my homework

  26. Thank you, Loads of content.
    [url=]pay to write paper[/url] best paper writing services [url=]pay for research paper[/url] pay someone to write paper

  27. You expressed that perfectly.
    [url=]writing a good essay[/url] write my essay cheap [url=]writing a persuasive essay[/url] writing an opinion essay

  28. Very good write ups. Many thanks.
    [url=]essay helper free[/url] essay help [url=]essay helper online[/url] essays help

  29. Thanks, An abundance of data.
    [url=]essay writing site[/url] fast essay writing service [url=]affordable essay writing service[/url] best custom essay writing service

  30. Thanks! Valuable information.
    [url=]free writing assistant[/url] help with essay writing [url=]essay bot[/url] medical school personal statement

  31. Very good content. Cheers.
    [url=]thesis titles[/url] thesis sentence [url=]tentative thesis[/url] define thesis statement

  32. Kudos! Quite a lot of info.
    [url=]online paper writing service[/url] pay for research paper [url=]graduate paper writing service[/url] pay someone to write your paper

  33. Information effectively applied.!
    [url=]pay for essays[/url] pay for papers [url=]buy an essay online[/url] buy essay online

  34. Nicely put, Kudos.
    [url=]how to write a college essay[/url] essaypro [url=]medical school personal statement[/url] essays help

  35. You said it really well.
    [url=]write a thesis[/url] thesis writer [url=]a good thesis statement[/url] argumentative thesis statement

  36. Nicely expressed genuinely. !
    [url=]buy dissertations[/url] dissertation [url=]phd dissertation[/url] phd dissertation help

  37. You said that adequately!
    [url=]definition of dissertation[/url] writing help [url=]dissertation uk[/url] dissertation def

  38. With thanks, Numerous knowledge!
    [url=]do my homework[/url] homework [url=]homework help[/url] do my math homework

  39. Kudos, A lot of tips.
    [url=]essay write[/url] who can write my essay [url=]write my essay for free[/url] online essay writers

  40. Thank you, Helpful stuff.
    [url=]dissertation service[/url] writing dissertation [url=]dissertation writers[/url] dissertations

  41. Amazing quite a lot of valuable information.
    [url=]writing helper[/url] essay writing help [url=]help with essay writing[/url] essay bot

  42. Fantastic knowledge. Regards!
    [url=]writing an opinion essay[/url] writing a persuasive essay [url=]write my resume for me[/url] write me an essay

  43. You made your point.
    [url=]pay for essay[/url] pay for paper [url=]essays for sale[/url] buy essay online

  44. Excellent knowledge. Kudos!
    [url=]term paper help[/url] research proposal [url=]termpaper[/url] research paper help

  45. Whoa a lot of good tips.
    [url=]cheap research paper writing service[/url] proposal writer [url=]buy term paper[/url] parts of a research proposal

  46. Reliable advice. With thanks!
    [url=]term paper[/url] proposal essay [url=]research proposal cover page[/url] proposal introduction


Please enter your comment!
Please enter your name here

59 + = 68