BI View Editor is a tool integrated in Odoo that allows users define and execute their own reports without the need to code.
Purpose:
- The BI View Editor is used to create reports not already contained in the standard Odoo, combining data from existing sources.
- It has been designed to be used by users with little or no knowledge of the technical architecture of Odoo. Users visually link business objects and select the fields to visualize.
- The BI View Editor offers users different types of representations, including tree, graph, pivot views.
auto_awesome What this module does
AI-generated from the code · Odoo 17.0Lets users build their own reports by visually picking Odoo models and fields, then generating a real report with list, graph and pivot views plus a menu entry, without writing code.
The BI View Editor lets a user create a custom report from existing Odoo data without programming. In the form, a visual query builder shows available models and fields; the user links business objects together and ticks which fields to show, which are rows, columns or measures, and which appear in the list.
When the user clicks "Generate BI View", the module builds a database view, creates a new report model, and automatically generates list, graph, pivot and search views plus a window action. The "Open BI View" button then opens the finished report. A "Create a Menu" button adds the report to the "Custom BI Views" menu so other users can reach it.
Business rules and automatic behaviours: - Names must be unique; copying a view adds "(copy)". - Fields cannot be duplicated, and only numeric fields can be measures; relational or numeric fields cannot be rows or columns. - Abstract models and inconsistent links are refused, and missing models or fields (e.g. after uninstalling a module) block generation. - If user groups are chosen, the module checks those groups can actually read every source model, and grants read access on the new report to those groups (or to everyone if none are chosen). - A "Reset to Draft" button removes the generated views, action and model; a created view cannot be deleted until reset.
An ER Diagram tab shows a picture of the selected tables and links. A SQL tab (technical users only) shows the generated query and an optional ordering condition. A Security tab limits who sees the report, and a Notes tab stores free text.
Depends on
Required by other modules
Menus it adds
Models and fields (4)
- bve.view · new modeldata, name, note (Notes), query, state, view_id (View), line_ids (Lines), user_ids (Users), action_id (Action), field_ids (Fields), group_ids (Groups), model_name, relation_ids (Relations), over_condition, er_diagram_image
- ir.model · extends an existing model
- bve.view.line · new modelrow, name, ttype (Type), column, in_list, measure, field_id, model_id, relation, sequence, join_node, left_join, list_attr (List Attribute), field_name, model_name (Model Name), bve_view_id, description, table_alias, join_model_id, view_field_type
- wizard.ir.model.menu.create · extends an existing model
Text generated by AI (DeepSeek) from reading the Odoo 17.0 code on GitHub; it may contain mistakes, so check the code before deciding. The module is very large and only part of the code was read. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 5 confirmed, 4 with no information of 9 versions.
Sources · Odoo 16.0
Confirmed on 2026-11-03 in branch 16.0 of OCA/reporting-engine.
terminal Installation and usage
OCA documentation · Odoo 17.0Installation
Source · Odoo 17.0In the Odoo configuration file add bi_view_editor in the list server_wide_modules:
[options]
(...)
server_wide_modules = web,bi_view_editor
(...)Alternatively specify --load=bi_view_editor when starting Odoo by command line.
Optionally it is possible to enable the view of the ER Diagram. For this you need to install Graphviz, an open source graph visualization software:
``sudo apt-get install graphviz``Usage
Source · Odoo 17.0To graphically design your analysis data-set:
- From the Dashboards menu, select "Custom BI Views"
- BI Views creation is restricted to members of "BI View Editor Manager" group. You can add this group to a user in User form, Access Rights, Technical section.
- Browse trough the business objects in the "Query Builder" tab
- Pick the interesting fields (Drag & Drop)
- For each selected field, right-click on the Options column and select whether it's a row, column or measure; if you want to remove the field from the list view, unflag the checkbox ´List´ in the Options column
- Save and click "Generate BI View"
- Click "Open BI View" to view the result
To access the created BI View with a dedicated menu:
- If module Dashboard (board) is installed, the standard "Add to My Dashboard" functionality would be available
- "Create a menu" is restricted to members of "BI View Editor Manager" group.
- Click "Create a menu" to create a new menu item directly linked to your new BI view (this feature is available in developer mode); when the BI view is reset back to draft this menu will be removed, and you will need to re-create the menu entry.
A more advanced UI is also available under the "Details" tab. It provides extra possibilities for more advanced users, like to use LEFT JOIN instead of the default INNER JOIN.
It also possible to improve the IDs generation for new views by adding an Over Condition in the "SQL" tab, see
for further details. For instance, an ORDER BY clause helps preventing unreliable behavior when filtering the generated views.
No verified information in OCA: Configuration.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.