Difference between revisions of "Publishing SQL Queries"

(Created page with "Relational queries designed as described in this article can be published for reuse by all users. To do this: # When you are satisfied with y...")
 
m (Text replacement - "XLCubed" to "FluenceXL")
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
Relational queries designed as described [[SQL Data Tables (Administrators)|in this article]] can be published for reuse by all users. To do this:
 
Relational queries designed as described [[SQL Data Tables (Administrators)|in this article]] can be published for reuse by all users. To do this:
 
# When you are satisfied with your query, click the {{Menu|Publish Query}} toolbar button at the top of the designer ([[File:PublishQuery.png]])
 
# When you are satisfied with your query, click the {{Menu|Publish Query}} toolbar button at the top of the designer ([[File:PublishQuery.png]])
# Type the address of the [[Web Edition|XLCubed Web Edition]] site and click the {{Menu|Connect}} button
+
# Type the address of the [[Web Edition|FluenceXL Web Edition]] site and click the {{Menu|Connect}} button
 
# Select a folder to publish the query to, give it a name and optionally a more verbose description
 
# Select a folder to publish the query to, give it a name and optionally a more verbose description
 
# Click {{Menu|OK}} to publish the query
 
# Click {{Menu|OK}} to publish the query
 +
 +
Alternatively, select the {{Menu|FluenceXL|Web|Publish to Web|Publish SQL Query...}} ribbon item or the {{Menu|FluenceXL|Publish SQL Query...}} menu item in Excel 2003 and lower, and select the item you would like to publish.
  
 
The query will now be available to both [[SQL Administrators]] and [[Standard SQL Users]], for data tables and [[SQL Slicers|Slicers]]. Standard users will not be able to edit the query, but will be able to edit any parameters defined when it was published.
 
The query will now be available to both [[SQL Administrators]] and [[Standard SQL Users]], for data tables and [[SQL Slicers|Slicers]]. Standard users will not be able to edit the query, but will be able to edit any parameters defined when it was published.
  
 
To quickly insert a new data table based on the query:
 
To quickly insert a new data table based on the query:
# Select the {{Menu|XLCubed|Favourites|Published SQL Queries...}} button from the XLCubed ribbon
+
# Select the {{Menu|FluenceXL|Favourites|Published SQL Queries...}} button from the FluenceXL ribbon
# Type the address of the [[Web Edition|XLCubed Web Edition]] site and click the {{Menu|Connect}} button
+
# Type the address of the [[Web Edition|FluenceXL Web Edition]] site and click the {{Menu|Connect}} button
 
# Select the desired query
 
# Select the desired query
 
# Click {{Menu|OK}} to insert the table
 
# Click {{Menu|OK}} to insert the table
  
 
<noinclude>==See Also==
 
<noinclude>==See Also==
* [[SQL Data Tables (Administrators)]]</noinclude>
+
* [[SQL Data Tables (Administrators)]]
 +
 
 +
[[Category:Relational Reporting]]</noinclude>

Latest revision as of 09:31, 4 July 2023

Relational queries designed as described in this article can be published for reuse by all users. To do this:

  1. When you are satisfied with your query, click the Publish Query toolbar button at the top of the designer (PublishQuery.png)
  2. Type the address of the FluenceXL Web Edition site and click the Connect button
  3. Select a folder to publish the query to, give it a name and optionally a more verbose description
  4. Click OK to publish the query

Alternatively, select the FluenceXL > Web > Publish to Web > Publish SQL Query... ribbon item or the FluenceXL > Publish SQL Query... menu item in Excel 2003 and lower, and select the item you would like to publish.

The query will now be available to both SQL Administrators and Standard SQL Users, for data tables and Slicers. Standard users will not be able to edit the query, but will be able to edit any parameters defined when it was published.

To quickly insert a new data table based on the query:

  1. Select the FluenceXL > Favourites > Published SQL Queries... button from the FluenceXL ribbon
  2. Type the address of the FluenceXL Web Edition site and click the Connect button
  3. Select the desired query
  4. Click OK to insert the table

See Also