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

Chart refresh avoiding dashboard refresh in pentaho CDE

I'm developing a 3 charts dashboard, with pentaho cde (from community ctools). The 3 charts are displayed one below the other, so they're not visible to the user unless scroll. My current problem is that when I want to navigate through the charts in…
wideawakening
  • 51
  • 1
  • 7
1
vote
2 answers

Pentaho Report Designer (PRD): Use parameter in select clause

In the report I'm working with, I need to display information of four columns of a database table. The first three columns of the table are SEX, AGE and NAME. The other N columns (N being like 100!) are questions, with every line of the table…
Bruno Gama
  • 11
  • 1
  • 4
1
vote
2 answers

pentaho integration with mysql-5.X

When I was trying to replace the hsqldb with the mysql-5.X I get the following error with quartz error failed to initialize:- Pentaho Initialization Exception The following errors were detected One or more system listeners failed. These are set in…
user2030491
  • 36
  • 1
  • 3
1
vote
2 answers

Parsing text files using pentaho

I have a large number of text files that I need to load into a database. Instead of being in the more usual csv format they are structured like this: TY - JOUR T1 - On the Structure and Life-History of Entyloma ranunculi (Bonorden) JF -…
Stevetech
  • 115
  • 1
  • 1
  • 5
1
vote
2 answers

Pentaho kettle database error

I am trying to connect to the Infobright database from Kettle Spoon. After 15 minutes 2 seconds, I get this message: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure. Can someone please tell me where to change…
Mario
  • 2,303
  • 5
  • 20
  • 21
1
vote
1 answer

Pentaho Report Output remote execution

I have a pentaho BI server running on a CentOS machine (osapp), then the MySQL database with repository, staging and data wharehouse in another CentOS machine (osdb). I run Spoon from my Windows PC. I created a transformation to run a Pentaho…
Martin Ocando
  • 914
  • 2
  • 8
  • 18
1
vote
3 answers

Loop in Kettle/Spoon/Pentaho

I have a query like this: SELECT count(distinct ID) FROM TBLC WHERE date BETWEEN ? AND ?; I am using Pentaho Spoon. I am using 'Execute SQL Script'/ statement. The options I see are Execute for each row, execute as a single statement and variable…
Mario
  • 2,303
  • 5
  • 20
  • 21
1
vote
1 answer

How can I exclude a category in a Pentaho Report Designer column chart?

I need to create a column chart that includes most, but not all, categories from my data set. For example, my data set's categories are {x, y, z} and I need the column chart to display data only for {x,y}. How can I do this in Pentaho Report…
Marina
  • 3,222
  • 5
  • 25
  • 35
1
vote
1 answer

how to solve this error "org.apache.commons.vfs.FileSystemException: Could not create file" in kettle

i am using kettle 3.2. i have a requirement like i need to write CSV file based on the data from the another table. As the number of rows increases the CSV files also increases. i mean if i have 2 rows then the file will created like 1st row data in…
Avinash
  • 93
  • 2
  • 10
1
vote
1 answer

How to use Pentaho Data Integration (Spoon 4.4) for Star Modeling

I'm looking for a tool to build a Mondrian's cube XML description file to use over my Star Schema (one fact table and 4 dimensions tables directly link to the fact table). I'm a bit lost, browsing tutorial doesn't help since they seem to be about…
AsTeR
  • 7,247
  • 14
  • 60
  • 99
1
vote
1 answer

Control data flow in Pentaho transformation with variables

I want to control data flow in pentaho transformation files with system variables. I found a component called 'simple evaluation' which is exactly what I want, however it can only be used in job files. I have gone through component-tree of…
Tony Zhu
  • 301
  • 1
  • 6
  • 16
1
vote
1 answer

Query with calculated measurement using olap4j QueryDimension

I am using olap4j to query my rolap cube (underlying implementation is pentaho). I could not found any way to add on-the-fly calculated measurement to the query while using the org.olap4j.query package.(there is a way when using the low level api in…
yosi
  • 639
  • 1
  • 12
  • 21
1
vote
2 answers

how to look for the content of text file in pentaho?

I have a ETL which give text file output and I have to check the those text content has the word error or bad using pentaho. Is there any simple way to find it?
Cynosure
  • 161
  • 2
  • 3
  • 9
1
vote
1 answer

Using Pentaho for displaying Data

my company maybe wants to use Pentaho for displaying Data from Navision with multiple clients on a Dashboard. Would it be more work to do this with Pentaho instead of .net and Navision web services? We will need to configure AD on the Dashboard,…
Florian
  • 1,827
  • 4
  • 30
  • 62
1
vote
0 answers

Why is my Pentaho server running slow, on Linux?

I am using Pentaho 4.8 and this is the configuration in my start-pentaho.sh export CATALINA_OPTS="-Xms256m -Xmx1024m -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000" Can anybody please explain…
Hussain Akhtar Wahid 'Ghouri'
  • 6,527
  • 8
  • 50
  • 85
1 2 3
…
99 100