Usability

Large enterprise models support many users from across the organization and typically each user only requires access to a section of the model. For example, a sales team member may only need to access a sales fact table and several dimension tables and thus shouldn't have to navigate through many other irrelevant tables that support other business teams. Perspectives in Analysis Services allow the modeler to map objects of the model (tables, columns, and measures) to a specific perspective such that users connecting to the model via the perspective only see those objects.

Display folders including hierarchies of folders (that is, subfolders) can be defined for Analysis Services models to simplify user access to measures and columns. ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.