Difference between revisions of "SQL Slicers (Standard Users)"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 17: | Line 17: | ||
To automatically add a linked Slicer: | To automatically add a linked Slicer: | ||
| − | # Select {{Menu| | + | # Select {{Menu|FluenceXL|Edit Parameters...}} from the table's right-click menu |
# Select {{Menu|<Add published slicer>}} from the dropdown for the parameter you would like to drive using a slicer: [[File:RelationalSlicersStdAddNew0.png]] | # Select {{Menu|<Add published slicer>}} from the dropdown for the parameter you would like to drive using a slicer: [[File:RelationalSlicersStdAddNew0.png]] | ||
# 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 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. | ||
| Line 25: | Line 25: | ||
== Standalone Slicers == | == Standalone Slicers == | ||
| − | As with [[Dimension Slicers]], standalone slicers can be added using the {{Menu| | + | As with [[Dimension Slicers]], standalone slicers can be added using the {{Menu|FluenceXL|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. |
==See Also== | ==See Also== | ||
* [[SQL Slicers (Administrators)]] | * [[SQL Slicers (Administrators)]] | ||
* [[SQL Data Tables (Standard Users)]] | * [[SQL Data Tables (Standard Users)]] | ||
| + | * [[Driving a SQL Connection from an Excel range]] | ||
[[Category:Relational Reporting]] | [[Category:Relational Reporting]] | ||
[[Category:Slicers]] | [[Category:Slicers]] | ||
| + | [[Category:SQL Getting Started]] | ||
Latest revision as of 08:32, 4 July 2023
 |
This page describes SQL Slicers for Standard SQL Users. For SQL Administrators, please see SQL Slicers (Administrators). |
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 FluenceXL > Edit Parameters... from the table's right-click menu
- Select <Add published slicer> from the dropdown for the parameter you would like to drive using a slicer:
- 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 FluenceXL > 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.
