SQL Slicers (Administrators)

Introduction

Relational 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:

Tree view	Combo box
Listbox	Buttons

Using Slicers for Table Parameters

To automatically add a linked Slicer:

1. Select XLCubed > Edit Parameters... from the table's right-click menu
2. Select <Add new slicer> or <Add published slicer> from the dropdown for the parameter you would like to drive using a slicer:
3. Create or select the query to use to return the ID and caption columns. The first column will be used as the parameter; the second will be displayed in the Slicer itself
4. Select a range to insert the Slicer
5. 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 relational data tables, as described above.