| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "SQL Slicers (Administrators)"
(Add links to Constructing a Tree Slicer For SQL) |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 18: | Line 18: | ||
# Select {{Menu|XLCubed|Edit Parameters...}} from the table's right-click menu | # Select {{Menu|XLCubed|Edit Parameters...}} from the table's right-click menu | ||
| − | # Select {{Menu|<Add new slicer>}} or {{Menu|<Add published slicer>}} from the dropdown for the parameter you would like to drive using a slicer: [[File:RelationalSlicersAddNew0.png]] | + | # Select {{Menu|<Add new slicer>}} or {{Menu|<Add published slicer>}} from the dropdown for the parameter you would like to drive using a slicer: [[File:RelationalSlicersAddNew0.png|300px]] |
# Create or select the query to use to return the ID, caption and depth columns. The first column will be used as the parameter; the second will be displayed in the Slicer itself. If you have selected a treeview-style slicer, the depth column will control the item's depth. | # Create or select the query to use to return the ID, caption and depth columns. The first column will be used as the parameter; the second will be displayed in the Slicer itself. If you have selected a treeview-style slicer, the depth column will control the item's depth. | ||
# Select a range to insert the Slicer | # Select a range to insert the Slicer | ||
| Line 26: | Line 26: | ||
As with [[Dimension Slicers]], standalone slicers can be added using the {{Menu|XLCubed|Slicer|SQL...}} ribbon button. These can be used to place their output into an Excel range, or can be linked to one or more SQL data tables, as described above. | As with [[Dimension Slicers]], standalone slicers can be added using the {{Menu|XLCubed|Slicer|SQL...}} ribbon button. These can be used to place their output into an Excel range, or can be linked to one or more SQL data tables, as described above. | ||
| + | |||
| + | == Tree Slicers for Hierarchical Data == | ||
| + | |||
| + | Data returned from a relational database can be displayed in a hierarchical form using tree slicers. More information on how to construct these can be found on [[Constructing a Tree Slicer For SQL]]. | ||
==See Also== | ==See Also== | ||
* [[SQL Slicers (Standard Users)]] | * [[SQL Slicers (Standard Users)]] | ||
* [[SQL Data Tables (Administrators)]] | * [[SQL Data Tables (Administrators)]] | ||
| + | * [[Constructing a Tree Slicer For SQL]] | ||
| + | * [[Driving a SQL Connection from an Excel range]] | ||
[[Category:Relational Reporting]] | [[Category:Relational Reporting]] | ||
[[Category:Slicers]] | [[Category:Slicers]] | ||
[[Category:SQL Getting Started]] | [[Category:SQL Getting Started]] | ||
Latest revision as of 12:16, 21 May 2014
 |
This page describes SQL Slicers for SQL Administrators. For Standard SQL Users, please see SQL Slicers (Standard Users). |
Contents
[hide]Introduction
SQL slicers allow you to take data and metadata from your relational data sources (for example, SQL Server) and use it to easily make selections on linked reports.
Four display options are provided:
Using Slicers for Table Parameters
To automatically add a linked Slicer:
- Select XLCubed > Edit Parameters... from the table's right-click menu
- Select <Add new slicer> or <Add published slicer> from the dropdown for the parameter you would like to drive using a slicer:
- Create or select the query to use to return the ID, caption and depth columns. The first column will be used as the parameter; the second will be displayed in the Slicer itself. If you have selected a treeview-style slicer, the depth column will control the item's depth.
- Select a range to insert the Slicer
- When you accept the dialogs, the new Slicer will be available for input
Standalone Slicers
As with Dimension Slicers, standalone slicers can be added using the XLCubed > Slicer > SQL... ribbon button. These can be used to place their output into an Excel range, or can be linked to one or more SQL data tables, as described above.
Tree Slicers for Hierarchical Data
Data returned from a relational database can be displayed in a hierarchical form using tree slicers. More information on how to construct these can be found on Constructing a Tree Slicer For SQL.
