Odoo
Cyllo

BI SQL Editor

This module extends Cyllo's reporting functionality by allowing users, primarily administrators, to create custom reports through SQL queries.

BI SQL Editor elevates Cyllo's reporting capabilities by enabling the creation of custom reports via user-written SQL queries. Admin users can craft their desired SQL query, map the retrieved data fields to corresponding Cyllo fields, and ultimately generate a new menu item, action, and graph view for the report.

Technically, the module creates an SQL View (or a materialized view for faster performance with larger datasets, which requires a cron job for data refreshes). By default, the "SQL Request / User" group can access all views, but you can specify additional groups for granular access control.

This module is designed for individuals with technical expertise within a company and for Cyllo integrators, as it requires a strong understanding of SQL syntax and familiarity with Cyllo models. Due to its technical complexity, it is not recommended for users lacking these skills, especially in a production environment.

Key Features

  • Custom report creation via SQL queries
  • Support for SQL Views and materialized views
  • Access control for user groups
  • Automated UI Creation
Custom Report Creation

Generate tailored reports via SQL queries to meet specific analysis needs, including technical requests not supported by the Cyllo framework (e.g., UNION with multiple SELECT statements).

Enhanced Reporting Options

Create new menu options, actions, and graph views for improved data visualization, enabling customization of Cyllo reports by adding or removing fields as necessary.

Materialized View Support

Address performance issues with large datasets by utilizing materialized views, reducing display duration and enhancing overall query performance.

Access Control

Configure permissions for user groups to access and interact with reports, ensuring data security and confidentiality.

Disabled tab content