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

looping in a Kettle transformation

I want to repetitively execute an SQL query looking like this: SELECT '${date.i}' AS d, COUNT(DISTINCT xid) AS n FROM table WHERE date BETWEEN DATE_SUB('${date.i}', INTERVAL 6 DAY) AND '${date.i}' ; It is basically a grouping by time…
Raffael
  • 19,547
  • 15
  • 82
  • 160
1
vote
1 answer

Src jar for Pentaho Kettle

Where can I find a src-jar for Kettle? I'm looking for a jar that contains the Java files, and I can point my IDE to (like for example junit-4.6-src.jar).
ripper234
  • 222,824
  • 274
  • 634
  • 905
1
vote
1 answer

How to use a field as the MDX Query of a Mondrian Input Step instead of a variable?

I have a PDI Transformation that begins with a 'Get rows from result' step. Each of the rows contains a field that has an MDX command as its value. I am using the 'Mondrian input' step and want to use that field in the MDX Query area, but it seems…
Katerina Mpagouli
  • 171
  • 6
1
vote
1 answer

#Pentaho Open Source BI Tools

I have previously worked on BI projects using MSSQL Server 2008 R2, SSAS and SSIS on a C# based ASP.net Web App. I wanted to try the same thing open source tools using Java. Could anyone please suggest me the tools?? I went through Pentaho and…
Ayush
  • 485
  • 2
  • 6
  • 19
1
vote
2 answers

How can I extract a prpt file to make changes to it without using Pentaho Report Designer

I would like to edit the prpt file by making the changes to the .xml files within instead of editing it in pentaho Report designer. I used winRAR and extracted the files, made the changes to the layout.xml and tried to "Add to Archive" by changing…
Malavika
  • 87
  • 3
  • 14
1
vote
1 answer

Pentaho Adhoc reports - allow limited data access to user

I have created a set of metadata objects and exposed it to a set of users to create adhoc reports. The user can use the meta data objects and create their own reports. However, the problem is - the objects correspond to tables having millions of…
Ujjwal
  • 603
  • 12
  • 23
1
vote
4 answers

running multiple jobs from a batch file in pentaho

I would like to ask if there is a more efficient way of running multiple transformations(70 transformations) besides the IDE? Doing it the IDE way is alright but it does become tedious having to click all the tabs and the hidden tabs as well. What I…
chip
  • 3,039
  • 5
  • 35
  • 59
1
vote
2 answers

pentaho user console excel output

I am trying to get excel report output from 'pentaho user console'. I created a cube in schema workbench and uploaded the cube and creating report out of it. My excel report says "Unable to render report table. The table may not contain more than…
Mario
  • 2,303
  • 5
  • 20
  • 21
1
vote
1 answer

disply cube in saiku through pentaho schema workbench

I am trying to publish cube which is created on pentaho schema workbench and trying to analyses the result into bi server, in this procedure i am successfully published the cube but facing exception of Table not found in statement exception in saiku…
Helping Hand..
  • 2,430
  • 4
  • 32
  • 52
1
vote
1 answer

Pentaho CDE NewMapComponent doesn't show markers description tooltip

I am trying to build a map using the pentaho CDE NewMapComponent (OpenStreet engine). Everything is working great, however i'm having problems adding the description tooltip for each marker. I'm using a sql datasource, with a column for latitude,…
bvt19
  • 19
  • 1
  • 5
1
vote
1 answer

reporting vs analysis with Star schema data warehouse

I'm working on a BI project where i'll use pentaho. My DW will be modelize as a star schema. I know that for the analysis part we need to go from this star schema (relational DW) and design the cube thks to schema workbench for example. Thks to…
joris
  • 435
  • 1
  • 7
  • 18
1
vote
1 answer

Modelisation of a star schema DB for a pentaho project (mysql workbench or schema workbench)?

I'm working on a BI project where I'm gonna use pentaho. I'm currently deisgning the DB. I know that in pentaho I need schema workbench to create my cubes and "universe" for the final users. Can I first use mysql workbench to create and modelise my…
joris
  • 435
  • 1
  • 7
  • 18
1
vote
1 answer

How to extract XML node values and attributes from recurring nodes

I am using Kettle and the Get Data From XML transformation to extract certain information from an XML file. I set Loop Xpath to /*[name()='feed']/*[name()='entry'] which brings in all the relevant fields. I would like to extract each node…
Jake Parker
  • 13
  • 1
  • 4
1
vote
1 answer

automating downloads of facebook insight data

I'm looking for a tool or process for exporting facebook insights data for a facebook page and a facebook app. Currently I am just manually downloading csv files from their Insights interface but ideally I want to automate this process and load the…
user2084831
  • 11
  • 2
1
vote
1 answer

Pentaho Google analytics plugin - what does it do when there is more than 10,000 rows?

The response to each GA request returns a certain number of rows (with a maximum of 10,000). If your first request defines a query that will result in more than 10,000 rows (say for the example it results in 26,000 rows), then only the first 10,000…
James
  • 12,636
  • 12
  • 67
  • 104
1 2 3
…
99 100