Microsoft® SQL Server 2012 Unleashed

Cube Perspectives

A new feature in SSAS is cube perspectives. This is essentially a way to create working views of a complex cube that is focused on just what a particular user or group of users need. They don’t need all the dimensions, calculations, levels, and key performance indicators (KPIs) that would otherwise be visible as part of a complex SSAS cube. Therefore, you need a method to tailor or limit a larger cube environment to be just what the users need and nothing more—hence, the cube perspective. Figure 53.56 shows the Perspectives tab in the cube designer. It allows you to easily customize a view (perspective), which is what will be deployed or referenced to a target user group. In this example, you are creating a new perspective called ...