Business Intelligence Creating Custom Component in Talend Open Studio By Nikhilesh Creating Custom Component in Talend Open Studio What a component is? Graphically it is an icon which you drag from palette to the work place. But technically it is a file folder which has the same name of the component...
Business Intelligence Using MDX Query in Pentaho CDE By Nikhilesh This blog will talk about Using MDX Query in Pentaho CDE In Layout Section: Design the layout of your Dashboard, from scratch or from a template - while defining the layout you can apply styles and add HTML elements as...
Business Intelligence Define JNDI for Pentaho BA server 5.0 By Nikhilesh Define JNDI for Pentaho BA server 5.0 Note: For illustration, I’m showing Oracle 11g configuration. Replace the Resource name, username, password, driverClassName, and URL parameters, or any relevant connection settings. Add Driver Place appropriate driver for Oracle 11g which is...
Business Intelligence Working with Crosstab Component In Pentaho Report Designer By admin This blog will teach reader about Working with Crosstab Component In Pentaho Report Designer Crosstab is an experimental feature in Pentaho Report Designer . By default we can’t see crosstab component in PRD. Make data easy with Helical Insight. Helical...
Business Intelligence How to Create Reports Using Pentaho Report Designer By Nikhilesh How to create reports using Pentaho Report Designer Pentaho Business Intelligence platform provides several tools to design and deploy reports, the easiest is the Pentaho BI web reporting wizard. While this approach is useful for basic or self service reporting, for...
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...