Pentaho Handling Null values in Talend and Pentaho By Nikhilesh Handling Null values in Talend and Pentaho Handling Null values in Talend: Make all the columns as Nullable in tMap Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your 30...
Business Intelligence Slowly Changing Dimension in Pentaho Data Integration(Kettle) By Nikhilesh Slowly Changing Dimension in Pentaho Data Integration(Kettle) Slowly changing dimension(SCD) is a common mechanism in Datawarehousing concepts. The exact definition of SCD is the dimension that changes slowly over a time rather than on a regular schedule. In Data Warehouse...
Business Intelligence Looping and Batch Processing in PDI By Nikhilesh Implementing Loops and batch processing in Kettle What is batch processing? Batch processing is basically a series of execution of jobs from source to destination. Here the data is divided into smaller batches and transferred to the destination. This helps...
Business Intelligence Pentaho Analysis: Workflow By Nikhilesh OLAP Analysis: Workflow To prepare data for use with the Pentaho/Jaspersoft OLAP Analysis (and Reporting, to a certain extent) client tools, you should follow this basic workflow : Design a Star or Snowflake Schema The entire process starts with a...
Business Intelligence Audit Logs in Pentaho Data Integration (PDI) By Nikhilesh Audit Logs in Pentaho Data Integration Audit Logs at Job level and Transformation Level are very useful for ETL projects to track the details regarding Job name, Start Date, End Date, Transformation Name, Error,Number of Lines Read, Number of Line Write,...
Business Intelligence Migrate Oracle with Pentaho By Nikhilesh Steps to migrate Oracle with Pentaho Step 1:- Run the script as DB admin. Script is available in location:- biserver-ce\data\oracle10g. Modify configuration file:- applicationContext-spring-security-hibernate.properties. Location:- pentaho-solutions\system\applicationContext-spring-security-hibernate.properties. original code:- jdbc.driver=org.hsqldb.jdbcDriver jdbc.url=jdbc:hsqldb: hsql:// localhost:9001/ hibernate jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.HSQLDialect Modified code:- dbc.driver=oracle.jdbc.OracleDriver jdbc.url=jdbc:oracle:thin:@localhost:1521/sysdba...
Business Intelligence Table Expansion in Pentaho CDE By Nikhilesh Hello, we are now working on Table Expansion property of Pentaho CDE. Simple, expanding a Main Table on click and render relevant data in Any Chart / table. Make data easy with Helical Insight. Helical Insight is the world's best...
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...