Pentaho Cascading Filters in CDE Dashboard By admin This blog explains the process of cascading filters in CDE dashboard. Prerequisites: Foodmart database Pentaho 6.0.1.0.386 Consider the below dashboard with 2 filters i.e. Country and State.The requirement is that when we select a value in country drop down, State...
Pentaho Failed to Establish the VPN Connection By admin Warning - Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version I recently faced this issue while trying to connect to the VPN on version 6.2.0.0780 on Windows 8 Here are the...
Pentaho Create Custom Template in Pentaho Dashboard By admin This blog explains the process of creating a custom template in Pentaho Dashboard. Pentaho provides few templates in Pentaho dashboard by default. When we want to create a dashboard with template which is different from the existing, we need to...
Pentaho Transpose Rows to Columns using Pentaho Data Integration By Sohail Sample Data In the data given below, it is expected to pivot column Week from rows to columns. Following data is the number of vehicles sold by particular user in a week for two different user accounts. Make data easy...
Pentaho How to Add Filters in CDE Dashboard By Mounika This blog explains the process of adding filters to the dashboard and create a connection with parameters of the components in the dashboard. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool....
Pentaho Create CDE Dashboard with CCC Charts in Pentaho By Mounika This blog explains the process of creating a CDE dashboard in pentaho using CCC charts component. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Prerequisites: Foodmart database Pentaho 6.0.1.0.386 Below is...
Pentaho Export Mondrian Schema to Excel using PDI By Mounika This blog explains how to create a job in PDI which can export Mondrian schema which is in XML format to excel. Consider below a sample of Mondrian Schema: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <Schema name="TransactionType"> <Dimension highCardinality="false" name="Dim Customers" type="StandardDimension"...
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....