Query tables enable you to combine data from two or more tables to create a new table. You can create a query table using any of the following SQL dialects: Oracle, SQL Server, IBM DB2, MySQL, Sybase, Informix, PostgreSQL, and ANSI SQL.
Follow the steps below to create a new query table.
Click the + Create button on the side panel and select Query Table.
In the page that appears, enter the required SQL query to create a new query table.
Insert Columns: This tab lists all the available tables and columns in the workspace. You can choose to enter the column names in the editor window, or select the required ones from the Insert Columns section.
Insert SQL Functions: This tab lists the in-built SQL functions that can be added to your SQL query. Analytics Plus supports Logical, Aggregate, Tabular, String, Mathematical, Date, Duration and Business functions.
Click Execute Query. The resulting table will be displayed in the Expected Result tab. Click Save to save your query table.
To edit a query table, follow the steps below:
Open the required query table in Edit Design mode.
Make the required changes in the SQL query, and click Save.
Note: You cannot edit columns that are used in generating a report in the workspace.
Query tables are not a form of reports. They are a form of tables that can be used to create required reports.
Analytics Plus allows you to include the result of one query table in another query table, but you cannot add nested queries. As a rule of thumb, limit such operations to three queries (levels). When nesting goes beyond the third level, loading reports created using nested tables takes a longer time and affects application performance.
To create and optimize your query tables, write to us at firstname.lastname@example.org.