SQL

Revision as of 13:34, 1 May 2012 by NMaudgil (talk) (See Also)

Relational 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 queries.

  1. 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.
  2. Standard Users: have no SQL designer access, but can use pre-published SQL queries from the SQL report library on XLCubed Web.

See Also