Is there anyone out there that used these two technologies and could give me some comparison in the form of advantages and disadvantages of both? I'm currently working with BO and I have heard that open source Pentaho does pretty good job as well. Thanks in advance! ...
I am working with Pentaho Data Integration (aka Kettle) and I have several Transformations, let's call them A, B, C, D, E. B depends on A, D depends on C and E depends on B and D. In a job I'd like to run A, B and C, D in parallel: -> A -> B _ Start< \ -> C -> D----> E where A and C run in parallel...
What are the main differences between the Pentaho BI Suite and JasperSoft BI Suite (as they are currently packaged in 2010)? ...
We have an application (Java) with an own OR mapper. Within this system we have what can be compared to Hibernate's interceptors (we call it triggers): Do specific actions just before saving data in the database, after it's deleted and so on. The underlying database is MySQL. Now we would like to use tools such as Pentaho Data Integrati...
I am new Pentaho Reporting Tool. I have the following question: When I created a report using Pentaho Report Designer, it output a report file having .prpt extension. After that I found an example on internet where the following code were used to display the report in html format:| protected void doGet(HttpServletRequest request, HttpS...
I am developing a java application and I want to use: Reporting Analysis Data Mining Data Integration tools to be shipped with my commercial application that I am NOT going to sell as an open source application. So I want to know which tools I can use in my app. Actually I am evaluating PENTAHO and JASPER but I don't understand lic...
Hi all. I'm not sure how to depict my question else this video (http://www.youtube.com/watch?v=K7aMVV5LsEU). I can manage info with Pentaho analysis views, but I'm not sure if I can modify analysis views, or maybe I have to find a third party BI plugin. Thanks in advance for your help ...
Hi all, Me again with Pentaho. Does anybody know if JPivotComponent can alert another CDF component when data is navigated? For example, I have a JPivot in dashboard, and I have a chart which will be updated when I expand any dimension in JPivot. Any idea? Thanks in advance. ...
Hi! I have an RPC service and one of the method is generating a report using Pentaho Reporting Engine. Report is an PDF file. What I'd like to do, is when user request a report, the report is sent back to him and save dialog or sth pops up. I tried this inside my service method: Resource res = manager.createDirectly(new URL(reportUrl), ...
I have one data warehouse table that contain one row for each item sold. Each row contains the item's type. What MDX request could show the number of items sold for each item type? What (dimensions,levels,etc) would it suppose to create? In case it is relevant, I am using Pentaho/Mondrian/Spoon/Schema Workbench. ...
The BI platform Pentaho 1.7 used to have an extension that allowed applications to be accessed from iPhone: http://www.pentaho.com/launch/iPhone Is it still maintained? If so, is it available in the Community Edition? ...
My datawarehouse table just contains a single date SQL column, but I want to be able to drill down using the usual year/quarter/month/day levels. I could manually create new column using Pentaho Kettle, and then create the levels one-by-one in Pentaho Schema Workbench. But this is such a common task (I guess everybody creating sales-re...
I'm trying to use Pentaho Data Integration / Pan to make a type-2 (SCD) table. After I ran my data through a DimensionLookup step a first time, I got a type-2 table that looks like: PKID version date_from date_to MyPK Field1 Field2 ... 150 1 1900-01-01 00:00:00 2199-12-31 23:59:59 1 "X"...
Hi I have used the aggregation designer to generate some tables. I just wanted to know is there anything else I have to modify in the cube definition xml? Currently it look likes the aggname name attribute values generated wont match correctly. Thanks ...
Hello, I would like to implement a dashboard with dashlets/portlets that offer the following functionality: A dashboard which shows the overall state of various services (Net Banking, Mail, Core Banking, Intranet,Sharepoint etc). First level can show the service name and a status showing Green, Amber, or Red. If the user clicks on the...
Using Pentaho Report Designer, I can successfully display my OLAP cube's data as a table. But when I want to display the same data as a chart, it always fail saying "CHART.USER_NO_DATA_AVAILABLE". Actually, I don't really know what I should enter for category-column and value-columns. I tried: category-column = [Area].[prefecture] val...
I'm still kind of new to RegEx in general. I'm trying to retrieve the names from a field so I can split them for further use (using Pentaho Data Integration/Kettle for the data extraction). Here's an example of the string I'm given: CN=Name One/OU=Site/O=Domain;CN=Name Two/OU=Site/O=Domain;CN=Name Three/OU=Site/O=Domain I would like...
Hi all I am doing comparison between three open source ETL tools Talend, Kettle and CloverETL. I could find with no problem Talend and CloverETL's connector list. But, I cannot find the one for Kettle. Does someone knows them or where can I find them ? Thanks a lot, ...
Hi, I'm using Report-designer 3.6.1, and i got a recurring problem with one of my report. When i try to print the report, i sometimes get a report with missing pages. The report print seven pages out of nine, and the last page print a page count of 7/9. Also on the last page, it doesn't print the footer as if it was not configured. This...
i get demo application from net for pentaho application...it shows some error on home.jsp like Could not generate chart image. Could not load chart data from samples/steel-wheels/homeDashboard/Sales_by_Territory.xaction Could not generate chart image. Could not load chart data from samples/steel-wheels/homeDashboard/Sales_by_Pro...