O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required