Testing a Tabular Model in Excel
Excel is a convenient tool to browse and query a Tabular Model so that you can validate your design. Rather than opening Excel and connecting to the deployed model on the Tabular server, you can open Excel directly from the model designer and connect it to the workspace database.
How to do it…
You will use Excel to browse the Tabular Model using the data in the active workspace database on the development machine. Before you continue, make sure you have Excel 2010 or Excel 2013 installed on the development computer:
- On the left-hand side of the toolbar in the model designer, click on the Analyze in Excel icon. Again, this icon is not labeled but has a tooltip when you hover over it.
This action will open an instance ...
Get SQL Server Analysis Services 2012 Cube Development 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.
