Jump to content
Changes to the Jaspersoft community edition download ×

how does Jasper OLAP work?


dprogrammer

Recommended Posts

I am a report developer and our company wants to implement an OLAP solution using Jasper OLAP Server or JasperServer for their web application. I am new to this OLAP technology but very good at creating reports in Jasper and other tools. Can anybody guide me as to what programs/servers/dbs etc I need to install to get all OLAP work for our website? Do the reports need to be built by keeping OLAP in mind? Thanks in advance.
Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Hi Dreporter!!

 

As youve said that you are familiar with Jasper reports and wish to use OLAP reports you need to know few things

1. Mondrian is the OLAP engine

2. you can create connection to Mondrian OLAP thorugh jdbc or XMLA.

 

later can write queries (SQL and MDX)for your reports to access your OLAP Cube.

OLAP Cube is in XML format which contains the description of your star schema, dimensions and messures along with aggregates and calculated measures.

 

Your query hits the OLAP engine with has the definition to your OLAP data that helps to pull the information.

 

Hope this helps a bit.

Cheers!!

sure

Link to comment
Share on other sites

Thanks Sure919 and Warwithin. Can you guys also help me understand how this is going to be embeded in our web app?

Currently we have a web app and there is a reports module that allows us to run dyanamic jasper reports. How does OLAP fit in it? I downloaded Mondrian OLAP designer. If I design an OLAP report in it, how can I link it back to my jasper report? Little confused so I would really appreciate if you guys can explain it to me. Thanks.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...