| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "SQL"
| Line 1: | Line 1: | ||
| − | SQL reporting in XLCubed is handled through Tables. | + | SQL reporting in XLCubed is handled through [[Relational Data Tables (Administrators)|Tables]] and [[Relational Slicers (Administrators)|Slicers]]. |
| − | 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. | + | 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. |
| + | # [[SQL Administrators|Administrators]]: can create new connections and design new SQL queries from scratch using the Query designer. Administrator users can also publish pre-built queries to XLCubed Web Edition, for use by standard users. | ||
| + | # [[Standard SQL Users|Standard Users]]: have no SQL designer access, but can use pre-published SQL queries from the SQL report library on XLCubed Web. | ||
| − | + | ==See Also== | |
| − | + | *[[SQL Administrators]] | |
| + | *[[Standard SQL Users]] | ||
| + | *[[Relational Data Tables (Administrators)]] | ||
| + | *[[Relational Data Tables (Standard Users)]] | ||
| + | *[[Relational Slicers (Administrators)]] | ||
| + | *[[Relational Slicers (Standard Users)]] | ||
Revision as of 15:19, 26 April 2012
SQL reporting in XLCubed is handled through Tables and Slicers.
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.
- Administrators: can create new connections and design new SQL queries from scratch using the Query designer. Administrator users can also publish pre-built queries to XLCubed Web Edition, for use by standard users.
- Standard Users: have no SQL designer access, but can use pre-published SQL queries from the SQL report library on XLCubed Web.
