XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "SQL Data Tables (Standard Users)"

(Created page with "{{imbox|text=This page describes Relational Data Tables for Standard SQL Users. For SQL Administrators, please see Relational Data Tables (Administrators).}} XLCubed...")
 
(→‎See Also)
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
{{imbox|text=This page describes Relational Data Tables for [[Standard SQL Users]]. For [[SQL Administrators]], please see [[Relational Data Tables (Administrators)]].}}
+
{{imbox|text=This page describes SQL Data Tables for [[Standard SQL Users]]. For [[SQL Administrators]], please see [[SQL Data Tables (Administrators)]].}}
  
−
XLCubed can query your relational databases directly. Similar to [[Grids|Grids]], the relational query can be seamlessly built into an interactive report using [[Relational Slicers (Standard Users)]] and dynamic Excel ranges.
+
XLCubed can query your relational databases directly. Similar to [[Grids|Grids]], the relational query can be seamlessly built into an interactive report using [[SQL Slicers (Standard Users)]] and dynamic Excel ranges.
  
−
== Inserting a Relational Data Table ==
+
== Inserting a SQL Data Table ==
−
# Select the {{Menu|XLCubed|Insert Data Table|SQL...}} button from the XLCubed ribbon. [[File:RelationalTable0.png|300px|center]]
+
 
−
# Enter the name of the XLCubed web site to connect to: [[File:PublishedSql1.png|center]]  
+
<ol>
−
# Select the desired query and click OK to continue: [[File:PublishedSql2.png|center]]  
+
<li value="1">
−
# If applicable, enter the parameters you wish to use.
+
Select the {{Menu|XLCubed|Insert Data Table|SQL...}} button from the XLCubed ribbon.</li>
−
# The relational table will be inserted at the point you selected. [[File:RelationalTable2.png|center]]
+
 
 +
[[File:RelationalTable0.png|300px|center]]
 +
 
 +
<li value="2">Enter the name of the XLCubed web site to connect to:</li>
 +
 
 +
[[File:PublishedSql1.png|center|300px]]  
 +
 
 +
<li value="3">Select the desired query and click OK to continue:</li>
 +
 
 +
[[File:PublishedSql2.png|center|300px]]  
 +
 
 +
<li value="4">If applicable, enter the parameters you wish to use.</li>
 +
 
 +
<li value="5">The SQL table will be inserted at the point you selected.</li>
 +
 +
[[File:RelationalTable2.png|center|300px]]
 +
 
 +
</ol>
  
 
== Using Parameters ==
 
== Using Parameters ==
−
When inserting a query, parameters will be automatically discovered by XLCubed 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 [[Relational Slicers|Relational Slicer]].
+
When inserting a query, parameters will be automatically discovered by XLCubed 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 Slicers (Standard Users)|SQL Slicer]]. See [[Using SQL Parameters]] for more details.
  
 
== See Also ==
 
== See Also ==
−
* [[Relational Data Tables (Administrators)]]
+
* [[SQL Data Tables (Administrators)]]
−
* [[Relational Slicers (Standard Users)]]
+
* [[SQL Slicers (Standard Users)]]
 +
* [[Driving a SQL Connection from an Excel range]]
 
* [[Query Tables]] for a similar feature in XLCubed 6.5 and previous versions.
 
* [[Query Tables]] for a similar feature in XLCubed 6.5 and previous versions.
−
 
+
* [[Tables]]
 
[[Category:Relational Reporting]]
 
[[Category:Relational Reporting]]
 +
[[Category:SQL Getting Started]]

Latest revision as of 16:15, 2 April 2014

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

XLCubed 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 XLCubed > Insert Data Table > SQL... button from the XLCubed ribbon.
    2. RelationalTable0.png
  2. Enter the name of the XLCubed 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 XLCubed 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.xlcubed.com/index.php?title=SQL_Data_Tables_(Standard_Users)&oldid=851’