Business Intelligence PENTAHO(PDI) – Javascript – Convert string to number By Nikhilesh PENTAHO(PDI) - Javascript - Convert string to number Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. We have incoming String variables in javascript step. 1) In javascript use parsefloat for string...
Business Intelligence Pentaho Schema Workbench and Saiku Analytics – Quick Introduction By Nikhilesh Web-based Ad Hoc Query and Reporting Pentaho web-based ad hoc query and reporting is a capability that extends Pentaho Reporting to provide end-user self-service for report creation. Make data easy with Helical Insight. Helical Insight is the world's best open...
Business Intelligence Implement Load Balancing in Jaspersoft and Pentaho and Designing a Cluster By Nikhilesh Load Balancing in Jaspersoft and Pentaho and Designing a Cluster Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Grab The 30 Days Free Trail Load balancing is often done in...
Business Intelligence PDI Kettle – Difference between CE and EE By Nikhilesh Pentaho Data Integrator – Kettle along with Talend is one of the most famous Open Source ETL tool. KETTLE ( k- kettle, E- extract, T- Transform, T-Transport, L-Load, E-Environment). Make data easy with Helical Insight. Helical Insight is the world's...
Business Intelligence Pentaho C-Tools Manual installation in CE 4.8 and 5.0 – jar files installation By Nikhilesh Hi guys.. Some times we can NOT access Pentaho Market place due to the proxy settings enabled... I was trying it and unable to fix it .. will have a deep look into it... but alternatively installed Pentaho-C-Tools manually. Find...
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...
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 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 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 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...