Business Intelligence Conditional Styling in Pentaho Report Designer By Nikhilesh Conditional Styling in Pentaho Report Designer Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Claim Your 30 Days Free Trail Today in this blog we'll specifically concentrate on how to...
ETL Checklist before Starting new ETL Work By Nikhilesh ETL Checklist ETL Checklist is the things to know when you starting a ETL project. Database Connections: Metadata and the jar files required for Source and Target Databases Make data easy with Helical Insight. Helical Insight is the world's best...
Miscellaneous Generate Data Using SQL Server Implementing in Modrian Cube By Nikhilesh Generate data upto a certain time using SQL Server and implementing in Mondrian cube In case of some scenarios in which the data is very huge i.e. it is having data of upto last 10-20 years. Now the user wants...
Business Intelligence Dynamic Schema Processor Mondrian Schema in Runtime By Nikhilesh Introduction to Dynamic Schema Processor- Modifying Mondrian Schema in Runtime What is Mondrian? Mondrian is an open source OLAP Server which is written in Java. It supports MDX (Multi Dimensional Expression) query language and the XML for analytical and olap4j...
Business Intelligence BIRT Integration in Web Application By admin BIRT is an eclipse based reporting tool which produces a .rptdesign file. To view this .rptdesign file as a HTML file, it must be run through the BIRT engine. There are two ways of doing this, one is through...
Business Intelligence Mysql Connectivity in Pentaho Schema Workbench By Nikhilesh Resolving Mysql Connectivity issue in Pentaho Schema Workbench The issues pertaining to driver and jar files is quite common in the connectivity sector. In this blog we will concentrate on how to resolve the same with MYSQL as our selected...
Business Intelligence Virtual Cubes and their Significance in Mondrian By Nikhilesh What is a Virtual Cube and What is its Significance in Mondrian Before going into the Virtual cubes, first lets just refresh our memory about what is a cube. A cube is basically a multi dimensional views of data,querying and...
Business Intelligence Passing Parameters in Pentaho Data Integration Part 1 By Nikhilesh Passing Parameters From Parent Job to Sub-Job/Transformation in Pentaho Data Integration (Kettle) - Part 1 Part -1 : Using setter and getter methods : 1.Set variables in parent job/transformation. 2.Get variables in sub-job/transformation. Make data easy with Helical Insight. Helical...
Business Intelligence Passing parameters in Pentaho Data Integration Part 2 By Nikhilesh Passing Parameters From Parent Job to Sub Job/Transformation in Pentaho Data Integration (Kettle) -Part 2 In part 1, I have mentioned about passing parameter values down to sub-job/transformation using setter/getter methods. Please refer my previous post for part 1 Passing...
Business Intelligence Command Line Execution and Redirection Process in Pentaho (Kettle) By Nikhilesh Command line execution in Pentaho (Kettle) : Pentaho provides two command line utility tools to execute your job/transformation from outside of spoon. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Grab...
Business Intelligence Implementing Loops in Pentaho Data Integration By Nikhilesh Issues while implementing loops in Pentaho Data Integration Generally for implementing batch processing we use the looping concept provided by Pentaho in their ETL jobs. The loops in PDI are supported only on jobs(kjb) and it is not supported in...
Business Intelligence Batch Process Implementation in Kettle By Nikhilesh Batch Process Implementation in Kettle (Pentaho Data Integration) In order to implement the batch process we needs to have the looping logic. But I did not find any component or suitable method in kettle to create those loops. Make data...