View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

Reporting Server/Development Overview and Environment

Contents


The architecture of the reporting solution is shown in the slide below. 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.

The update is done through a data-loader application which is generated at deployment time from the load script definitions.

The reporting database is used within the reporting solution to create domains, ad-hoc views and reports.

Therefore when developing for the reports server the following artifacts can be identified (each corresponding to the different components in the architecture):


Openbravo Reporting Server Dev Architecture.png


The reporting database definition and load scripts are maintained with an Openbravo development environment. The domains and reports are created within the reports server and placed in repository folders in the reports server corresponding to modules. The artifacts maintained within the reports server are downloaded into the module folder so that these can also be included within a repository and deployed (uploaded).

The development and packaging of the artifacts is described in more detail in several other documents. This document focuses on setting up a development environment.

Openbravo Source & Modules

For development you need a recent (20Q1 version) Openbravo source tree/project tree. Enable it for development as you do for other developments also (set Openbravo.properties, include in Eclipse etc.).

Note: you don't need the functional modules from which the data is loaded in the reporting development environment. As long as there is a database with the functional data you are good.

The following two modules provide the integration and development tools:


Install/add these to the modules folder.

Then you will need to place your work in a module also. For this create a relevant module within the modules folder.

Two examples of modules which contain reporting artifacts are:

Do install.source or other actions to get to an operative Openbravo instance. This is the instance you will be using for developing reporting artifacts.

Openbravo Database

The previous section discussed setting up a development environment. For your reporting development you also need a database with functional data (products, tickets, pos terminals, etc.). So keep this information at hand as you need to set it in the reporting.properties property file.

Development Reports Server

For developing the reporting data warehouse and load/update scripts you do not need a running reports server. However, a next step (after the reporting tables) is to define domains and reports within the reporting server. For this development you need to have access to a running Jasper Reports Server which has access to your reporting database. So when you need to develop domains and reports make sure that you have the url and login credentials (superuser) of this reports server.

Set reporting.properties

Then go to the modules/org.openbravo.reporting.tools module folder and copy reporting.properties.template to reporting.properties

cp reporting.properties.template reporting.properties

Set the reporting properties. There are different sections each is described seperately within the property file, the following need to be set for the configuration:

Next Steps

The first next step is to create tables and materialized views and create the load scripts to load the data.

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

This page has been accessed 955 times. This page was last modified on 25 November 2020, at 10:09. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.