Difference between revisions of "SQL"
(→See Also) |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| Line 1: | Line 1: | ||
| − | Relational reporting in | + | Relational reporting in FluenceXL is handled through [[SQL Data Tables (Administrators)|Tables]] and [[SQL Slicers (Administrators)|Slicers]]. |
| − | There are two levels of SQL reporting user in | + | There are two levels of SQL reporting user in FluenceXL, 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 queries. |
| − | # [[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 | + | # [[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 FluenceXL 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 | + | # [[Standard SQL Users|Standard Users]]: have no SQL designer access, but can use pre-published SQL queries from the SQL report library on FluenceXL Web. |
==See Also== | ==See Also== | ||
Latest revision as of 09:32, 4 July 2023
Relational reporting in FluenceXL is handled through Tables and Slicers.
There are two levels of SQL reporting user in FluenceXL, 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 queries.
- 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 FluenceXL 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 FluenceXL Web.
