Pentaho Calculated Measure in Pentaho User Interface By Mounika My previous blog explained creating calculated measure using Schema Workbench. This blog will let you know how to add a calculated measure that fetches % of measure relative to a particular dimension in Pentaho User Interface. Make data easy with...
Pentaho Saiku Analytics – Pentaho Plugin By Ramu Vudugula Load/Save Dialog of Saiku Analytics - Pentaho Plugin Fails in Pentaho BA Server - No Folders listed PreRequisites: Pentaho Server 8.1v Saiku Plugin 3.15v Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence...
Pentaho Calculated Measure that Fetches the Previous Value of Measure By Mounika This blog will let you know how to add a calculated measure that fetches the previous value of measure relative to a particular dimension in Schema Workbench. Prerequisites : Pentaho BI Platform Schema Workbench Consider the below cube which is...
Pentaho How to Resolve the Exception While Calling Pentaho REST API By admin Pentaho REST API Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed. Prerequisites: Eclipse Neon, JDK 1.8 When we tried to call the REST API to...
Pentaho Set Properties in Pentaho By Sohail In this blog, we will learn how to set properties in Pentaho. Please do follow the below steps: Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Grab The 30 Days Free...
Pentaho Loops in Pentaho Data Integration 2.0 By Sohail Hi Guys on my previous Blog on Looping in PDI, I got a couple of feedback on how my approach can be more simplified so I decided to look into it and to my surprise, I was able to achieve...
Pentaho Migration from EE to CE of Pentaho BA Server By admin Community editions of any software or tool is a diluted version of the enterprise edition. This means that the CE version has some or many features removed which are available in the EE. As a result, the USPs of that...
Business Intelligence Metadata Injection in Pentaho Data Integration By Sohail Metadata Injection in Pentaho Data Integration The ETL Metadata Injection step inserts metadata into a template transformation. To Explain further, Let's have a simple scenario of Loading CSV Data into a Table, Make data easy with Helical Insight. Helical Insight...
Business Intelligence Loops in Pentaho Data Integration By Sohail Loops in PDI If only there was a Loop Component in PDI *sigh*. But we can achieve Looping Easily with the Help of few PDI Components. Let's take a requirement of having to send mails. Now if the mails...
Business Intelligence Analytic Query in Pentaho Data Integration By Sohail Analytic Query in Pentaho Data Integration [LAG & LEAD] Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. There could be a time we get a requirement as follows: Fetch Every Purchases...
ETL Alternative Approach of using Insert/Update Step for Upsert in PDI By Nikhilesh What is an UPSERT? UPSERT is a combination of two activities in a table i.e. Update and Insert based upon a unique key(Unique iD). A Relational database uses MERGE JOIN to perform UPSERT operation on data where it updates if...
Open Source Business Intelligence Different Ways of Implementing Loop in PDI By Nikhilesh Different ways of implementing loop in PDI We come across certain scenarios where in running of the Job/Transformation in loop becomes necessary in Pentaho. Below are the different ways of implementing the loop to the Job in PDI. 1....