Business Intelligence Beginner’s Guide to E.T.L (Extract, Transform and Load) – Connection Set-Up By Sohail Connection Setup for connection type: PostgreSQL [We are now setting up a connection to A database i.e if your source is a database] There are 3 ways of access provided for Connections using PostgreSQL a. Native (JBDC) b. ODBC c....
Business Intelligence Pentaho BA Server 6.0 : How to enable Pentaho Marketplace and Pentaho CDE(CTools) in the Enterprise Edition By Nikhilesh Enable Pentaho Marketplace and Pentaho C-Tools in Pentaho BA Server 6.0 EE Pentaho 6.0 is the first version of the Pentaho enterprise-class server with new features to automate, manage and enhance every stage of the data pipeline. Pentaho 6.0 also...
Business Intelligence Functions For Linking Two Dashboards in Pentaho CDE By Nikhilesh Use of Setparam() and GetParam() function for Linking Two Dashboards in Pentaho CDE In order to link two dashboards using Pentaho CDE, we can define two set of functions one which could set the parameters and the other where one...
Business Intelligence Remove Duplicate Values using Pentaho Kettle PDI ETL Tool By Nikhilesh How to avoid duplication of values in the columns in PDI if column names are same? Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your 30 Days Trail Version There...
Business Intelligence WITH Clause in MDX Pentaho By Nikhilesh WITH clause in MDX In MDX queries, the WITH clause has an important role to play. WITH clauses are used to define some members which will be used in the SELECT clause for analysis purposes. The WITH clause contains either...
ETL Get the Row Count in PDI Dynamically By admin Get the Row Count in PDI Dynamically Often people use the data input component in pentaho with count(*) select query to get the row counts. And pass the row count value from the source query to the variable and use...
Business Intelligence Cross Tabs in Pentaho Report Designer By Nikhilesh CROSSTABS in Pentaho Report Designer (EXPERIMENTAL FEATURE) Crosstabs are easy and relatively easy way to visualize tabular data along two or more axis. Crosstabs are still experimental feature, and as such are not up to mark in BI...
Business Intelligence Scheduling Jobs in Pentaho Data Integration By Nikhilesh Scheduling Jobs in Pentaho Data Integration The following are the steps to schedule a kettle job: In the main kettle job (.kjb) , there is a START icon should be there. Double click on the icon and it will pop...
Business Intelligence Implement Rollback in Pentaho By Nikhilesh A Simple yet Effective way to implement Rollback in Pentaho What is a Rollback mechanism? In database technologies, a rollback is an operation which returns the database to some previous state. Rollbacks are important for database integrity, because they...
Business Intelligence Memory Group By Vs Group By in Pentaho DI By Nikhilesh Memory Group By Vs Group By in Pentaho DI Group By and Memory Group By: These steps are useful to calculate aggregate values for the group of fields. Make data easy with Helical Insight. Helical Insight is the world's best...
Business Intelligence PDI Variable Parameter Behaviour By admin This article is specifically for those who are new to using PDI and are facing difficulty in understanding how the variables behave when being passed from one job / transformation to another job / transformation. PDI provides set variable component...
Business Intelligence Implementation of Security in Pentaho Using Dynamic Schema Processor By Nikhilesh Dynamic Schema Processor: How to Implement Security in Pentaho Using Dynamic Schema Processor In my earlier post, I had explained the meaning of Dynamic Schema processor (DSP) and why do we need it. Now if you have a Mondrian...