Skip to main content

Query Library

The Query Library provides a central repository of approved and reusable queries within CryspIQ®.

Rather than creating reports or asking the same questions repeatedly, users can execute pre-built queries that have already been validated and approved by the organisation.

This ensures:

  • Consistent reporting
  • Common business definitions
  • Trusted results
  • Faster access to information
  • Reduced duplication of effort

The Query Library is designed for both business and technical users.

Overview​

Many organisations experience challenges where different teams create their own reports and calculations.

This often results in:

  • Multiple versions of the truth
  • Conflicting KPI definitions
  • Duplicate reports
  • Inconsistent decision-making

The Query Library addresses this by providing a governed collection of approved queries.

Approved Query
       ↓
Query Library
       ↓
Execute Query
       ↓
Trusted Results
       ↓
Consistent Decisions

Users can simply select and run a query without needing to understand SQL or database structures.

Who Uses the Query Library?​

Business Users​

Business users can:

  • Browse available queries
  • Run approved queries
  • Review results
  • Export results
  • Re-use trusted organisational reports

No SQL knowledge is required.

Data Administrators​

In addition to running queries, Data Administrators can:

  • Create new queries
  • Edit existing queries
  • Retire obsolete queries
  • Validate query logic
  • Manage query ownership

Data Administrators help ensure the library remains accurate, governed and aligned to organisational standards.

Query Library Screen​

The Query Library provides a searchable catalogue of reusable queries.

Users can view:

  • Query Name
  • Description
  • Business Function
  • Owner
  • Last Updated Date
  • Query Category

This makes it easy to locate the information required.

Running a Query​

Running a query is straightforward.

Step 1 – Open Query Library​

Navigate to:

Consume → Query Library

Step 2 – Search or Browse​

Locate the required query.

Examples:

Monthly Revenue Summary

Customer Profitability

Sales by Region

Employee Headcount

Operational KPI Dashboard

Step 3 – Review Description​

Review the query description to ensure it meets your requirements.

Typical descriptions explain:

  • Purpose of the query
  • Business definitions used
  • Data sources involved
  • Intended audience

Step 4 – Execute Query​

Select Run Query.

CryspIQ® executes the query against the Enterprise Data Model and returns the results.

Step 5 – Review Results​

Results may be displayed as:

  • Tables
  • Summaries
  • Aggregations
  • KPI metrics

Users can then:

  • Export results
  • Share insights
  • Use results in decision-making

Security and Data Access​

All CryspIQ® security rules continue to apply when running queries.

Users only see data they are authorised to access.

Access is controlled through Microsoft Entra Security Groups.

Important​

Even when running a shared query:

  • Security is automatically enforced.
  • Restricted records remain hidden.
  • Users only see data they are permitted to access.

This ensures sensitive information remains protected.

Building New Queries​

Data Administrators can create new queries for organisational use.

Queries can be created using:

SQL Query Tool​

CryspIQ® includes an online SQL query editor that allows Data Administrators to:

  • Write SQL queries
  • Test results
  • Validate logic
  • Save approved queries

External Query Tools​

Queries can also be developed using external tools such as:

  • SQL Server Management Studio (SSMS)
  • Azure Data Studio
  • Visual Studio
  • Other approved SQL development tools

Once validated, queries can be imported into the Query Library.

Natural Language Generated SQL​

One of the most powerful ways to build new queries is through the Questions feature.

Users can:

  1. Ask a question in everyday language.
  2. Review the generated SQL.
  3. Validate the results.
  4. Save the SQL into the Query Library.

Example:

Question:
What was total revenue by region last quarter?

CryspIQ® generates SQL automatically.

The Data Administrator can then:

  • Review the SQL
  • Optimise if required
  • Save it into the Query Library

This significantly accelerates query development.

Why Use the Query Library?​

The Query Library helps organisations standardise reporting.

Instead of multiple teams creating their own versions of the same report:

Finance Revenue Report

Sales Revenue Report

Executive Revenue Report

A single approved query can be used across the organisation.

Benefits include:

  • One definition
  • One calculation method
  • One trusted result

Query Categories​

Queries can be organised into categories such as:

Finance​

Examples:

Revenue Analysis

Profitability

Budget Variance

Accounts Receivable

Human Resources​

Examples:

Employee Headcount

Staff Turnover

Workforce Analysis

Operations​

Examples:

Asset Utilisation

Service Performance

Production Metrics

Executive Reporting​

Examples:

Board Reporting

Enterprise KPIs

Performance Dashboards

Exporting Results​

Query results can be exported for further analysis.

Supported export formats may include:

  • CSV
  • Excel
  • Power BI
  • Reporting tools

This enables users to perform additional analysis where required.

Best Practices​

Business Users​

  • Use approved queries wherever possible.
  • Review query descriptions before execution.
  • Confirm the results meet your requirements.

Data Administrators​

  • Avoid duplicate queries.
  • Re-use existing queries where possible.
  • Validate business definitions before publishing.
  • Keep descriptions current and meaningful.

Organisation-Wide​

  • Use shared queries for KPI reporting.
  • Standardise business definitions.
  • Retire obsolete queries regularly.

Common Questions​

Do I need SQL knowledge?​

No.

Business users can simply select and execute approved queries.

Can I save queries?​

Yes.

Data Administrators can save and manage reusable queries within the library.

Can I create my own queries?​

Yes.

Data Administrators can create and manage queries using:

  • CryspIQ® SQL tools
  • External SQL tools
  • Natural Language generated SQL

Why are Query Library results different from another report?​

The Query Library should be considered the trusted organisational source.

Any differences should be investigated and reconciled.

Benefits of the Query Library​

The Query Library helps organisations:

  • Standardise reporting
  • Improve consistency
  • Reduce duplicate effort
  • Accelerate analysis
  • Re-use organisational knowledge
  • Improve trust in reporting
  • Support governance initiatives

Most importantly, it ensures everyone is working from the same definitions and trusted enterprise data.

Next Steps​

  1. Browse the Query Library.
  2. Execute approved queries.
  3. Review and export results.
  4. Re-use trusted organisational reports.
  5. Save valuable Natural Language queries for future use.
  6. Promote standardised reporting across the organisation.

The Query Library provides a governed collection of trusted queries that help organisations make decisions using consistent, reliable and transparent enterprise data.