Perspectives in SSAS

By
roopesh.valluru
-
181
13325

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

181 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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

− 5 = 4