Boosting User Experience with Perspectives in Analysis Services
Perspectives are a feature in Analysis Services that enable the designer to control which portions of the data model are exposed to the users. When designed and implemented correctly, perspectives can greatly improve the experience for your end-users.
Dimensional models (when designed correctly using conformed dimensions) are incredibly intuitive to the business users – much MUCH more so than an OLTP data model designed in the 3rd (or higher!) normal form – which is just one of the primary reasons they continue to be found in the majority of successful business intelligence implementations.
Tags: design