Browsing your model with SQL Server Management Studio

As a developer, you will want to explore the model prior to releasing it for use. SQL Server Management Studio provides you with a way to browse the model and ensure everything is performing as expected. This recipe shows you how to connect to the model and explore dimensions and measures.

How to do it...

  1. Open SQL Server Management Studio and select Analysis Services... from the connect drop-down box.

    How to do it...

  2. Type in your Analysis Services server name and click Connect.
    How to do it...

  3. Expand the Analysis Services server ...

Get Tabular Modeling with SQL Server 2016 Analysis Services Cookbook 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.