Cross Tab Reports Deployed

I have been using Pentaho, and started working with BIRT today. I have created a cross tab report that works fine on my local installation; however, I get a Cube Doesn't Exist error when I run the report in a report engine deployment in Tomcat. I get the parameter page, but the Crosstab does not work.

I have Tomcat 5.5 and BIRT 2.3. I do not see any information on some type of cube definition (like a mondrian XML definition). There is a reference to /olap/cube_WGD Cube but I have no idea where this /olap directory is supposed to be or what is supposed to be in it. There are a couple of other posts with this type of error, but there have not been any posts as follow up suggestions.

Your help is greatly appreciated.

Bill W.

Find more posts tagged with

Comments

Rima

Hi,

Do your other reports design using the same data set ( data source ) work fine in tomcat deployment. I would suggest you to try deploying a simple table report against the same data set and verify if it works in tomcat 5

--Rima

billw

I got it working. I found that the driver that I had loaded was not untarred. So, I untarred, moved the .jar to appropriate directory and got it working.

My new problem is the amount of data that can be displayed. I am trying to plot energy consumption by minute for a day. If I average over an hour, it is fine. I have seen several posts that BIRT does not do well with charts and big data.

I may get around it by using artful use of drill down, but I would rather see a full day's data. Oh well, this issue is for another forum.

Bill

Virgil Dodson

Hi Bill,

The BIRT charts can have grouping applied so you can group by interval like minute and this would produce 1440 data points for a day which is not a lot of data for a BIRT chart.