Business Intelligence Pentaho CDE Dashboard Example – Adding few more functionality to it By Nikhilesh I have been exploring the pentaho CDE... A small work around on it which has given me a learning experience as well understanding the power of the tool... Here is a example dashboard for you... and adding more functionality to...
blogs Dates in Jasper iReport – Passing default values By Nikhilesh This post teach you how to play with default date parameters & calculations on dates in jasper iReport. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your 30 Days Trail...
Business Intelligence Adding dollar($) sign to X-axis lables(values) for bar charts in pentaho CDE By Nikhilesh Hi Guys, Using below java script one can easily add '$' sign to the values of X-axis for any charts in pentaho CDE. Example: function f(v) { return "$" + sprintf('%d', v/1000) + 'k'; } Write the java code in...
Business Intelligence Bar chart with Target lines in pentaho CDE – making bars as lines using java script in pentaho CDE By Nikhilesh Hi guys, This post teach you how to make bars as lines in pentaho CDE. Scenario : Some end users wants visualization of grouped bars as lines where one of the bar is as bar and remaining bars as targeted...
Business Intelligence Jaspersoft System Integration (SI) Partner Helical IT Solutions By Nikhilesh Helical, a fast growing Business Intelligent (BI) organisation, offering Open source BI solutions across verticals has been appointed by Jaspersoft as a System Integrator Partner. As per the tie-up, Helical IT Solutions will be a System Integration Partner for Jaspersoft...
Business Intelligence Embedding BI Reports (Jasper Reports/ Jasper Server/ Pentaho Reports/ Pentaho Server) By Nikhilesh There are many methods of embedding BI reports, this blog tries to explain the meaning of Embedded BI, different approaches which can be used, their respective advantages and disadvantages A) What is embedded BI? Lets say you have developed...
Business Intelligence Change Data Capture (CDC) – Methods, Approaches, Alternatives By Nikhilesh Change data capture : It’s the process of tracking the data that has changed so that corresponding action can be taken. Its nothing but capturing the changes which are made on the data source and applying it at all the...
Business Intelligence MariaDB to MariaDB Data Replication Strategies By Nikhilesh Data Replication Strategies This blog will try to explain about the different MariaDB to MariaDB replication strategies which can be followed. Replication Benefits Replication is having a number of benefits, some of them includes: Scalability: By having one or...
Business Intelligence start_date and end_date parameters – giving default values – iReport By Nikhilesh Hi Guys, This post let's you know how to use date parameters in SQL query using between operator and using multi select parameter. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool....
Business Intelligence Pentaho CDE Basics By Nikhilesh Pentaho Community Dashboard(CDE) basics - Creating a Simple Dashboard Pentaho Community Dashboard Editor (CDE) What is CDE ? Where you can get the plug-in in Pentaho Community Server ? How to download the plug-in & what are the dependencies? Where...
Business Intelligence Internationalization of jasper reports – Hello world example By Nikhilesh Hi guys.. small work out but very use full.. Generally customers want to see data in their own language. This example is developed using iReport 5.1.0 pro, Jasper server pro and foodmart db with postgresql. Sources/References : Example : Converting...
Business Intelligence Reading data from single data source(Single SQL Query) for two charts in pentaho CDE By Nikhilesh Hi guys...!!! Community Dashboard Editor is the best reporting/dash boarding tool that I have worked. It's smart functionality made me love to work with it and exploring the things time by time. In this post you'll learn how to fetch...