Olap

A couple of questions on BIRT and OLAP.
If I have an OLAP db with dimensions and everything and would like to create a report in BIRT based on a cube in the db.
1. Is this possible?
2. Can I create a dataset based on a cube in the db?
3. Do I need to use some special query? What does this look like?
4. Do I need to import some special package to be able to do queries on cubes from BIRT? Do I have to use a special JDBC-driver that supports OLAP?
5. Is there a sample or tutorial that shows how to do this in BIRT?

Thanks in advance,
Anders

Find more posts tagged with

Comments

Virgil Dodson

Hi Anders,

Open Source Eclipse BIRT can get data from JDBC, XML, Web Services, flat files, and any access through Java using the Scripted Data Source or custom Java driver. If you can get at your OLAP data using one of these ways, then BIRT can make a report from that data.

Actuate BIRT includes additional Data Sources out to SAP and Actuate Information Objects (a metadata layer above multiple data sources) which may help as well.