As you add more and more measures, measure groups, and dimensions, it gets more and more complex. To a casual user, it may get too complex to browse. However, to an advanced analyst, there is a benefit of having as much as possible in one single cube. To solve this conflict, Analysis Services has a concept called perspective. You can think of perspectives as a view over your cube.
To create a perspective, perform the following steps:
Open up the Adventure Works DW2012.cube cube from the Solution Explorer.
Select the Perspectives tab.
Click on the New Perspective button.
Change the value of Perspective Name to
Simple Perspective.Select the following objects to be included in the perspective:
Fact Internet SalesSales AmountOrder DateProductInternet Sales KPIAll Products Except BikesTop 10 Products by Reseller SalesMarginRatio to parent productBikes and ClothingYear to DateTwelve Month Moving AverageYear Over Year Growth %
Deploy...