Tabular

Revision as of 15:59, 16 March 2012 by Colin Overton (talk)

Introduction

In Sql Server 2012 Microsoft introduced the new BISM Tabular model of Analysis Services cube.

XLCubed can access these data sources using the existing Grid, Slicer and Formula functionality, and adds new functionality to allow reporting against these.

XLCubed accesses Tabular models using the DAX language, which can also be used to create your own cube calculations in the workbook.

Queries can be sent to cubes in either In-Memory (xVelocity) or Direct Query modes.

Tables

Tables provide the simplest way of querying a tabular model. All of the standard functionality provided by XLCubed tables can be used.

Slicers

Calculations

Formula