Stack Overflow
Stack Overflow

Questions tagged [pentaho]

The Pentaho BI Suite is an open source business intelligence suite with integrated reporting, dashboard, data mining, workflow, and ETL capabilities. It is primarily written in Java.

The latest GA release of Pentaho Suite has four primary downloadable products.

PDI - Pentaho Data Integration is a graphical extract, transform, and load (ETL) solution that uses an innovative metadata-driven approach. PDI includes the DI Server, a design tool (aka Spoon), three utilities, and several plugins.

PBA - Pentaho Business Analytics formally known as Pentaho Business Intelligence (BI) is mainly used for dashboard development.

PRD - Pentaho Report Designer is used for developing business (B2B and B2C) reports.

PSW - Pentaho Schema workbench is used for developing OLAP cubes and schemas.

3854 questions
1
vote
1 answer

Pentaho Acegi Security Framework Digest Authentication & Ruby on Rails

At the moment I have a Ruby on Rails application which maintains my Users, I have a seperate application (Pentaho) which uses Acegi/Spring Security to authenticate Users. I have been able to change the way Acegi/Spring Security authenticates Users…
user151419
1
vote
1 answer

Integrate Pentaho report designer with web application project

I have a requirement in web application to generate few reports. This report will include images, tables etc. My web application was built on Struts 2.X framework. I choosen Pentaho BI to generate reports. Can any one guide me how to integrate…
Shakthi
  • 175
  • 2
  • 13
1
vote
0 answers

How to convert IPentahoResultSet to JSON object

I am writing java code trying to convert an IPentahoResultSet to JSON so I can send it to a server using apache commons httpclient. I could not find any way to convert this pentaho result set to JSON. Any help will be appreciated. I have tried this…
TheWiz
  • 101
  • 1
  • 3
1
vote
1 answer

Aggregation Operation in Kettle / Pentaho

I'm trying to do an aggregate operation between some columns from an Excel file input. I have the following case: Column 1 Column 2 Column 3 X $15 A X $20 A Y $1 B Y $1 …
Alejandro Echeverri
  • 1,328
  • 2
  • 19
  • 32
1
vote
1 answer

Sorting on a parameter field in Kettle

I want to write a sub-transformatino that sorts a stream based on an arbitrary field (I'm going to need to sort several streams over the course of this entire project, and I'd like to just re-use 1 transformation and change the name of the field I'm…
Eric Hydrick
  • 3,467
  • 2
  • 28
  • 41
1
vote
2 answers

how to stop the js function on mouse over in it?

This code dynamically moves some dashboard files within specified interval of time in front end. Now once i move my mouse on any particular dashboard files its not stopping. So suggest me the code to stop the dynamic action on mouse over. var…
Dhinakar
  • 4,061
  • 6
  • 36
  • 68
1
vote
0 answers

Pentaho Max Column width error while trying to output an excel from xaction

I've managed to set up a sucessful working enviroment using 3 pentaho tools for my Database. A kettle transformation: which queries from a JNDI. A pentaho reporting: which organizes and outputs the data given by the transformation. And an Action…
tblancog
  • 332
  • 2
  • 14
1
vote
1 answer

Alternate editor (emacs/vim) in Pentaho Data Integration (Kettle)

I am new to kettle (Pentaho Data Integration) and am trying to develop some custom Java/JavaScript code. Is it possible to either edit the text blobs in emacs/aquamacs/vim/anything-else and/or save the scripts in separate files that can be directly…
user1330406
  • 11
  • 2
1
vote
1 answer

sum up sub-report data and show in main report

I'm using Pentaho Report Designer. I want to sum up the sub-report data and show it to my main report. Can it be possible? If possible, how to make it. Example : total0 is sum of month1,month2,month3...month12 Main Report: total0 Sub-report: month1…
tommy5115
  • 105
  • 2
  • 10
1
vote
1 answer

Migrating Kettle Files to a Repository

Currently we are managing our Kettle transformation (ktr) and job (kjb) files in a local file system as XML files. We would like to start using a Kettle repository. I am familiar with starting from scratch with a repository, but I have never…
dwaynehoov
  • 135
  • 1
  • 2
  • 7
1
vote
1 answer

SQL Server Express usage with Pentaho (or any non-microsoft product)

I'm trying to connect a local SQL Server database to an ETL utility called Pentaho. Pentaho very easily connects to full versions of SQL server without issue. I've set mixed mode authentication and created a sql server account for the sql server…
John Humphreys
  • 37,047
  • 37
  • 155
  • 255
1
vote
2 answers

Can you run jar files in Pentaho spoon tool?

I want to run a jar file that has java code, inside the Pentaho spoon tool. This run is a single step by accepting an input, running the java class on top of this data and then providing the output somewhere. Is this possible with Pentaho Spoon?
London guy
  • 27,522
  • 44
  • 121
  • 179
1
vote
2 answers

How to use wildcard to get ftp files on kettle spoon

I have a job using get ftp files, i am using this wildcard to fetch all the xml.zip files .*.zip Works ok, but downloads all the files. I tried a wildcard to download only files with this pattern: .outsideXXXXXX.xml.zip (with no success). …
jacktrade
  • 3,125
  • 2
  • 36
  • 50
1
vote
2 answers

Can We show the string value as a measure on mondrian olap

I want to show the string value as one of the measure value. When a fact table has a integer value and string value respectively and also has some foreign table's keys. Then I could show the integer value as a measure value, but I couldn't show the…
inohiro
  • 285
  • 1
  • 3
  • 17
1
vote
0 answers

Vectorwise integration Pentaho

I have a problem regarding the integration of Vectorwise with Pentaho. The Pentaho was working fine with other databases but integration with Vectorwise gives always the same error. AdhocWebService.ERROR_0012 - Failed to generate the report preview.…
Arjun Harish
  • 51
  • 3
1 2 3
…
99
100