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

  47. Point certainly regarded.!
    [url=]write this essay for me[/url] write my essay [url=]what should i write my college essay about[/url] automatic essay writer

  48. Thanks. I value it.
    [url=]write an essay for me[/url] write paper for me [url=]writing a personal essay[/url] essay writer website

  49. Wow tons of very good material!
    writing a narrative essay [url=]cheap paper writing service[/url] scholarship essay writing service

  50. Amazing a good deal of helpful data!
    [url=]hire someone to do my homework[/url] coursework [url=]homework help[/url] do my homework for money

  51. Appreciate it. An abundance of posts!
    [url=]writing paper[/url] website that writes papers for you [url=]how to write an apa paper[/url] lined writing paper

  52. Nicely put, Thanks.
    [url=]smart writing service[/url] buy essay writing service [url=]writing an informative essay[/url] best essay service

  53. Helpful information. Many thanks.
    [url=]urgent essay writing service[/url] writing a narrative essay [url=]cheap paper writing service[/url] college papers writing service

  54. Perfectly voiced certainly. !
    [url=]essay writing help[/url] easy essay writing [url=]executive resume writing service[/url] cheap custom essay writing service

  55. can you get mobic without rx [url=]get mobic no prescription[/url] how to get cheap mobic without a prescription

  56. cost generic mobic without prescription [url=]can you buy cheap mobic without prescription[/url] cost cheap mobic pill

  57. non prescription ed pills [url=]erection pills that work[/url] pills erectile dysfunction

  58. Nicely put. Kudos!
    best college paper writing service [url=]coursework help[/url] i finished my homework what do i do now [url=]can you do my homework[/url] bart simpson i will do my english homework cheap law essay writing service [url=]scientific thesis statement[/url] building a thesis [url=]personal narrative thesis[/url] thesis websites

  59. With thanks! A lot of advice.
    buy essay writing service [url=]do my term paper[/url] master paper writers [url=]research paper writer service[/url] how to write an apa paper analytical essay writing service [url=]genuine essay writing service[/url] coursework writing service review [url=]essay writing app[/url] what is a good essay writing service

  60. Amazing content, Thanks a lot.
    [url=]make an essay[/url] who can write my essay [url=]essay writer[/url] writing a good essay

  61. Superb info, Kudos.
    mba admission essay writing service [url=]psychology essay writing service[/url] custom essay writing service org reviews [url=]admission essay writing service[/url] cheap cv writing service home visit will writing service [url=]write my dissertation[/url] dissertation online [url=]professional dissertation help[/url] dissertation definition

  62. Nicely put, Thanks a lot!
    is monster resume writing service worth it [url=]write my thesis paper[/url] a thesis will [url=]best master thesis writing service[/url] thesis subject cheap writing service review [url=]bachelor thesis writing service[/url] best essay writing service in usa [url=]best resume writing service 2020[/url] write my essay service

  63. Wow a lot of beneficial material!
    [url=]college admissions essay writing service[/url] best essay service [url=]best essay service[/url] my essay service

  64. You actually reported this very well.
    [url=]best resume writing service 2019[/url] writing a personal essay [url=]reliable essay writing service[/url] argumentative essay writing

  65. Nicely put. Thank you!
    uk assignment writing service reviews [url=]paying someone to write a paper for you[/url] top research paper writing service [url=]apa paper writing service[/url] what are the best research paper writing service graduate school essay writing service [url=]professional paper writing service[/url] best professional paper writing service [url=]best custom papers[/url] buying college papers

  66. Thanks a lot. Loads of info!
    [url=]paper help[/url] paper writing service [url=]pay for papers[/url] custom handwriting paper

  67. To read present scoop, dog these tips:

    Look representing credible sources: It’s important to secure that the report origin you are reading is respected and unbiased. Some examples of virtuous sources subsume BBC, Reuters, and The New York Times. Interpret multiple sources to get back at a well-rounded view of a discriminating info event. This can support you listen to a more complete facsimile and dodge bias. Be hep of the viewpoint the article is coming from, as flush with reputable report sources can have bias. Fact-check the information with another origin if a scandal article seems too staggering or unbelievable. Always be sure you are reading a advised article, as tidings can change-over quickly.

    By means of following these tips, you can evolve into a more aware of dispatch reader and best know the world here you.

  68. Amazing tons of very good knowledge.
    best resume writing service 2019 [url=]best website to do my homework[/url] do my math homework for me online [url=]cpm homework help[/url] need someone to do my statistics homework mental health writing service [url=]write a research paper[/url] professional term paper writer [url=]write my college paper[/url] paper writing services

  69. Tips well utilized..
    [url=]tentative thesis[/url] thesis help [url=]thesis binding[/url] working thesis

  70. Wonderful facts. Thanks.
    college essay writing service reviews [url=]coursework writing service[/url] to do my homework in spanish [url=]my homework[/url] should i do my homework in the morning graphic design resume writing service [url=]thesis paper[/url] problem solution thesis [url=]write my thesis paper for me[/url] college board synthesis essay

  71. Incredible loads of good info!
    [url=]essay writing topics in english[/url] cover letter writing service [url=]wikipedia writing service[/url] writing services

  72. You actually suggested that terrifically.
    best resume writing service 2019 [url=]pay to have essay written[/url] buy original essays online [url=]pay to have an essay written[/url] essays online to buy allied dunbar will writing service [url=]do my college essay[/url] write my python code for me [url=]someone write my essay[/url] pay someone to do my essay

  73. You revealed it wonderfully!
    best resume writing service in usa [url=]writing dissertation service[/url] uk dissertation writing service [url=]uk dissertation help[/url] help with writing dissertation mba essay writing service uk [url=]research proposal writing[/url] help writing a term paper [url=]term paper custom[/url] parts of research proposal

  74. Thanks! Plenty of facts!
    [url=]phd dissertation writing[/url] dissertation service [url=]dissertation help[/url] definition of dissertation

  75. Kudos. Numerous info!
    pre writing essay examples [url=]dissertation help glasgow[/url] dissertation abstracts search [url=]difference between a thesis and a dissertation[/url] buy dissertations essays writing service [url=]thesis on customer service delivery[/url] explanatory thesis [url=]thesis add privacy policy and terms of service to footer[/url] best thesis and dissertation proposal service uk

  76. Absolutely! Finding news portals in the UK can be unendurable, but there are numerous resources at to cure you think the perfect the same because you. As I mentioned in advance, conducting an online search with a view “UK scuttlebutt websites” or “British information portals” is a pronounced starting point. Not but purposefulness this chuck b surrender you a comprehensive shopping list of report websites, but it choice also afford you with a punter understanding of the coeval news view in the UK.
    Once you secure a file of potential account portals, it’s prominent to gauge each anyone to influence which upper-class suits your preferences. As an benchmark, BBC News is known in place of its intention reporting of report stories, while The Keeper is known pro its in-depth opinion of bureaucratic and social issues. The Unconnected is known representing its investigative journalism, while The Times is known in the interest of its work and investment capital coverage. By way of understanding these differences, you can choose the news portal that caters to your interests and provides you with the newsflash you have a yen for to read.
    Additionally, it’s significance looking at close by scuttlebutt portals with a view explicit regions within the UK. These portals produce coverage of events and good copy stories that are akin to the area, which can be exceptionally cooperative if you’re looking to hang on to up with events in your local community. In place of exemplar, municipal good copy portals in London number the Evening Standard and the Londonist, while Manchester Evening News and Liverpool Reproduction are in demand in the North West.
    Comprehensive, there are numberless news portals at one’s fingertips in the UK, and it’s high-ranking to do your inspection to unearth the one that suits your needs. At near evaluating the contrasting news programme portals based on their coverage, variety, and editorial viewpoint, you can select the one that provides you with the most fitting and attractive despatch stories. Good fortunes with your search, and I anticipation this data helps you reveal the perfect news broadcast portal since you!

  77. Many thanks! Plenty of posts.
    [url=]write my research paper[/url] college term papers [url=]proposal research[/url] research proposal

  78. Very good postings. Many thanks!
    [url=]college essay writing tips[/url] essay writing service buy [url=]writing a college admission essay[/url] essay writing service uk cheap

  79. canadian and international rx service [url=]canada pharmacy without prescription[/url] pharmacy online canada

  80. Nicely put, Kudos!
    [url=]writing help[/url] phd weight loss [url=]dissertation paper[/url] dissertation paper

  81. Incredible a good deal of beneficial knowledge.
    [url=]phd dissertation[/url] dissertations online [url=]dissertation[/url] dissertation paper

  82. farmacie online autorizzate elenco [url=]acquistare farmaci senza ricetta[/url] farmacia online

  83. zithromax buy [url=]buy azithromycin over the counter[/url] zithromax 500 mg lowest price pharmacy online

  84. mexican border pharmacies shipping to usa [url=]Mexico pharmacy online[/url] mexico drug stores pharmacies

  85. Искал в Яндексе место, где можно поиграть в казино на деньги, и вот он – прямо на первом месте. Сайт порадовал большим выбором казино с игровыми автоматами, бонусами на депозит и статьями о том, как правильно играть, чтобы выиграть.

  86. medication from mexico pharmacy [url=]Mexico pharmacy online[/url] medicine in mexico pharmacies

  87. BirminghamLive brings you live updates from Aston Villa's first Premier League Summer Series pre-season friendly against Newcastle at the Lincoln Financial Field in Philadelphia pnvs6 The visitors are back in the group stage of the competition after 21 years. Interestingly, Milan went on to become the champions the last time Newcastle played in the Champions League in the 2002-03 season. Newcastle take on Tottenham live on Wednesday 15 July, just one of several great exclusive fixtures. Sheffield U. vs. Newcastle * Average Corner Kicks per match between Newcastle United and their opponents in a single match. Previewing England vs. Ukraine in the EURO 2024 qualifiers at Wrocław’s Tarczyński Arena. Dive into team analyses, recent form, and the significance of this thrilling encounter on neutral ground.
    Leandro Trossard of Arsenal (Photo by Sebastian Frej MB Media Getty Images) At minimum, Spurs fans will be expecting another top-four finish to maintain their status as a Champions League-worthy side, but the appetite for a trophy is only growing given it’s been 15 years since they last hoisted a cup (the 2008 League Cup).  ottenham’s latest new era begins away at Brentford as Ange Postecoglou is handed two tough fixtures to start to life in north London. This site is pProvided by Football Web PagesYou can Create a website for your club right now! We may have video highlights with goals and news for some Tottenham Hotspur matches, but only if they play their match in one of the most popular football leagues. Tottenham Hotspur Football Club, usually known as Tottenham or Spurs, was founded in 1882. Based in North London, they are one of the most visible clubs in the world, but not as successful as some of their Premier League rivals.

  88. Конструктивно стабилизатор напряжения “Штиль” выполнен в виде настенного блока с табло индикации на передней панели, одной розеткой евростандарта на боковой панели, выключателем сети и автоматическим предохранителем на нижней панели, для подключения к сети имеется кабель с вилкой евростандарта.

    стабилизаторы напряжения

  89. buying from online mexican pharmacy: medication from mexico pharmacy – medicine in mexico pharmacies
    canadianpharmacymeds com [url=]canadian pharmacy 365[/url] canadianpharmacyworld com

  90. indian pharmacy: best online pharmacy india – reputable indian online pharmacy
    mexican online pharmacies prescription drugs [url=]mexico drug stores pharmacies[/url] mexican drugstore online

  91. top 10 pharmacies in india: buy prescription drugs from india – india pharmacy mail order
    medication from mexico pharmacy [url=]mexico drug stores pharmacies[/url] buying prescription drugs in mexico online

  92. canadian pharmacy review: escrow pharmacy canada – canada pharmacy online legit
    online shopping pharmacy india [url=]best online pharmacy india[/url] indianpharmacy com

  93. legit canadian pharmacy online: canadian family pharmacy – canadian 24 hour pharmacy
    online shopping pharmacy india [url=]indian pharmacy[/url] online pharmacy india

  94. top 10 pharmacies in india: india pharmacy mail order – top online pharmacy india
    buying prescription drugs in mexico [url=]pharmacies in mexico that ship to usa[/url] purple pharmacy mexico price list

  95. buy sildenafil online no prescription [url=]best price generic sildenafil 20 mg[/url] sildenafil 50mg tablets

  96. generic doxycycline online [url=]Buy doxycycline for chlamydia[/url] buy doxycycline monohydrate

  97. amoxicillin 500mg no prescription [url=]cheap amoxicillin[/url] can you buy amoxicillin uk

  98. prinivil 20 mg cost [url=]lisinopril 10 mg for sale without prescription[/url] generic for zestril

  99. canada drug pharmacy [url=]safe online pharmacy[/url] canadian pharmacy checker

  100. viagra pfizer 25mg prezzo [url=]viagra online siti sicuri[/url] viagra generico in farmacia costo

  101. dove acquistare viagra in modo sicuro [url=]viagra online spedizione gratuita[/url] viagra online consegna rapida

  102. comprare farmaci online all’estero [url=]kamagra gel prezzo[/url] comprare farmaci online all’estero

  103. comprar viagra online en andorra [url=]comprar viagra[/url] viagra para hombre precio farmacias

  104. farmacias online seguras [url=]farmacia online internacional[/url] п»їfarmacia online

  105. farmacia online envГ­o gratis [url=]kamagra 100mg[/url] farmacia online envГ­o gratis

  106. farmacias baratas online envГ­o gratis [url=]cialis en Espana sin receta contrareembolso[/url] farmacia barata

  107. Viagra sans ordonnance livraison 48h [url=]Meilleur Viagra sans ordonnance 24h[/url] Viagra pas cher livraison rapide france

  108. Acheter mГ©dicaments sans ordonnance sur internet [url=]cialis generique[/url] Pharmacie en ligne livraison gratuite

  109. Sildenafil 100mg online bestellen [url=]Viagra Generika online kaufen ohne Rezept[/url] Viagra Tabletten

  110. Viagra 100 mg ohne Rezept [url=]Viagra online bestellen Schweiz[/url] Potenzmittel Generika online kaufen

  111. mexico drug stores pharmacies [url=]mexican mail order pharmacies[/url] buying prescription drugs in mexico online

  112. mexico drug stores pharmacies [url=]mexican border pharmacies shipping to usa[/url] medicine in mexico pharmacies

  113. mexico pharmacies prescription drugs [url=]buying prescription drugs in mexico[/url] mexican border pharmacies shipping to usa

  114. reputable mexican pharmacies online [url=]purple pharmacy mexico price list[/url] mexican drugstore online

  115. indian pharmacy [url=]buy prescription drugs from india[/url] indian pharmacy

  116. vipps canadian pharmacy [url=]best canadian pharmacy online[/url] canadian pharmacy king reviews

  117. indian pharmacy [url=]reputable indian online pharmacy[/url] indian pharmacy paypal

  118. the best ed pills [url=]best ed pills[/url] medicine erectile dysfunction

  119. amoxicillin 500mg capsule [url=]where can you buy amoxicillin over the counter[/url] buy amoxicillin online mexico

  120. where buy cheap clomid pill [url=]where buy generic clomid no prescription[/url] can i purchase clomid tablets

  121. ciprofloxacin mail online [url=]ciprofloxacin generic[/url] buy ciprofloxacin over the counter

  122. where to buy amoxicillin 500mg without prescription [url=]amoxicillin 500mg prescription[/url] amoxicillin azithromycin