Skip to content
A product by MAINSYSTEMS
Request a demo
Open menu

QUERIES

The widget receives the result. The query stays on the server.

The builder combines tables, dimensions, measures, joins and filters. The browser receives only result columns — never table names, SQL or the query definition.

EXECUTIONOn the server
ACCESSRead-only (SELECT)
RESULTUp to 5,000 rows per page
Query builder with related tables
QUERY BUILDER · THREE CONNECTED TABLES
Query applied to a dashboardQUERY BUILDER · THREE CONNECTED TABLES

INSIDE THE PRODUCT

The interface changes with the job.

Name the dataset

Each widget reads a named dataset. That name identifies the result and lets another widget reuse it.

Model the question

Choose tables, establish joins and define dimensions, measures and conditions.

Apply values

Dashboard filters, parameters and selections enter as values. Only dependent queries rerun.

Deliver the result

The server reads the authoritative definition, applies values and returns the resulting columns.

NEXT · DASHBOARDS

Turn the result into a usable screen.

Continue