bipentaho.wordpress.com
IFS Intergration | Pentaho - Open Source business intelligence
https://bipentaho.wordpress.com/ifs-intergration
Pentaho – Open Source business intelligence. We have now successfully implemented the basic models that takes sales history data from IFS and converts them into a reporting cube, at the time of writing this data started in 2005 and consists of approximately 2,000,000 lines. This data load happens once a day, but we will be working on taking this to every hour. The longest query takes around 20 seconds when the user is interacting with the data. 1 Comment ». August 27, 2011 @ 2:26 am. Iam very much intere...
bipentaho.wordpress.com
Getting the day name from the date | Pentaho - Open Source business intelligence
https://bipentaho.wordpress.com/2011/08/29/getting-the-day-name-from-the-date
Pentaho – Open Source business intelligence. Getting the day name from the date. August 29, 2011 at 11:56 am · Filed under Data-Intergration. Modified Java Script Value. I needed to add the day to my calendar file to make on of our dashboards look a bit more cool🙂. There is no direct getDayname function so using the getDayNumber build in function and a little bit of JavaScript gets the job done. Create a Modified Java Script Value and enter the following script. Var d1 = ACCOUNT DATE;. Fill in your deta...
bipentaho.wordpress.com
Ordinal Expressions | Pentaho - Open Source business intelligence
https://bipentaho.wordpress.com/2011/08/29/ordinal-expressions
Pentaho – Open Source business intelligence. August 29, 2011 at 1:40 pm · Filed under Ordinal Expressions. The problem faced today is reporting on sales orders that were entered onto the system in day order. Creating the day and day number was fairly straight forward and the solution can be found here. The issue comes when you add the day field to the report, it obviously sorts it into alphabetical order. To get around this you use Ordinal Expressions. 3 Comments ». September 16, 2011 @ 12:27 pm. 8230;] ...
diethardsteiner.blogspot.com
Diethard Steiner on Business Intelligence: May 2013
http://diethardsteiner.blogspot.com/2013_05_01_archive.html
Diethard Steiner on Business Intelligence. Open source business intelligence tutorials. Pentaho, Talend, Jasper Reports, BIRT and more. Data Integration, Data Warehousing, Data Modeling, BI Server Setup, OLAP, Reporting, Dashboarding, Master Data Management and many more. Friday, May 24, 2013. Pentaho Report Designer: How to show the parameter display name in your report when it is different from the parameter value. One of my blog's readers just asked me quite an interesting question:. Is set to CITY.
diethardsteiner.blogspot.com
Diethard Steiner on Business Intelligence: October 2013
http://diethardsteiner.blogspot.com/2013_10_01_archive.html
Diethard Steiner on Business Intelligence. Open source business intelligence tutorials. Pentaho, Talend, Jasper Reports, BIRT and more. Data Integration, Data Warehousing, Data Modeling, BI Server Setup, OLAP, Reporting, Dashboarding, Master Data Management and many more. Thursday, October 10, 2013. Understanding the Pentaho Kettle Dimension Insert/Update Step Null Value Behaviour. We will be using a very simple sample transformation to test the null value behaviour:. You can use the. Now let’s tes...
diethardsteiner.blogspot.com
Diethard Steiner on Business Intelligence: Pentaho CDE: Create your custom table
http://diethardsteiner.blogspot.com/2014/05/pentaho-cde-create-your-custom-table.html
Diethard Steiner on Business Intelligence. Open source business intelligence tutorials. Pentaho, Talend, Jasper Reports, BIRT and more. Data Integration, Data Warehousing, Data Modeling, BI Server Setup, OLAP, Reporting, Dashboarding, Master Data Management and many more. Friday, May 30, 2014. Pentaho CDE: Create your custom table. Pentaho Dashboards CDE: Create your custom table. You want to implement something in your dashboard that is not covered by the out-of-the-box dashboard components? Create a ba...
funpdi.blogspot.com
Fun with Pentaho Data Integration: SuperScript PDI plugin
http://funpdi.blogspot.com/2014/12/superscript-pdi-plugin.html
Fun with Pentaho Data Integration. Tuesday, December 30, 2014. As readers of my blog know, I'm a huge fan of scripting languages on the JVM (especially Groovy), and of course I'm a huge fan of Pentaho Data Integration :) While using the (experimental) Script step to do various things, I saw a few places where a script step could be improved for easier use and more powerful features. Specifically I wanted:. A drop-down UI for selecting the scripting engine. Step - A reference to the SuperScript step object.
funpdi.blogspot.com
Fun with Pentaho Data Integration: February 2015
http://funpdi.blogspot.com/2015_02_01_archive.html
Fun with Pentaho Data Integration. Wednesday, February 4, 2015. Apache Pig UDF: Call a PDI transformation. For my latest fun side project, I looked at the integration of Pentaho Data Integration (PDI) and Apache Pig. Pentaho Data Integration has long offered an " Pig Script Executor. A Pig UDF that can inject data into a PDI transformation and collect it on the other side, without needing PDI as a compile-time dependency. A way to bridge the Pig UDF to a PDI deployment. GetKettleClassloader - returns a c...
funpdi.blogspot.com
Fun with Pentaho Data Integration: Apache Pig UDF: Call a PDI transformation
http://funpdi.blogspot.com/2015/02/apache-pig-udf-call-pdi-transformation.html
Fun with Pentaho Data Integration. Wednesday, February 4, 2015. Apache Pig UDF: Call a PDI transformation. For my latest fun side project, I looked at the integration of Pentaho Data Integration (PDI) and Apache Pig. Pentaho Data Integration has long offered an " Pig Script Executor. A Pig UDF that can inject data into a PDI transformation and collect it on the other side, without needing PDI as a compile-time dependency. A way to bridge the Pig UDF to a PDI deployment. GetKettleClassloader - returns a c...
SOCIAL ENGAGEMENT