Pentaho Data security for Interactive Report in Pentaho By Mounika This blog covers the process of applying data security for interactive reports in Pentaho based on logged in user. Pentaho Interactive Reporting is a drag-and-drop, browser-based design environment for interactive reports that allows you to quickly add elements to your...
Pentaho Data Source Creation for Interactive Report in Pentaho By Mounika This blog covers the process of creating a data source for interactive reports in Pentaho. Pentaho Interactive Reporting is a drag-and-drop, browser-based design environment for interactive reports that allows you to quickly add elements to your report and format them...
Pentaho Loading Data from CSV 2.0 By Sohail Loading Data from CSV into DB in Pentaho Data Integration is very easy because the 3 things are required A Created Table Text File Input/CSV Input Component Table Output Now, what if we don't have a table created and we...
Pentaho How to Solve Duplicate Data Issues in Mondrian Hierarchy By Mounika In a cube, sometimes we come across issues related to data like duplicate values appearing in the cube. This blog explains how to solve such kind of data issues. Scenario 1: The reason for the duplicate data is an improper...
Pentaho How to Show all Values in Filter Controls in OLAP Cube By Mounika There is an option of filtering for the values in OLAP Cube. When we pull a level to filter, then it shows a filter control where around first 200 values of the level are listed in enterprise edition of Pentaho....
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...