Pentaho Flat Files and Pentaho (PDI) By Sohail What's a Flat File? Flat files are the universal mechanism for moving data from one database or system to another. There are two common types of flat files: CSV (comma separated values) and delimited files. Both are file formats that...
Pentaho Adding Filter to a Dashboard in Pentaho By Mounika Dashboard is an accumulation of reports. This blog helps you to add a parameter to the dashboard which can filter ‘All’ values. To create a dashboard and test functionality of filter added, create a report and add a filter to...
Pentaho Identifying Invalid Date Columns By Sohail Date Columns are essential in our Data, having the wrong data can lead to misplacement of data or reading of wrong data. With the use of DataCleaner we can achieve our goal of either correcting our data. We can also...
Pentaho How to Rename Excel Worksheets Dynamically in Excel Export By Mounika How to rename excel worksheets dynamically in excel export of the report in PRD A report created in PRD which generates multiple excel sheets. When exported to excel has default sheet names as sheet0,sheet1,sheet2…This blog would explain how to rename...
Pentaho Union and Selecting Required Columns By Sohail A union can be done on SQL but how can we do it on PDI without the use of SQL "UNION" Keyword this is possible with the use of “APPEND STREAMS” in PDI transformation. And just like SQL union we...
Pentaho Pentaho Plugin – Export to XLS is Not Working By Mounika This blog explains you the solution to a problem where export to xls of a report is not working in Pentaho. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your...
Pentaho Comparing Tables Schemas with Pentaho Data Integration By Sohail Most times our source Tables differs from our Destination Table, but in other times it doesn't.In a scenario where our source table is the same as our destination, then we might come into a situation where our source table could...
Pentaho Calculated Measure in Pentaho User Interface By Mounika My previous blog explained creating calculated measure using Schema Workbench. This blog will let you know how to add a calculated measure that fetches % of measure relative to a particular dimension in Pentaho User Interface. Make data easy with...
Pentaho Saiku Analytics – Pentaho Plugin By Ramu Vudugula Load/Save Dialog of Saiku Analytics - Pentaho Plugin Fails in Pentaho BA Server - No Folders listed PreRequisites: Pentaho Server 8.1v Saiku Plugin 3.15v Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence...
Pentaho Calculated Measure that Fetches the Previous Value of Measure By Mounika This blog will let you know how to add a calculated measure that fetches the previous value of measure relative to a particular dimension in Schema Workbench. Prerequisites : Pentaho BI Platform Schema Workbench Consider the below cube which is...
Pentaho How to Resolve the Exception While Calling Pentaho REST API By admin Pentaho REST API Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed. Prerequisites: Eclipse Neon, JDK 1.8 When we tried to call the REST API to...
Pentaho Set Properties in Pentaho By Sohail In this blog, we will learn how to set properties in Pentaho. Please do follow the below steps: Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Grab The 30 Days Free...