SQL Data Tables (Standard Users)

This page describes SQL Data Tables for Standard SQL Users. For SQL Administrators, please see SQL Data Tables (Administrators).

FluenceXL can query your relational databases directly. Similar to Grids, the relational query can be seamlessly built into an interactive report using SQL Slicers (Standard Users) and dynamic Excel ranges.

Inserting a SQL Data Table

  1. Select the FluenceXL > Insert Data Table > SQL... button from the FluenceXL ribbon.
    2. RelationalTable0.png
  2. Enter the name of the FluenceXL web site to connect to:
    3. PublishedSql1.png
  3. Select the desired query and click OK to continue:
    4. PublishedSql2.png
  4. If applicable, enter the parameters you wish to use.
  5. The SQL table will be inserted at the point you selected.
    6. RelationalTable2.png

Using Parameters

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

See Also

Retrieved from ‘https://help.fluencexl.com/index.php?title=SQL_Data_Tables_(Standard_Users)&oldid=11407’