SQL slicers enable you to take data and metadata from your relational data sources (for example, SQL Server) and use it to make selections on linked reports easily.

Four display options are provided:

SQL Slicer display options

Using slicers for table parameters

To automatically add a linked slicer:

  1. Select Anaplan XL Reporting > Edit Parameters from the table's right-click menu.
  2. Select Add published slicer from the dropdown for the parameter you want to drive using a slicer.
  3. Select the query 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.
  4. Select a range to insert the Slicer.
  5. When you accept the dialog, the new Slicer will be available for input.

Standalone slicers

You can add standalone slicers using Anaplan XL > Slicer > SQL. These can be used to place their output into an Excel range or can be linked to one or more SQL data tables.