PowerPivot - Perspectives

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Many times when developing larger Analysis Services cubes you may find it necessary to use Perspectives to logically split up your cube so users can find what they want faster. A perspective is similar to a TSQL view because it will take a larger object (the cube) and filter out objects that you want to split up. It cannot however perform business logic or filtering of data like a view can. So the case for perspectives would be if you have a cube for your entire company but you don't want HR to have to filter through sales data to find what they need, and you don't want the sales team to have to filter through HR data. Having perspectives would save the user valuable time in finding the data they need without having to sift through other's data.

Read more...

Tags: design, v2, perspective

 

2007-2015 VidasSoft Systems Inc.