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....
ETL Java Annotation By Somen Sarkar Java Annotation Annotation Quick Tips 1. Annotations were introduced since java 1.5 2. Annotation are data about the code. They are tags that may be useful while compilation or execution. 3. @Override, @author etc are some defualt annotations. 4. We...
Business Intelligence How to Create a Batch File to Run a Scheduled Pentaho Transformation By Nikhilesh HOW TO CREATE A BATCH FILE TO RUN A SCHEDULED PENTAHO TRANSFORMATION Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Make data easy with Helical Insight. Helical Insight is the world's...
Business Intelligence How to Write Basic MDX Query By Nikhilesh How to write basic MDX query When writing MDX queries you need to make a clear distinction between the data and metadata. Cube data is what is being presented to the users, for example you would show the sales amount...
Business Intelligence Drill Down in Same Panel in Pentaho CDE By admin Drill Down in Same Panel in Pentaho CDE First create dashboard having two three panels as in example shown below :- Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your...
Business Intelligence Mondrian Cache Refresh Automation Mechanism in Pentaho BA Server By Nikhilesh REFRESH MONDRIAN CACHE ON THE BA SERVER One of the strengths of mondrian's design is that you don't need to do any processing to populate special data structures before you start running OLAP queries. More than a few people have...