Anaplan XL Reporting can query relational databases directly. Like grids, ‌relational queries can be easily added to a report that can be used for interactive purposes. You can do this using SQL slicers (standard users) and dynamic Excel ranges.

Inserting an SQL data table

  1. Select the Anaplan XL > Insert Data Table > SQL from the Anaplan XL ribbon.
  2. Enter the name of the Anaplan XL website to connect to.
  3. Select the desired query and select OK to continue.
Select SQL query for a data table.
  1. If applicable, enter the parameters you wish to use.
  2. The SQL table will be inserted at the point you selected.

Using Parameters

When inserting a query, parameters will be automatically discovered by Anaplan XL and made available for editing. The parameter values can be supplied as a static value, pulled in from an Excel range, or driven by an SQL Slicer. See Using SQL Parameters for more details.