Difference between revisions of "Tabular"
(Created page with "== 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...") |
|||
| Line 3: | Line 3: | ||
In Sql Server 2012 Microsoft introduced the new BISM Tabular model of Analysis Services cube. | 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 [[ | + | XLCubed can access these data sources using the existing [[Grid]], [[Slicers|Slicer]] and [[Formula_Reporting_Overview|Formula]] functionality, and adds new functionality to allow reporting against these. |
| + | |||
| + | XLCubed accesses Tabular models using the [http://msdn.microsoft.com/en-us/library/ee634396%28v=sql.110%29.aspx 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 == | ||
Revision as of 15:59, 16 March 2012
Contents
[hide]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.
