View source | Discuss this page | Page history | Printable version   

Reporting Server

Contents


Bulbgraph.png   This solution is available in RR20Q1.

Openbravo Reports Server is a feature rich and performant reporting solution based on Jaspersoft Reports Server.

The Openbravo Reports Server gives you the following main functionalities:

Openbravo Reports Server is deployed on its own server with its own dedicated data warehouse database. The data warehouse is updated periodically (daily or more frequently) from the Openbravo transactional database using specific ETL/ELT like scripts. The separate datawarehouse allows us to prepare the data so that reports are fast and data and dimensions are ready to be used in drag-and-drop report creation.


Openbravo Reporting Server Architecture.png


Reports Server User Tutorials

Jaspersoft provides extensive documentation and tutorials on the web to help you get familiar with the user interface and functionality of Jaspersoft Reports Server.

For your convenience we have gathered some of the tutorials here. These tutorials are all short (<7 mins) videos and discuss the features from an (power-)user or consultant perspective.

To start of, this video provides a general overview of Jaspersoft Reports Server.

Then after that checkout the following tutorials providing some more details:

More details can be found in the Jasper Reports Server User Guide.

Retail Reports & Datawarehouse

In subsequent releases in 2020 we have made available both an extensive set of domains and sample standard reports for you to use and adapt to your specific needs.

Next to direct sales domains on sales order header and lines we also deliver domains specifically for discounts, cashup, payments, tax, returns, gift cards and coupons. The domains allow aggregation along a set of common dimensions and hierarchies. The domains allow you to easily create ad-hoc views and reports. They also provide a good base for custom data loading and reports.

The following document gives an overview of the available domains.

Using our domains we have delivered a first set of sample standard reports giving an overview of what is possible. These reports and dashboards are a starting point for you to change and extend using the domains.

Reports Server Openbravo Integration

The Openbravo backoffice is integrated with the Jasper Reports Server in various ways: automatic and transparent login using single sign on, opening reports directly from the Openbravo backoffice and report bursting.

To learn how to provision reports through the backoffice or webpos please follow this howto.

Reports Server Repository Structure

When creating new reports and other contents within the reports server we expect and assume a specific repository structure. This repository structure is used to support modularity and also makes sure that developers and consultants know where to find and place specific artifacts so that they can be exported correctly to modules.

The details of the Jasper Reports Server Repository structure are described in this document.

Development Guide

The Openbravo Reporting Server makes use of Openbravo modularity to organize and package report artifacts. Our approach allows you to extend the datawarehouse model while other artifacts can be copied for customization.

Openbravo Reporting Development Resources

The development guide describes the whole range of development activities from creating and extending the data warehouse model, implementing ETL/ELT data load scripts using SQL and adapt the domain definition with translation and security setup correctly.

Howto and other documentation:

Jaspersoft Report Server Development Resources

Here are links to other JasperSoft server documentation relevant for developers:

Reports Server Setup, Configuration, Deployment, Runtime

The specific system level configuration of the Reports Server is discussed in this document. It provides steps to deploy the reports server using our configuration modules.

For other details regarding server administration check out the Jasper Reports Server Administrator Guide.

The runtime topics page provides information on what to check when running the data loader application in production.

JasperReports Server Documentation

For detailed documentation on Jaspersoft visit the documentation page. Openbravo uses the 7.5.0 version.

Retrieved from "http://wiki.openbravo.com/wiki/Reporting_Server"

This page has been accessed 25,555 times. This page was last modified on 23 March 2023, at 18:17. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.