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

SQL

Revision as of 14:54, 26 April 2012 by Gcrawford (talk)

SQL reporting in XLCubed is handled through Tables.

There are two levels of SQL reporting user in XLCubed, with differing levels of design access. This provides a controlled level of SQL reporting to non-technical users, giving access to SQL based data without the risk of allowing free access to designing their own SQL.


1) Admin users: can create new connections and design new SQL queries from scratch using the Query designer. Admin users can also publish pre-built queries to XLCubed web, for use by standard users. 2) Standard Users: have no SQL designer access, but can use pre-published SQL queries from the SQL report library on XLCubed Web.