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

Using Analyze in Excel from SSMS

Often you will have users that use SQL Server Management Studio (SSMS) to write queries or browse data. When you are using SQL Server Management Studio to browse the cube, there is an easy way to quickly connect to Excel to interact with your model. Built into the browser in SSMS is a feature called Analyze in Excel. Once clicked the data and connection that you are viewing is lifted into Excel for further exploration.

How to do it...

  1. Open SQL Server Management Studio and connect to your Tabular Service. Right-click on the database model, Crash_Data_SSASTM, to analyze and select Browse....

    How to do it...

  2. Once the browser opens, ...

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