From now on, the user needs to obtain information from the IT system to creating a resort for making reports from traditional databases from traditional databases.
In order to cope with the report demand in order to cope with the customer, the customer is only painful, the customer only wants what he wants to know, does not manage how complicated inquiry, optimization is how difficult is to extract the report from massive data.
In order to wait for the programmer to make a report, the customer is half a day, slow a week, things have passed. Obviously I just want to know what is as simple, the programmer has to complain how complicated inquiry, how the data structure is constrained. Sometimes a report should stay in front of the screen for half a day.
OLAP is the only way to truly let users get their own reports and do not have to pay great achievements. It allows users to freely customize their own query conditions, observe, cumulative dimensions, and finally generate it from massive data.
After several years of development, major database suppliers have their own OLAP solutions. However, we don't want to bind the product on a database, and you have no money, so you still have to seek the poor's own free and underlying database.
From the blog of Agilejava, I saw Mondrian JPivot:
Mondrian Mondean, OLAP core engine, responsible for calculating, cache data from the relational database, responding to queries from the MS home MDX syntax from the performance layer. This Microsoft's MDX syntax, learning is not difficult, SQL Server's book is also teaching.
What you want to do this is to define an SCHEMA meta model, including dimensions, hierachies, levels, and members. Mondrian wants to aggregate data respond to the Query of the MDX syntax from the relational database.
Jpivotolap JSP Custom Tag Library. Provides OLAP Navigator and multidimensional data, and support chart generation and export to excel. MONDRIAN's Royal Express Layer.
In the case of MONDRIAN with the famous Foodmart data for MS, Access is under the underlying database, JPivot makes a performance layer, let you run Example within a few minutes, feel the OLAP report. After running over, I found that it is so simple to be a customer-custom OLAP report .....
Related Articles: Poor's General OLAP Solution I - General OLAP Solution I I - Mondrian Engine Poor III - JPivot Express Layer
