| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "SQL"
(Created page with "SQL Homepage") |
|||
| Line 1: | Line 1: | ||
| − | SQL | + | 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. | ||
Revision as of 14:54, 26 April 2012
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.
