Business Intelligence Anonymous Authentication in Pentaho By Nikhilesh This blog will be talking about anonymous authentication in Pentaho. You can bypass the built-in security on the BA Server by giving all permissions to anonymous users. An "anonymousUser" is any user, either existing or newly created, that you specify...
Business Intelligence Jasper BI And Pentaho Reports Performance Optimization By Nikhilesh In any BI solution, we create a lot of reports and dashboard. Often the developers come across the problem that the solution is not performing well, the reports are taking a lot of time to load. In this blog we...
Business Intelligence Creating Cascading Parameters with Pentaho Report Designer 5.0.1 Stable By Nikhilesh Here we will be talking about creating cascading parameters with Pentaho Report Designer 5.0.1 Stable. Cascade parameters provide a way of managing large amounts of data in reports. You can define a set of related parameters so that the list...
Business Intelligence Installation of Pentaho 5.0.1 CE with Postgresql db (in Windows 7 / Ubuntu / AWS) By Nikhilesh This blog will elaborate about Installation of Pentaho 5.0.1 CE with Postgresql db (in Windows 7 / Ubuntu / AWS) 1.Putty configuration Step-1: Go to start menu and click putty or Desktop find where is putty. Step-2: Just provide IP...
Business Intelligence Talend Open Studio (TOS) versus Pentaho Data Integrator (Kettle) By Nikhilesh This blog will be talking about Talend Open Studio (TOS) versus Pentaho Data Integrator (Kettle) Talend Open Studio (TOS) and Pentaho Data Integration (Kettle) are two comprehensive and widely used Open Source ETL tools. Pentaho Kettle The company started around 2001 (2002 was when...
Business Intelligence SCD Type 1 Implementation on Pentaho Data Integrator By Nikhilesh This blog will talk about SCD Type 1 Implementation on Pentaho Data Integrator Slowly Changing Dimension Type 1 does not preserve any historical versions of the data . This methodology overwrites old data with new data, and therefore stores only...
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 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...