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
7
votes
2 answers

Pentaho Data Integration: Error Handling

I'm building out an ETL process with Pentaho Data Integration (CE) and I'm trying to operationalize my Transformations and Jobs so that they'll be able to be monitored. Specifically, I want to be able to catch any errors and then send them to an…
jonnysamps
  • 1,067
  • 1
  • 14
  • 20
7
votes
3 answers

JSON.parse() not working in javascript in pentaho

I am trying to form an array from a string using Modified Java Script Value step. Here is my code to parse a string and to form a JSON object. var info = {}; var keywords = 'Adjust course (C-6),Identify underlying factors (C-4),Isolate teacher…
Arunraj
  • 558
  • 5
  • 21
7
votes
3 answers

Test Reporting

We are migrating our test report data (unit, regression, integration, etc..) from an XML format to a database format for better analysis. Right now the majority of our test analysis is done using the CruiseControl.NET dashboard, but this is limited…
Adam Driscoll
  • 9,395
  • 9
  • 61
  • 104
7
votes
3 answers

MDX date range query with a missing boundry date

I need an MDX query for Mondrian filtered by date, where one or both of the boundry dates may not exist. I'm using the query below that works as long as both 2013-01-01 and 2013-01-08 dimensions exist. If one of the two dates does not exist then…
Dynamite
  • 93
  • 4
7
votes
1 answer

Print variable in a CDE dashboard using html or javascript

I have a dashboard with a popup slicer, but once I close the popup there is no way to tell which variables were selected, so I would like to display, above the chart, in a row, a path kind of line including all parameters I'm selecting in the slicer…
Martin Ocando
  • 914
  • 2
  • 8
  • 18
7
votes
2 answers

How do I concatenate string in Pentaho spoon?

I am a newbie to Pentaho (installed today). I was able to do basic transformation in Spoon. Now I need to do some stuff, which I can't figure out how. my input looks…
Thoughtful Monkey
  • 648
  • 2
  • 10
  • 24
6
votes
2 answers

Problems connecting Pentaho Kettle/Spoon to Heroku PostgreSQL using SSL

I'm trying to connect spoon to a Heroku PostgreSQL instance using the JDBC driver that came with Spoon. Heroku requires SSL for it's stand alone PostgreSQL instances, which I have enabled. I'm able to connect to the database using other client…
Jamie Buchanan
  • 3,868
  • 4
  • 22
  • 24
6
votes
1 answer

Need an example POM file for running a Pentaho kitchen/pan transformation and job during the integration test phase

I have spent too many hours on Google and on the Pentaho forums looking for a simple example for what I would think would be common use case. I am asking fellow SE folks to help answer this question. I have a project which is a mixture of Java and…
Scott C
  • 61
  • 3
6
votes
3 answers

Open Source Java Reporting Framework

i want to create few Reports which picks data from few SQL tables, So instead of creating different report's i want to create (or use any Open source) reporting framework, I googled about it but still didn't find enough information to try…
dpsdce
  • 5,290
  • 9
  • 45
  • 58
6
votes
1 answer

Difference between pentaho application server clustering and carte clustering

I am new with pentaho. Currently we need to cluster our pentaho CE to load balance the transformation we have. But honestly we are confused how to do it. On the pentaho documentation Cluster the Application Server - Pentaho Documentation , it…
rama3i
  • 156
  • 1
  • 7
6
votes
2 answers

Is there a Spring Security DefaultLdapAuthoritiesPopulator implementation that supports nested groups?

I am trying to get a Pentaho-BI server which uses spring security to support nested LDAP roles. My group structure is as follows: PentahoAdmins (group) Members: Domain Admins Domain Admins (group) Members: User1 User1 (user) I would like to…
bayfieldcoder
  • 158
  • 2
  • 8
6
votes
2 answers

MDX: Filtering a member set by a measure's table values

I have some numbers in a fact table, and have generated a measure which use the SUM aggregator to summarize the numbers. But the problem is that I only want to sum the numbers that are higher than, say 10. I tried using a generic expression in the…
oyvinro
6
votes
1 answer

How do I transpose a table in Pentaho Kettle from rows to columns without the header column

I'm new to Pentaho and I need to transpose a table from rows to columns, but the first column doesn't contain the headers. It looks something like this: Jan/15 Feb/15 Mar/15 Apr/15 1.1 3.4 1.7 2.0 2.5 4.5 2.4 3.3 And I…
Slaski
  • 65
  • 1
  • 1
  • 5
6
votes
4 answers

How to get the reorder the column with csv input fixed column in pentaho

Scenario: I have created transformation to load data into table from csv file and I have following columns in csv file: Customer_Id Company_Id Employee_Name But user may give input file with column ordering (random order) as…
yuvi
  • 564
  • 5
  • 12
6
votes
3 answers

Newly inserted or updated row count in pentaho data integration

I am new to Pentaho Data Integration; I need to integrate one database to another location as ETL Job. I want to count the number of insert/updat during the ETL job, and insert that count to another table . Can anyone help me on this?
Sreejith
  • 587
  • 1
  • 9
  • 18
1 2
3
…
99 100