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
0 answers

Specify DataSource in API with query in Pentaho Report Designer

I am brand new to Pentaho reporting. I have a question regarding specifying DataSource. Is there a way to specify a DataSource using the API in Java with the query being specified in the .prpt file through Report Designer? I want to be able to…
Eqbal
  • 4,722
  • 12
  • 38
  • 47
1
vote
1 answer

append a string to a number field in Pentaho Report Designer

I have a number field which is the output of a query in the Report Designer and what I would like to do is append "AM - [number+1] AM/PM" to this. For eg. the query outputs 9,10,11,12,13 and so on. But, instead of the number 9 I would like to format…
Malavika
  • 87
  • 3
  • 14
1
vote
1 answer

How to specify a constant as the target value for a column in KTR

I am trying to set up a simple KTR to copy over data from one table to another. In the target table, I have a column called JobId which is not mapped to anything in the source table (the idea is to capture the KTR job id in this column). I notice…
Raam
  • 10,296
  • 3
  • 26
  • 27
1
vote
0 answers

How to change a Pentaho report's JNDI at runtime?

I have a lot of Pentaho reports that were built in Pentaho Report Designer 3.8 and use JDBC. I would like to set the data source's JNDI at runtime. I tried accomplishing this using an Action Sequence (without SQLLookupRule) but the report keeps…
Josh Humphrey
  • 61
  • 7
1
vote
2 answers

SQL/ETL Error, VISION: Too many columns (how to allow > 256)

I perform an ETL and download about 100 tables to my Companies data warehouse to perform reports and analysis on. Unfortunately I have no say on the database design and practices of the company I am downloading this information from. I connect to…
user1452180
  • 21
  • 1
1
vote
1 answer

How can I display the name of the prpt file on a report in Pentaho Report Designer

This maybe simple but I am trying to display the name of the report(.prpt file) in the Page footer section of the Pentaho report. Is there any way to do this in the Pentaho Report Designer?
Malavika
  • 87
  • 3
  • 14
1
vote
3 answers

run pentaho kettle from cmd. how to send the source files as a param?

I'm using Pentaho Kettle 4.0.1. Now I run a transformation from Java by providing a transformation file (XML type not KTR) and give some other XML files (in a src folder) that are meant to be inserted or updated in DB. What I want is to do these…
spauny
  • 4,976
  • 9
  • 44
  • 61
1
vote
0 answers

java.lang.NullPointerException exception in Pentaho Report Designer when previewing a query

I am new to Report Designer, and am trying to create my first report. I have created a JDBC Data Source, but when I try to preview the query, I get an error exception: java.lang.NullPointerException I can preview the results alright when my query…
Marina
  • 3,222
  • 5
  • 25
  • 35
1
vote
3 answers

I/O Error: SSO Failed: SSPI Not Initialized

I am using pentaho data integration 4.1 (Kettle) to build an ETL system. My customer requires connecting to database (MS SQL Server) using window authentication, I knew that Kettle supported it . However when I run my Kettle job, it throws the…
Minh-Hung Nguyen
  • 1,164
  • 1
  • 15
  • 21
1
vote
1 answer

Transformation configuration

What's the most proper and best practice driven way of configuration my transformations? In other words let's imagine I have a big ETL solution based on kettle that does stuff by connecting to different data source, I would like to store these data…
CoolStraw
  • 5,282
  • 8
  • 42
  • 64
1
vote
2 answers

Empty reports in Pentaho Client Console

I'm trying to publish a report to the bi-server, so I can visualize it from the Client Console (http://localhost:8080/pentaho/Home) I configured successfully a JNDI data source to a remote Database (Oracle 10g) from the Administration Console, this…
Hidalgo
  • 765
  • 1
  • 9
  • 28
1
vote
0 answers

visualising fault data in uptime-like charts

I have fault data in a database in the form of: faultid | faultcode | startdatetime | enddatetime Although the devices are polled every few seconds the entries in the database are only updated when the state of the device changes and so I might…
Rob
  • 11
  • 2
1
vote
1 answer

Error in querying a remote Oracle Database from Pentaho Report Designer

I'm trying to get some data from a remote Oracle Database, so I configured a new connection to the database and whn I press Test, it says that the connection was established succesfully, but when i tried a simple select query, Report Designer gives…
Hidalgo
  • 765
  • 1
  • 9
  • 28
1
vote
1 answer

Pentaho Kettle error: "Error closing prepared statement"

There is a Pentaho Data Integration (Kettle) Job that I'm trying to run on a client's workstation. It yields the following error: 2012/05/21 11:38:21 - Update Case Capital.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by…
bgh
  • 1,986
  • 1
  • 27
  • 36
1
vote
2 answers

Generate Column Total In Main Report From Sub Report - Pentaho

I'm creating a report in pentaho report designer. I have a sub report in my main report where it gets some values. I want to display the sum of those values from the subreport in the main report.
Shahin Khani
  • 199
  • 4
  • 14
1 2 3
…
99
100