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 Pentaho 5.0.1 CE integration with MySQL 5.0.1 CE (Windows or Linux family) By Nikhilesh Pentaho 5.0.1 CE integration with MySQL 5.0.1 CE (Windows or Linux ) Parts Creating databases Modifying configuration files Stopping HSQL db start up Creating databases Command to execute the scripting files mysql>source D:\ biserver-ce\data\mysql5\create_jcr_mysql.sql Similarly execute the remaining .sql files(i.e,...
Business Intelligence Inter panel communication in pentaho CDE By Nikhilesh Inter panel communication in pentaho CDE In this post you will learn how to communicate with the other panels in the same dashboard. Example Scenario : Panel 1 : BarChart is placed in panel-1 Panel 2: Table data displayed in...
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...