Jasper server can create OLAP view with easy way .
Jaspersoft OLAP is a powerful data analysis engine for analyzing large data sets and performing complex queries. Business users can interact with their data through a unified web-based or Excel interface.
See more detail in : http://www.jaspersoft.com/jaspersoft-olap