<a class="reference external image-reference" href="http://www.gnu.org/licenses/agpl-3.0-standalone.html"><img alt="License: AGPL-3" src="https://img.shields.io/badge/licence-AGPL--3-blue.svg"> </a> <a name="bi-view-editor"></a> <h2>BI View Editor</h2> <p>BI View Editor is a tool integrated in Odoo that allows users define and execute their own reports without the need to code.</p> <p>Purpose:</p> <ul class="simple"> <li>The BI View Editor is used to create reports not already contained in the standard Odoo, combining data from existing sources.</li> <li>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.</li> <li>The BI View Editor offers users different types of representations, including tree, graph, pivot views.</li> </ul> <a name="usage"></a> <h3>Usage</h3> <p>To graphically design your analysis data-set:</p> <ul class="simple"> <li>From the Dashboards menu, select &quot;Custom BI Views&quot;</li> <li>Browse through the business objects in the Query tab, double click the business object(model) to show the fields under it</li> <li>Pick the interesting fields (Drag &amp; Drop)</li> <li>For each selected field, right-click on the Options column and select whether it's a row, column or measure</li> <li>Save and click &quot;Generate BI View&quot;</li> <li>Open the newly created Custom BI views in form view mode, there will be a new Open BI View button, click this button lauch this new report</li> <li>if need to change the view definition, first click the Reset to Draft button, then click Edit.</li> </ul> <a class="reference external image-reference" href="https://runbot.odoo-community.org/runbot/143/9.0"><img alt="Try me on Runbot" src="https://odoo-community.org/website/image/ir.attachment/5784_f2813bd/datas" /></a> <a name="known-issues-roadmap"></a> <h3>Known issues / Roadmap</h3> <ul class="simple"> <li>Non-stored fields are not supported</li> <li>Provide graph view for table relations</li> <li>Extend the capabilities of the tree views (e.g. add sums)</li> <li>Add possibility to store the BI view in user dashboard, like any other graph or cross table</li> <li>Provide a tutorial (eg. a working example of usage)</li> </ul> <a name="credits"></a> <h3>Credits</h3> <a name="images"></a> <h4>Images</h4> <ul class="simple"> <li>Odoo Community Association: <a class="reference external" href="https://github.com/OCA/maintainer-tools/blob/master/template/module/static/description/icon.svg">Icon</a>.</li> </ul> <a name="contributors"></a> <h4>Contributors</h4> <ul class="simple"> <li>Simon Janssens &lt;<a class="reference external" href="mailto:s.janssens&#64;onestein.nl">s.janssens&#64;onestein.nl</a>&gt;</li> <li>Diego Luis Neto &lt;<a class="reference external" href="mailto:diegoluis.neto&#64;gmail.com">diegoluis.neto&#64;gmail.com</a>&gt;</li> <li>Dennis Sluijk &lt;<a class="reference external" href="mailto:d.sluijk&#64;onestein.nl">d.sluijk&#64;onestein.nl</a>&gt;</li> <li>Kevin Graveman &lt;<a class="reference external" href="mailto:k.graveman&#64;onestein.nl">k.graveman&#64;onestein.nl</a>&gt;</li> <li>Richard Dijkstra &lt;<a class="reference external" href="mailto:r.dijkstra&#64;onestein.nl">r.dijkstra&#64;onestein.nl</a>&gt;</li> <li>Andrea Stirpe &lt;<a class="reference external" href="mailto:a.stirpe&#64;onestein.nl">a.stirpe&#64;onestein.nl</a>&gt;</li> <li>Antonio Esposito &lt;<a class="reference external" href="mailto:a.esposito&#64;onestein.nl">a.esposito&#64;onestein.nl</a>&gt;</li> <li>Jordi Ballester Alomar &lt;<a class="reference external" href="mailto:jordi.ballester&#64;eficent.com">jordi.ballester&#64;eficent.com</a>&gt;</li> <li>Fisher Yu <a class="reference external" href="mailto:yuxinyong&#64;163.com">yuxinyong&#64;163.com</a> (migrate to 10.0, support duplicate)</li> </ul> <a name="maintainer"></a> <h4>Maintainer</h4> <a class="reference external image-reference" href="https://odoo-community.org"><img alt="Odoo Community Association" src="https://odoo-community.org/logo.png" /></a> <p>This module is maintained by the OCA.</p> <p>OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.</p> <p>To contribute to this module, please visit <a class="reference external" href="https://odoo-community.org">https://odoo-community.org</a>.</p>