Reports Framework
Get flash to fully experience Pearltrees
French documentation
Entity–attribute–value model ( EAV ) is a data model to describe entities where the number of attributes (properties, parameters) that can be used to describe them is potentially vast, but the number that will actually apply to a given entity is relatively modest. In mathematics, this model is known as a sparse matrix . EAV is also known as object–attribute–value model , vertical database model and open schema .
Entity–attribute–value model
JasperReports
JasperReports is an open source Java reporting tool that can write to a variety of targets, such as: screen, a printer, into PDF , HTML , Microsoft Excel , RTF , ODT , Comma-separated values or XML files. It can be used in Java-enabled applications, including Java EE or web applications , to generate dynamic content. It reads its instructions from an XML or .jasper file.
DSPL stands for Dataset Publishing Language.
DSPL Tutorial - DSPL: Dataset Publishing Language - Google Code
03. Hello World Example - Pentaho Wiki
Although this will be a simple example, it will introduce you to some of the fundamentals of PDI:
When doing ETL work every now and then the exact SQL query you want to execute depends on some input parameters determined at runtime. This requirement comes up most frequently when SELECTing data.
Dynamic SQL Queries in PDI a.k.a. Kettle | Adventures with Open Source BI
Slowly changing dimension
Dimension is a term in data management and data warehousing . It's the logical groupings of data such as geographical location, customer or product information. With Slowly Changing Dimensions (SCDs) data changes slowly, rather than changing on a time-based, regular schedule. [ 1 ]
ETL Process
The ETL (Extract, Transform, Load) process is comprised of several steps and its architecture depends on the specific data warehouse system. In this post, an outline of the process will be given along with choices that are/could be used for OpenMRS.
Why would we want to build a data warehouse system?
Another approach for reporting: A Data Warehouse System
DW Data Model
This post is going to describe the data model for the OpenMRS data warehouse. It will be edited frequently to add documentation for the model and to modify it. Star SchemasYou can create three different types of reports: a Period Indicator Report, a Row-Per-Patient Report, or a Custom Report (Advanced).