EclipseZone - Article: Business Intelligence and ...

The Rich Engineering Heritage Behind Dependency Injection

Andrew McVeigh takes us on a tour of the rich heritage behind dependency injection, what it represents, and tells us why its here to stay.

Java, the OLPC, and community responsibility

The "One Laptop Per Child" project has a great device ready to ship, but there's no Java on there. Let's think about working together to put Java on OLPC!

Replies: 11 - Pages: 1

Reply 1. At 10:25 PM on Jan 19, 2006, Mark N wrote:: Re: Article: Business Intelligence and Reporting Tools Project (BIRT)
I've been using BIRT for the last few months. It really is good. I've used some other Reporting Tools in the past. One of the great features of BIRT is its ability to do scriptable datasources. So, without doing a custom data source, your datasource can be pretty much anything.

We are using Hibernate Report queries to supply the data. BIRT also has the same sort of programability (mostly) as Actuate's current reporting tool. Except with BIRT you have the power of Java (via Rhino) at your disposal.
Reply 2. At 1:01 PM on Jan 23, 2006, Jonny Wray wrote:: Re: Article: Business Intelligence and Reporting Tools Project (BIRT)
FYI,

I recently came across this open source BI project that I thought people may be interested in.

http://www.pentaho.org/

They appear to be integrating tools such as BIRT, and other related projects, into a full BI solution.

Jonny; www.jonnywray.com
Reply 3. At 10:57 PM on Jan 24, 2006, Setya wrote:: Re: Article: Business Intelligence and Reporting Tools Project (BIRT)
> I've been using BIRT for the last few months. It
> really is good. I've used some other Reporting Tools
> in the past. One of the great features of BIRT is
> its ability to do scriptable datasources. So,
> without doing a custom data source, your datasource
> can be pretty much anything.
>
> We are using Hibernate Report queries to supply the
> data. BIRT also has the same sort of programability
> (mostly) as Actuate's current reporting tool. Except
> with BIRT you have the power of Java (via Rhino) at
> your disposal.

That's nice to hear, but does it support paging ?
I mean if we want to display report that comes from millions of records, does it have to query all the records at once or does it query the record lazily according to the page displayed ?
I'm talking about feature similiar to Jasperreport's JRDataSource interface.

You said you use Hibernate Report queries, is it provided by BIRT or Hibernate or your own ?

Regards,

Setya
Reply 4. At 12:32 PM on Jan 25, 2006, Mark N wrote:: Re: Article: Business Intelligence and Reporting Tools Project (BIRT)
>but does it support paging ?
I think it does this. From their web page: "The new Viewer paginates the emitted HTML following report design properties, allowing it to display pages on demand via the page controls in the Viewer navigation bar."

>You said you use Hibernate Report queries, is it provided >by BIRT or Hibernate or your own ?
Like JasperReports, you have to do this on your own. It doesn't know anything about your domain model. You can used scripted datasets, custom datasets or custom handlers.

But scripted datasets are very easy. Much easier than JasperReports. At least easier to understand - the last time I looked.
Reply 5. At 4:01 PM on Jan 25, 2006, Jonathan Fullam wrote:: Re: Article: Business Intelligence and Reporting Tools Project (BIRT)
I installed the Birt Eclipse plugin and ran through the basic tutorial. It was very straight forward and I didn't run into any major problems. My initial response it that BIRT is a powerful open source reporting tool that is easy to use and learn.
Reply 6. At 3:16 PM on Mar 15, 2006, Joshua Kafeero wrote:: Re: Article: Business Intelligence and Reporting Tools Project (BIRT)
I am having problems using Hibernate and BIRT with Scripted data sources.

The class that returns the iterator can perform a session.load and I can call a getClass().getName() on the object returned which shows it to be ca.gc.dept.Devide$$EnhancerByCGLIB$$27ae6034. I cannot however call any other methods however.

The error displayed by the birt-viewer when I call a datat retrieval method is

Script engine error: Wrapped org.hibernate.exception.GenericJDBCException: could not load an entity: [ca.gc.dept.Device#3409] (DataSet:DeviceList.open#3)

Are there any issues I should be aware of regarding CGLIB enhanced proxy classes?

Thanks.

Josh.
Reply 7. At 12:40 AM on Mar 23, 2006, Manoj Herkar wrote:: Re: Article: Business Intelligence and Reporting Tools Project (BIRT)
Sir,

This is a very good tool, but i cant configure Birt 2.0.1 with hibernate. please guide me.

Thanks.
Reply 8. At 7:57 AM on Mar 23, 2006, Scott Rosenbaum wrote:: Re: Article: Business Intelligence and Reporting Tools Project (BIRT)
John,

For full disclosure, I am on the BIRT Project Management Committee (PMC).

Thanks for creating this blog on BIRT, we really appreciate people taking the time to look at our product.

Have you considered re-visiting BIRT since our 2.0 release? 2.0 was released in late January and represents a significant upgrade to the BIRT feature list.
Reply 9. At 8:07 AM on Mar 23, 2006, Scott Rosenbaum wrote:: Re: Article: Business Intelligence and Reporting Tools Project (BIRT)
Manoj,

Jason Weathersby has a couple of examples for using Hibernate from BIRT. You can use either a scripted data set which is a sort of one off that is relatively easy or you can create a ODA which is a full extension to BIRT. The ODA extension was actually written up on Tech Forge but seems to have disappeared.

I will try and get a re-post of the article to our birt blog site at birtworld.blogspot.com
Reply 10. At 8:09 AM on Mar 23, 2006, Manoj Herkar wrote:: Re: Article: Business Intelligence and Reporting Tools Project (BIRT)
Thank i sucessfuly run it using Hibernate
Reply 11. At 4:03 AM on Mar 29, 2006, Manoj Herkar wrote:: dinamic parameter passing problem
Sir

I have a little problem while design a report using birt, i want to pass parameter as comma ceperated values. example select * from tbProduct where ProductCategory in (?) so i have to pass "1,2,4,7". so how can i pass these value to a parameter.

Thanks and regards,

manoj Herkar