Business Intelligence Overcome Jasper Reports Complexities using PLPGSQL By Nikhilesh This document is to help users to overcome jasper reports complexities using PLPGSQL (Postgres Stored Procedure function). Will look into the complexity with input controls of type multi-select query and how to cascade them. Make data easy with Helical Insight....
Business Intelligence D3 Calendar Chart Integration in Jaspersoft By Nikhilesh This blog will talk about what is calendar view chart, its usage and about how to create and integrate a D3 Calendar View Chart in Jaspersoft / iReport Make data easy with Helical Insight. Helical Insight is the world's best...
Business Intelligence D3 Chord Diagram Integration in Jaspersoft By Nikhilesh This blog will talk about what is chord diagram, its usage and about how to create and integrate a D3 Chord Diagram in Jaspersoft / iReport All the reports are develop using ireport 5.5 professional and jasper server 5.5 As...
Business Intelligence Create CSV Data Sources in Pentaho CDE: (Community Dashboard Editor) By Nikhilesh This blog will talk about how to Create CSV Data Sources in pentaho CDE: (Community Dashboard Editor) Follow the steps to create CSV file as a Data sources. Step-1 Login to the User Console as an administrator. Step-2 Click Manage...
Business Intelligence Create Organization using REST Webservice in Jasperserver / Jaspersoft By Nikhilesh This blog will talk about how to create organizations using REST webservice in JasperServer. STEP 1:- Put the following jar files in lib folder: Commons-codec-1.4.jar Commons-io-1.4.jar http-core-4.1.jar httpclient-4.1.1.jar httpmime-4.1.jar Jakarta-httpcore.jar Restclient-cli.3.2.2-jar-with-dependencies.jar Servlet-api.jar STEP 2:- Create a jsp page index.jsp:...
Business Intelligence Using Pentaho Schema Workbench (PSW) By Nikhilesh Schema -: A schema defines a multi-dimensional database. It contains a logical model, consisting of cubes, hierarchies, and members, and a mapping of this model onto a physical model. Make data easy with Helical Insight. Helical Insight is the world's...
Business Intelligence Pentaho BI and Ctools – Introduction By Nikhilesh Pentaho Overview: It offer a suite of open source Business Intelligence (BI) product called Pentaho. Business Analytics provide, Data integration, OLAP Service, Reporting, Dash boarding, Data Mining, ETL Capabilities and BI platform. It is web application like Jaspersoft. It uses...
Business Intelligence Creating Dashboard using Pentaho CDE By Nikhilesh This blog will talk about how to create a dashboard using Pentaho CDE (Community Dashboard Editor) framework:- 1. Open Browser and paste this url in below localhost:7080/pentaho login inside pentaho according to username and password which one provided in your...
Business Intelligence Best Practices when designing & using iReport /Jaspersoft By Nikhilesh This blog talks about the best practices which should be followed when creating reports using iReport or Jasper studio, deploying the same on Jaspersoft server, nomenclature to be used etc. Make data easy with Helical Insight. Helical Insight is...
Business Intelligence D3 Integration with Jaspersoft / iReport / Jasper Server By Nikhilesh There can be different methods of integrating a D3 chart inside Jasper like using iFrame, using HTML etc. Below we will try to learn in detail how to do integration of D3 chart using HTML component integration. What is...
Business Intelligence Creating Candlestick Chart in iReport / Jaspersoft / Jasper Report By Nikhilesh This blog will talk about how to create candlestick chart in Jaspersoft. PREREQUISITE S/W:- Jaspersoft(any version) iReport tool(design) d/b softwares (eg.MySql) JAVA Eclipse(if require) WHAT IS CANDLE STICK CHART? The candlestick techniques we use today originated in the style...
Business Intelligence Installing Jasper Server in AWS EC2 / LINUX By Nikhilesh Things we need to find out before installing Jasperserver in AWS EC2 / Linux. 1) Identifying whether your CPU is a 64bit or not. Use below command to find it Make data easy with Helical Insight. Helical Insight is the...