Difference between revisions of "Tabular"
(→Tables) |
|||
| Line 23: | Line 23: | ||
Insert a table by going to the XLCubed ribbon and selecting ''Insert Data Table -> Analysis Services Tabular'' | Insert a table by going to the XLCubed ribbon and selecting ''Insert Data Table -> Analysis Services Tabular'' | ||
| − | This will allow you to select a connection to a Tabular cube, and bring up the report designer. | + | This will allow you to select a connection to a Tabular cube, and bring up the [[TabularDesigner|report designer]]. |
| − | |||
| − | |||
| − | |||
== Slicers == | == Slicers == | ||
Revision as of 17:07, 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.
Grids
Grids can be used against In-Memory cubes, and all the standard XLCubed 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
Tables provide a simple way of querying a tabular model. All of the standard functionality provided by XLCubed tables can be used.
Insert a table by going to the XLCubed ribbon and selecting Insert Data Table -> Analysis Services Tabular
This will allow you to select a connection to a Tabular cube, and bring up the report designer.
Slicers
Slicers give users simple to use pick lists which can be used to filter reports.
By adding a slicer based on Tabular Analysis Services you create 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.
The following slicer gives all the years for which there is Sales data.
Calculations
You can create new DAX calculations for your report without updating the cube.
These calculations are stored with the workbook, and are available from any grid, table or formula in the book.
Click the DAX button (highlighted) to create a new calculation, and then use the controls on the right to select
- Table the measure will appear int
- Name for the measure
- Formula to define the measure
You can drag tables, columns and measures from the tree on the left into the formula area to insert their names.
Formula
Please see the Tabular section of the formula reference.
