akrause

tkavanagh Wrote: Are you comparing the Pro Suites of JasperServer and Pentaho? Or the CE versions of the products? For the Community Edition, JasperServer has JasperReports fully integrated, which is the most widely deployed Open Source reporting solution. Meanwhile, Pentaho is using JFreeReports which is less feature rich. On the Pro side the Ad Hoc Reporting and Domain (Business Semantic Layer) are a couple of features that our Pro customers really like. Also, there is the SaaS enablement functionality for Pro which just came out in our new 3.5 release. This allows administering mulitiple independent organizations on a single JasperServer instance. I am comparing the CE versions. Ok, JasperReports vs. JFreeReports was something i was thinking about for our descision which suite would be the better one for us. But what can jasperReports do that we can't do with JFreeReports? The report examples in Pentaho look like as one can create very flexible feature-rich reports with JFreeReports too. Adhoc Reporting is included in Pentaho CE already, for Jaspersoft you need the Pro edition to evaluate this feature. Domains and SaaS is nothing we really need, but AFAIK Pentaho is cloud-ready too in the meanwhile?

Thanks for your reply, really appreciated! But i headed over to Pentaho already, mainly because the architecture of their suite fits better to our needs. The main aspects for our "descision in a nutshell": - process oriented approach (workflows!) - solution oriented approach (workflows!) Don't know if Jasper suite could be enhanced with workflow capabilities too. I asked for it here in the forums, but again: No answers! Post Edited by akrause at 06/27/2009 08:53

If your base tables does contain all the information needed to fill the data cube then you don't have to create a datamart necessarily. But operational databases are optimized for performance and so the database tables aren't usually suitable for OLAP analysis and so the data has to be extracted, transformed and loaded into datawarehouses or datamarts. And it's a performance issue here too: access to datamarts are usually more performant than accessing the operational databases directly, because their structure is optimized for analysis tasks and the operational database is balanced this way also. Cheers...

Hi, fact tables are the core of datamarts and contain all valuable data to fill an analysis cube. In the first step this data is collected via ETL in datawarehouses from different datasources and put together in a second step from here to the datamart's fact and dimension tables (of course you can fill your datamarts directly too depending on what you are planning to do, data quantity, and so on) . The dimension tables data and fact tables data are used to build the cube for your OLAP analysis. Hope this helped a bit....

Hi all, i am evaluating open source BI suites at the moment to see which suite would fit best for the most reporting and analysis needs of our customers. Jaspersoft and Pentaho are hot candidates, so i have installed the community versions of both suites. Before i go deep into detail testing on my own: What do you think makes Jasper BI Suite superior to Pentaho BI suite? What is better solved in Jaspersoft's BI suite and what in Pentaho's BI suite? Besides these questions: I posted several questions here in the Jasperforge analysis and server forum but did not get any answers. That's bad if i got stucked in some problems. How active is the Jaspersoft community? Is the Pentaho community more active in troubleshooting? Thanks for your answers in advance. Cheers, Andreas Post Edited by akrause at 06/22/2009 07:51

Just tested: The connection "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\Test.mdb" works in iReports without any problems, so is this a specific bug in the Workbench? Who can help me to get this connection running in the Workbench? Post Edited by akrause at 06/20/2009 09:39

Is seems to be a bug (?) in the Workbenck only, because when i test the schema in JasperServer then everything is ok here. But it would be great if testing the schema directly in the Workbench would work too. Has anyone a solution to this problem? Post Edited by akrause at 06/20/2009 09:32

I have defined a SQL2005 connection in the Workbench's connection dialogue which seems to work ok because i can browse all my tables of the SQL2005 database. I have defined my cube, dimensions and measures. Workbench forces me to use the "dbo" schema when using tables otherwise i can not continue modelling my cube. But when i try a MDX Query for my cube it presents the following error: SELECT [Measures].AllMembers ON COLUMNS, Hierarchize(([Zeit].[Alle].Children * [Debitoren (Gruppe)].[Alle Debitoren].Children)) ON ROWS FROM [sales] ---------------------------------- Mondrian Error:Internal error: Error while executing query [select [Measures].AllMembers ON COLUMNS, Hierarchize(([Zeit].[Alle].Children * [Debitoren (Gruppe)].[Alle Debitoren].Children)) ON ROWS from [sales] ] Mondrian Error:Internal error: while building member cache; sql=[select "tblDimZeiten"."Jahr" as "c0" from "dbo"."tblDimZeiten" as "tblDimZeiten" group by "tblDimZeiten"."Jahr" order by "tblDimZeiten"."Jahr" ASC] Invalid Objectname 'dbo.tblDimZeiten'. This table does of course exist in my database, otherwise i could not have used it in the table dropdown in my cube definition. I need help! What's wrong here?

I am trying to connect a MS Access MDB via JDBC ODBC in Analysis Workbench, but every connection url i try doesn't succeed. Connection urls i have tested: jdbc:odbc:Test (Test is defined as System-DSN on my Win XP machine) jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\Test.mdb When i click on "Test Connection" the url always changes to "jdbc:odbc:%s". What do i do wrong here?

Interested in that too, but for windows environment only. Can i connect to my MDB only via ODBC bridge or is a JDBC driver available?

I have located the following JasperForge downloads: JasperServer 3.5 JasperReports 3.5.2 iReport iReport Plugin for NetBeans Agg Designer - JasperAnalysis JasperAnalysis Workbench 3.5 JasperETL 3.1.1 Which of these packages do i need for evaluating a complete Jasper BI suite for my customers? What packages are optional? Post Edited by akrause at 06/19/2009 05:58

On windows the sqljdbc.jar should be copied into this directory: C:\Programme\jasperserver-3.5.0\apache-tomcat\webapps\jasperserver\WEB-INF\lib Hope this helps...

Hello, i want to use Jasper BI for reporting, analysis and data integration. I have downloaded JasperServer already, and it seems that JasperReports and iReports is included in JasperServer already. So no additional downloads for reporting necessary when using JasperServer, correct? But i think i have to download JasperAnalysis and JasperETL additionally, is that right? Concerning JasperAnalysis: what's the difference between "Agg Designer - JasperAnalysis" and "JasperAnalysis Workbench 3.5"? What do i need else for creating reports, cubes and datamarts? Cheers, Andreas