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...
Business Intelligence Extract year,quarter,month & day from date input control in pentaho CDE using java script – MDX Query Scenario By Nikhilesh Hello guys...!! Some times you need to extract the parts(year,month,day) of Date for some specific use.. For example: Assume you are creating a report with MDX query which has dimension called "Date" having levels "Year", "Quarter","Month" & "Day". (Note :...
Business Intelligence Pentaho BI Server community 4.8 Installation in existing tomcat with PostgreSQL in Linux/ubuntu OS By Nikhilesh This post teach you how to install the Pentaho BI Server community 4.8 Installation in existing tomcat with PostgreSQL in Linux/ubantu OS. I've gone through many posts but could not find all the stuff in a single place. I just...