Ideally the library needs a detailing of what tables/columns/aggregation each dimension/measure map to. Then when given the list of selected ones it generates the SQL querie(s)
Asked
Active
Viewed 2,761 times
12
-
dimensions and measures of what? a pre-existing database schema? – ianpojman May 06 '12 at 05:36
-
yes a rdbms scehema, oracle in my case. – Shantaram May 06 '12 at 10:47
4 Answers
1
Probably what you need is a generic layer to access the underlying analytical database, like OLAP4J which provide API layer to the underlying analytical databases.
Daniel Baktiar
- 1,692
- 11
- 22
0
I haven't used it myself, but I've heard good things about Pentaho. Java based and open source.
John Farrelly
- 7,289
- 9
- 42
- 52
-
1actually what i am trying to build is a pentaho type Business Intelligencec tool. Instead of using the readymade deisnger and visualisations from Pentaho, i want to use my own UI layer and build a query generator below it. – Shantaram May 06 '12 at 10:50
-
I think I read the other day that you can use Pentaho as a java library you don't need to run the gui on top of it. But I've not tried myself. – Born2BeMild May 24 '12 at 08:34
0
See also this question here: Java Business Intelligence framework with ad-hoc web reporting? and the linked jasper plugin for Groovy. However, ad hoc query is very seldom and I am currently facing the same problems.
I think that Adhoc queries for BIRT and JasperSoft are offered only in the "Enterprise" (read "commercial") solution. I am trying to implement it in a way that the creater of the report can provide parameters (special marked) and that the end user can choose to include or exclude this parameters. This is not particulary "Ad hoc", but will be enough for my customers requirements.
-
There is a Community Edition of Jasper Reports Server. You can see the comparison chart at http://www.jaspersoft.com/editions. – Jacob Schoen May 30 '12 at 18:46
-
There is no longer a community edition it seems. Pity, because it looks to be pretty good! – Manish Patel Nov 15 '13 at 09:53
0
If you are looking to generate a query easily from several databases you can try Active Query Builder, it's graphic (let you drop down tables), dead simple to put in your program and is easily customizable (to some extent), this coupled perhaps with JasperReports or with a simple grid, may help you to do what you want.
Rafael
- 2,827
- 1
- 16
- 17
-
we do not want to expose the end used to sql or schema structure, but instead create a adhoc model, from which he can drag/drop objects. The based on what the user has selected, need to generate query at the back. – Shantaram May 31 '12 at 02:49