Tabular models

SQL Server 2012 Tabular models can be deployed either in-memory to the xVelocity engine, or using Direct Query mode. Any MDX client tool can access Tabular models deployed to xVelocity. If the model is deployed using Direct Query mode, it can only be queried through Tabular Models (DAX), not Analysis Services cubes (MDX). You can use both MDX and DAX. It can access any of the BI deployment modes available in SQL 2012. The diagram below outlines this.

The Table object in Anaplan XL can connect to Analysis Services cubes (MDX), Tabular Models (DAX), or relational SQL (SQL). The DAX tables provide access to all Tabular models in SQL 2012.

Grids can be used against In-Memory cubes, and all the standard Anaplan XL functionality can be accessed.

See the normal Analysis Services pages for information on how to use these features. They function consistently with Multidimensional cubes.

Tables provide a simple way of querying a tabular model. They can be used with all of the standard functionality Anaplan XL tables provide.

Insert a table by going to the Anaplan XL ribbon and selecting Insert Data Table > Analysis Services Tabular.

This'll enable you to select a connection to a Tabular cube and bring up the report designer.

Slicers give users pick lists used to filter reports.

Adding a slicer based on Tabular Analysis Services creates a slicer that can be linked directly to a Table.

As with standard cube slicers, you can restrict the members shown to those with data by putting a measure into the Filters section.