Difference between revisions of "Tabular"
(→Calculations) |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (24 intermediate revisions by 6 users not shown) | |||
| Line 1: | Line 1: | ||
== Introduction == | == Introduction == | ||
| − | + | 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, they can only be queried through DAX, and not MDX. FluenceXL version 7 can use both MDX and DAX, and so can access any of the BI deployment modes available in SQL 2012. The diagram below outlines this. | |
| − | + | [[Image:XLC2012.png|650px|centre]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| + | The new Table object in FluenceXL can connect to Analysis Services cubes (MDX), Tabular Models (DAX), or relational SQL (SQL). The [http://msdn.microsoft.com/en-us/library/ee634396%28v=sql.110%29.aspx DAX] tables provide access to all Tabular models in SQL 2012. | ||
== Grids == | == Grids == | ||
| − | [[Grids]] can be used against In-Memory cubes, and all the standard | + | [[Grids]] can be used against In-Memory cubes, and all the standard FluenceXL functionality can be accessed. |
See the normal Analysis Services pages for information on how to use these features, they function consistently with Multidimensional cubes. | See the normal Analysis Services pages for information on how to use these features, they function consistently with Multidimensional cubes. | ||
| Line 19: | Line 16: | ||
== Tables == | == Tables == | ||
| − | [[Tables]] provide a simple way of querying a tabular model. All of the standard functionality provided by | + | [[Tables]] provide a simple way of querying a tabular model. All of the standard functionality provided by FluenceXL tables can be used. |
| + | |||
| + | Insert a table by going to the FluenceXL 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 [[TabularDesigner|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. | |
| + | [[Image:TabularSlicerExample.png]] | ||
| − | == | + | == Hierarchies == |
| + | |||
| + | As of [[Version 7.6]] FluenceXL supports tabular hierarchies, provided the server is on SSAS2012 SP1 or above. | ||
| + | |||
| + | Hierarchies can be used in two ways: | ||
| + | * Placed on the Filter area - you get a treeview to select the report filter. | ||
| + | ** This can also be linked to a treeview slicer if required. | ||
| + | * Placed on the Selected Columns area - you can drill into the data by double clicking a value, and drill back up by double clicking the column header. | ||
== Calculations == | == Calculations == | ||
| − | You can create new DAX calculations for your report without updating the cube. | + | You can create new [http://msdn.microsoft.com/en-us/library/ee634396%28v=sql.110%29.aspx DAX] calculations for your report without updating the cube. |
These calculations are stored with the workbook, and are available from any [[Grids|grid]], [[Tables|table]] or [[XL3LookupTabular|formula]] in the book. | These calculations are stored with the workbook, and are available from any [[Grids|grid]], [[Tables|table]] or [[XL3LookupTabular|formula]] in the book. | ||
| + | |||
| + | Access the wizard through the '''Custom Calculations''' ribbon item. 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 in | ||
| + | * 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. | ||
[[Image:DaxManageCalcs.png]] | [[Image:DaxManageCalcs.png]] | ||
| Line 41: | Line 62: | ||
== Formula == | == Formula == | ||
| − | [[Formula_Reference#Tabular_Formulae| | + | Please see the Tabular section of the [[Formula_Reference#Tabular_Formulae|formula reference]]. |
| + | |||
| + | ==See Also== | ||
| + | *[[Tabular Designer]] | ||
| + | *[[Tables]] | ||
| + | |||
| + | [[Category:DAX Getting Started]] | ||
| + | [[Category:Tabular Reporting]] | ||
Latest revision as of 09:39, 4 July 2023
Contents
[hide]Introduction
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, they can only be queried through DAX, and not MDX. FluenceXL version 7 can use both MDX and DAX, and so can access any of the BI deployment modes available in SQL 2012. The diagram below outlines this.
The new Table object in FluenceXL 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
Grids can be used against In-Memory cubes, and all the standard FluenceXL 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 FluenceXL tables can be used.
Insert a table by going to the FluenceXL 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.
Hierarchies
As of Version 7.6 FluenceXL supports tabular hierarchies, provided the server is on SSAS2012 SP1 or above.
Hierarchies can be used in two ways:
- Placed on the Filter area - you get a treeview to select the report filter.
- This can also be linked to a treeview slicer if required.
- Placed on the Selected Columns area - you can drill into the data by double clicking a value, and drill back up by double clicking the column header.
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.
Access the wizard through the Custom Calculations ribbon item. 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 in
- 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.
