SSAS Perspectives
Perspectives apply to Tabular endpoints only.
Perspectives require Developer or Enterprise edition of SQL Server Analysis Services. They are not supported on the Standard edition of SQL Server Analysis Services or on the Standard tier of Azure Analysis Services. Deploying a perspective on an unsupported edition will complete without errors, but the perspective will not be visible in front-end tools.
Tabular models can become complex with numerous tables, fields, and measures, making it challenging for users of analysis and visualisation tools to maintain an overview and quickly locate what they need. SSAS Perspectives address this by allowing a focused subset of objects from the model to be presented to end users.
A perspective represents a specific subject area — for example, a "Finance" perspective that includes only objects related to finance. When a user connects to a perspective in a front-end tool, any objects outside that subset are hidden, providing a streamlined view of the model.
Add or edit a perspective
In Jet Analytics Data Integration, expand the Deliver instance, right-click Deliver instance model, and select Manage Perspectives.
In the Perspectives window, click Add to create a new perspective.
Double-click the perspective header to rename it — for example, "Finance Model".
Select the checkboxes for the objects to include in the perspective. When all objects in a table are selected, the table is marked with a checkmark. When only some objects are selected, the table is marked with a dot.
Click OK after selecting the objects.
Deploy and execute the Deliver instance for the perspective to take effect.
Use a perspective in a front-end tool
Power BI
Select Get Data > From Analysis Services.
Enter the server name and credentials, then select the SSAS database and the desired perspective. Click OK.
Excel
Select Get Data > From Analysis Services.
Enter the server name and credentials, then select the SSAS database and the desired perspective. Click Finish.
SQL Server Management Studio
Browse the SSAS database in SSMS.
Click the three-dot menu next to the SSAS database in the Browse tab, select the perspective, and click OK.
Troubleshooting
Error:No data fields are available in the OLAP cube.
Ensure that at least one measure is selected in the perspective.