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...
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...