A data warehouse allows users to see statistics about important business data (such as markets, customers, costs, ...) in a simple and intuitive way. A DW is similar to a collection of reports, but additionally allows the user to "play" with the data interactively, modifying the axis and parameters of the reports in real-time.
]project-open[ offers Data Warehouse implementations based on open-source (Mondrian) and commercial OLAP (MS-SQL-Server) servers.
Different situations require tailor made Data Warehouse schemes to adequately model their current conditions more appropriately and effectively. These unique variations are Data Cubes.
The data warehouse functionality is currently available in three variants:
Data Warehouse "Mondrian"
This module is suitable for small and medium companies. The implementation is based on the open-source Mondrian OLAP server, the JPivot reporting client and the OpenI solution. This implementation provides the full DW functionality, but is limited to the data handling capacity of the Mondrian server.
This implementation is based on the Microsoft SQL-Server OLAP server and the Microsoft MDAC or Excel Pivot Table reporting clients. functionality. SQL-Server is known to be able to deal with large sized DW Cubes.