Perspectives in SSAS

By
roopesh.valluru
-
335
14108

Friends,

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.
Perspectives
Perspectives

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 !

Regards,

Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

335 COMMENTS

  4. creative writing course in mumbai
    [url=”https://bestdissertationwritingservice.net”]proquest dissertations[/url]
    dissertation thesis writing

  5. buy art online berlin
    [url=”https://customdissertationwritinghelp.com”]how to write a dissertation proposal[/url]
    get help with dissertation

  7. writing paper help
    [url=”https://dissertationhelperhub.com”]custom dissertation writing services[/url]
    best dissertation writing service uk

  8. how to cite a dissertation
    [url=”https://dissertationwritingcenter.com”]dissertation writing service[/url]
    proposal and dissertation help geography

  13. dissertation introduction
    [url=”https://professionaldissertationwriting.org”]uk dissertation writing help online[/url]
    what does dissertation mean

  53. This means a man may be able to obtain several erections during that period buy priligy pakistan Medications in this class are used to treat erectile dysfunction, pulmonary artery hypertension, benign prostatic hypertrophy BPH , or the concurrent treatment of erectile dysfunction and BPH

  62. Удобный комплект от L’Oreal Paris —суперстойкая гелевая подводка и скошенная кисть для ее нанесения для создания вытянутых к вискам и раздвоенных стрелок, как на показах прошедшей Недели моды в Париже. Вся информация на сайте носит информационный характер и не является публичной офертой. Стоимость и наличие товаров необходимо уточнять перед покупкой в розничных магазинах. Интернет-магазин профессиональной декоративной косметики Гелевый карандаш, плавно и легко наносится на кожу. Придает глубину взгляду и выразительность.С водостойким эффектом. Срок годности до 1 октября 2022 года. Жидкая подводка Eyeliner Ink от Pierre Rene – традиционный инструмент, словно баночка с чернилами для классических стрелок. Идеально прорисовывает веко, легка в использовании даже для новичков. Увеличивает контур глаза, делая взгляд выразительным и глубоким. В натуральном сегменте, почему-то, не так распространены подводки именно коричневого цвета, я уже не говорю о цветных, поэтому выбор у меня был небольшой… либо Хаушка, либо Лавера… Оба бренда из Германии и я сделала выбор в пользу более бюджетной и, как вы уже догадались, это было ошибкой. https://ricardopkzr653198.blogscribble.com/12896500/народный-рецепт-для-роста-ресниц Это средство поможет создать вам яркий и красивый образ, позаботится о вашей естественной красоте. Оно доступно и практично, а главное эффективно и действенно. Тысячи женщин по всей стране смогли оценить преимущества этого препарата на собственном опыте. Возможно, теперь пришла и ваша очередь. Это прозрачный гель для фиксации бровей. Удерживает необходимую форму в течение дня, не придает излишнего блеска. Обладает приятным запахом. Идеально подходит для волос любого цвета. Определите, для чего именно вам нужен гель для бровей. Если от природы у вас густые и темные брови, и вы хотите лишь слегка подчеркнуть их форму, выбирайте прозрачный фиксирующий гель. Отзыв о товаре Гель для бровей и ресниц фиксирующий VIVIENNE SABO Fixateur, тон 02 прозрачный Rose Inc Renew Enriched Clear Shaping Gel — это сыворотка-гель, которая укладывает и фиксирует непослушные брови. Средство питает, увлажняет и укрепляет волосы благодаря увлажняющим и укрепляющим ингредиентам вроде сквалана, ростков гороха, витаминов Е и В5.

  71. You said it nicely.!
    prescription drugs online without [url=https://canadarx-drugservices.com]online canadian discount pharmacy[/url] canadian pharcharmy online no precipitation

  76. Wow a good deal of wonderful material.
    canadian drugs [url=https://canadapharmacies-24h.com]canada prescription plus pharmacy[/url] list of approved canadian pharmacies

  79. Reliable content. Thank you.
    canadian drugstore online [url=https://canadianpharmacyonlinedb.com]international drug mart canadian pharmacy online store[/url] pharmacy near me

  97. Really plenty of wonderful information.
    write the essay [url=https://topswritingservices.com]essay writing graphic organizers[/url] professional personal statement writers

  101. Perfectly voiced truly! .
    writing about yourself essay [url=https://quality-essays.com]how to write an essay about yourself for college[/url] website that writes your essay for you

  105. You actually expressed it fantastically!
    writing persuasive essays [url=https://theessayswriters.com]https://theessayswriters.com/[/url] phd dissertation writing service

  114. Information effectively regarded..
    cheap essay writing service online [url=https://homeworkcourseworkhelps.com]https://homeworkcourseworkhelps.com/[/url] custom writing company

  132. You actually reported that exceptionally well.
    academic essay writing [url=https://essaypromaster.com]https://essaypromaster.com/[/url] top dissertation writing services

  134. Helpful postings. With thanks.
    best 10 online canadian pharmacies [url=https://canadianonlinepharmacybase.com]overseas pharmacies[/url] approved canadian online pharmacies

  136. Very good material, Appreciate it!
    custom essay writing online [url=https://freshapps.space]how to write a paragraph essay[/url] professional essay writing services

  140. Incredible many of amazing material.
    top rated canadian pharmacies online [url=https://canadianonlinepharmacybase.com]list of legitimate canadian pharmacies[/url] canadian drugstore online

  152. Wow all kinds of excellent facts!
    canadian drugs online pharmacy [url=https://canadapharmacyspace.com]best canadian mail order pharmacies[/url] us pharmacy no prior prescription

  153. Nicely put. With thanks.
    college essay guidelines [url=https://essaywriting4you.com]https://essaywriting4you.com/[/url] professional cv and resume writing services

  159. Seriously lots of helpful info!
    how to write a successful college essay [url=https://quality-essays.com]https://quality-essays.com/[/url] best resume writing services nyc

  162. Useful content. Cheers.
    canadian pharmacies that ship to us [url=https://canadarx-drugservices.com]prescription without a doctor’s prescription[/url] canadian pharmacy drugs online

  169. Regards! Quite a lot of postings.
    discount canadian drugs [url=https://canadianpharmacylist.com]canada pharmacies online prescriptions[/url] canadian drugstore reviews

  173. You actually revealed it very well!
    how to write essays faster [url=https://dissertationwritingtops.com]https://dissertationwritingtops.com/[/url] best resume writing services online

  201. [url=https://erythromycintab.online/]erythromycin pills sale[/url] [url=https://buytoradol.life/]toradol pill prices[/url] [url=https://buypropecia.life/]finasteride 1mg price[/url] [url=https://tetracycline.today/]tetracycline 500mg capsules cost[/url]

  204. [url=https://domperidone.shop/]buy motilium canada[/url] [url=https://citalopram.guru/]citalopram brand name uk[/url] [url=https://vermox.golf/]vermox mexico[/url]

  210. [url=https://doxycycline.beauty/]doxycycline 100mg[/url] [url=https://tamoxifen.run/]nolvadex 20 mg online buy[/url] [url=https://bactrim.sale/]bactrim cost[/url] [url=https://cozaar.cfd/]cozaar brand[/url] [url=https://sildalis.life/]sildalis[/url]

  215. [url=http://buycafergot.life/]cafergot no prescription[/url] [url=http://strattera.run/]240 mg strattera[/url] [url=http://buyzofran.life/]zofran generic over the counter[/url] [url=http://zofran.xyz/]zofran price canada[/url] [url=http://celebrex.agency/]celebrex generic price in india[/url] [url=http://neurontin.wtf/]order gabapentin[/url] [url=http://atomoxetine.click/]strattera cost generic[/url]

  217. [url=https://buysilagra.life/]silagra online[/url] [url=https://zovirax.cfd/]acyclovir pills over the counter[/url] [url=https://fluoxetine.works/]fluoxetine 20mg prices[/url] [url=https://modafinil.guru/]provigil 20 mg[/url] [url=https://buydiclofenac.life/]voltaren pills where to buy[/url] [url=https://buytadalafil.life/]buy cialis for daily use online[/url] [url=https://suhagratab.online/]suhagra 50 mg tablet price in india[/url]

  218. [url=https://strattera.run/]strattera 25[/url] [url=https://buytretinoin.life/]tretinoin 0.5 cream price[/url] [url=https://prednisolone.company/]buy cheap prednisolone[/url] [url=https://valtrex.business/]valtrex generic price[/url] [url=https://buylyrica.quest/]lyrica drug[/url] [url=https://celebrex.agency/]celebrex 20 mg[/url]

  227. [url=https://buycanadianpharmacy.quest/]safe canadian pharmacies[/url] [url=https://fluoxetine.works/]fluoxetine 20 mg brand name[/url] [url=https://buyonlinedrugstore.life/]escrow pharmacy canada[/url] [url=https://buychloroquine.life/]how much does aralen cost[/url]

  230. [url=http://metformind.quest/]glucophage 850[/url] [url=http://antabuser.com/]can i buy antabuse over the counter[/url] [url=http://tadalafild.shop/]cheapest generic tadalafil 20mg[/url] [url=http://albuterol.life/]albuterol cheapest price[/url] [url=http://lisinopriltabs.shop/]zestril canada[/url] [url=http://ventolinmd.online/]combivent nebulizer[/url]

  236. [url=https://happyonlinedrugstore.online/]pharmacy[/url] [url=https://clomidclomiphene.online/]clomid drug[/url] [url=https://metformin247.online/]metformin otc canada[/url]

  237. [url=https://cafergot.cfd/]cafergot online australia[/url] [url=https://propecia.run/]finasteride 1mg cost[/url] [url=https://lyricatab.monster/]buy lyrica online australia[/url] [url=https://happydrugstore.quest/]indian pharmacy[/url]

  242. Incredible quite a lot of amazing data!
    canadian pharmacies that ship to us [url=https://canadapharmacyspace.com/]cialis canada pharmacy[/url] canadian meds

  244. Beneficial stuff. Cheers.
    legal drugs in canada [url=https://canadadrugspower.com/]24 store pharmacy reviews[/url] online ed medication no prescription

  255. [url=http://tretinoinretina.online/]retin a cream buy australia[/url] [url=http://amitriptylinetab.online/]elavil pain[/url] [url=http://sertralinezoloft.shop/]zoloft generic price[/url] [url=http://sildenafilrx.online/]buy viagra wholesale[/url] [url=http://ivermectinstromectol.shop/]ivermectin price[/url] [url=http://diflucantabs.shop/]can you buy diflucan without a prescription[/url]

  259. In an age adjusted model, there was a positive association between cholesterol levels and breast cancer p trend, 0 priligy amazon 2008 that MC degranulation contributes to initiating analgesia during acupuncture, and some physical therapy, such as cupping or massage, may also use this pathway

  263. Thanks, Ample data!
    putney general store pharmacy [url=https://canadianpharmacyonlinedb.com/]legitscript canadian pharmacy[/url] canadian pharmacy antiobotics without perscription

  264. [url=https://cafergottab.online/]cafergot no prescription[/url] [url=https://vardenafil247.com/]online levitra canada[/url] [url=https://propecia.sbs/]finasteride price in india[/url] [url=https://elavilamitriptyline.online/]amitriptyline 40mg[/url] [url=https://zithromaxtabs.online/]zithromax 100 mg[/url] [url=https://sertralinezoloft.shop/]generic zoloft 25 mg[/url] [url=https://synthroidlevothyroxine.online/]synthroid buy online[/url]

  267. You made your position extremely well..
    cvs pharmacy rx rewards [url=https://canadianpharmacyonlinedb.com/]best canadian online pharmacy 2022[/url] pharmacy without prescription

  269. Amazing tons of valuable facts!
    best online non prescription pharmacy [url=https://canadianpharmaceuticalsonlineus.com/]kamagra oral jelly[/url] top canada drugs review

  270. Many thanks. A good amount of facts!
    silkroad online pharmacy review [url=https://northwestpharmacylabs.com/]best drugstore makeup[/url] canadian pharmacy cialis no prescription

  285. [url=https://phenergan.sbs/]phenergan pharmacy nz[/url] [url=https://anafraniltabs.monster/]clomipramine anafranil[/url] [url=https://dapoxetineavana.online/]dapoxetine in us[/url] [url=https://zovirax.life/]zovirax cost in india[/url] [url=https://citalopram.live/]citalopram 10 mg tablets[/url] [url=https://etrazodone.com/]online trazodone[/url] [url=https://cheapviagrapharm.com/]buy viagra with discover card[/url]

  288. [url=http://clomidtab.net/]clomid 5 mg[/url] [url=http://seroqueltabs.shop/]seroquel 100mg price[/url] [url=http://finpecia.site/]finasteride 5 mg[/url] [url=http://metformina.net/]can i buy glucophage over the counter[/url] [url=http://cheapviagrapharm.com/]viagra tablets for sale[/url] [url=http://amoxicillinmed.online/]purchase amoxil[/url] [url=http://zoloftx.org/]sertraline zoloft[/url] [url=http://neurontintabs.com/]average cost of gabapentin[/url]

  289. Awesome info. Appreciate it!
    canadian pharmacies that don’t require prescriptions [url=https://sopharmsn.com/]levitra online canadian pharmacy[/url] texas chemist online pharmacy

  297. [url=https://lisinoprilprinivil.shop/]1 lisinopril[/url] [url=https://cheapviagrapharm.com/]viagra online paypal canada[/url] [url=https://synthroidv.com/]synthroid 05 mg[/url]

  299. You’ve made your position quite clearly!.
    canada online pharmacy legitimate [url=https://sopharmsn.com/]mail order drugs without a prescription[/url] integrity rx specialty pharmacy

  301. You definitely made the point.
    medicine online shopping [url=https://spharmacymsn.com/]anabolic steroids online pharmacy reviews[/url] legitimate canadian mail order pharmacy

  302. [url=https://prozactab.com/]prozac online australia[/url] [url=https://vardenafil.sbs/]buy levitra 20 mg online[/url] [url=https://buycanadianpharmacy.monster/]all med pharmacy[/url] [url=https://amoxicillina.org/]augmentin 625[/url] [url=https://bactrimds.shop/]generic bactrim[/url] [url=https://flagyl.cfd/]flagyl 500 mg[/url]

  313. [url=http://phenergan.icu/]can you buy phenergan over the counter nz[/url] [url=http://antibioticsotc.com/]omnicef best price[/url] [url=http://colchicine.sbs/]colchicine 1 mg tab[/url] [url=http://gabapentin247.com/]neurontin 800mg[/url]

  316. com 20 E2 AD 90 20Jual 20Viagra 20Asli 20Di 20Tangerang 20 20Viagra 20Australia 20Pbs jual viagra asli di tangerang The 3 year old who was among those wounded at Cornell Square Park on Thursday in the Back of the Yards neighborhood was identified by his family as Deonta Howard, critically wounded when a bullet entered his ear pregnant on clomid It seems to be very close, but the distance between each artifact is actually millions of kilometers

  330. ATF3 upregulation under stress was proven to be mediated exclusively by the p38 signaling pathway in HeLa cells, while through ERK, SAPK and p38 in colorectal cancer 18, 56 cialis online ordering Spirostan type saponins are the most common steroid saponins in plants

LEAVE A REPLY

Please enter your comment!
Please enter your name here

4 + 1 =