Blogs from Wise Owl on Other topics in SSAS tabular

Showing blogs 1-3 (out of 3)

How to use DirectQuery to run queries in SSAS Tabular against SQL Server tables

Posted by Andy Brown on 22 February 2016

DirectQuery mode allows you to run queries in Analysis Services (Tabular) directly against the underlying SQL Server tables imported into the model. This blog explains what DirectQuery is, shows how to enable it and gives an idea of its pros and cons.

This blog shows how to create your first tabular project in Visual Studio

Posted by Andy Brown on 11 November 2015

Before you can get started with tabular SSAS, you need to check you have Analysis Services (tabular model) installed on your computer. This blog also shows you how to run and configure Visual Studio, and how to create your first tabular project.

A full tutorial blog on how to create Analysis Services Tabular models

Posted by Andy Brown on 07 November 2015

From SQL Server 2012 onwards there is an alternative way of working with Analysis Services. Say goodbye to difficult-to-create cubes and dimensions, and embrace the new tabular model server mode instead! When finished this tutorial will cover everything you need to know, from creating your first data model to creating measures using DAX expressions.

This page has 0 threads Add post