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...
Business Intelligence Performance Improvements in Apache Drill By Satya Gopi Prerequisites: ApacheDrill We are firing a query in Apache drill it is easily taking 3 minutes for fetching just 1 column from a Table,so to overcome we have used to 2 Performance Improvements Partition Pruning Parquet meta data caching Partition...
Jaspersoft Splitting a Detail Band into 2 Columns or More in Jasper By Satya Gopi Prerequisites: JasperServer 6.4.2,Jasper Studio Databases: Foodmart Recently we have come across one requirement like one table has 2 columns and in the report itself we have lots of empty space, to eliminate that empty space we have printed the table's...
AWS Fetching AWS Glue Connection Details By Sai Kavya Sathineni There might be requirements where you have to fetch the details from the connection defined in AWS Glue Data Catalog and use them in your Glue job for connecting to the database (to store logs into database). Make data easy...
Jaspersoft How to Connect to KDB database in Jaspersoft By Mounika To Connect to KDB database in Jaspersoft follow the below steps: Open Jasper studio and create a data adapter. KDB requires a separate jar file called ‘jdbc.jar’.Below is the jar file. JDBC.jar file Include this jar file in Driver Classpath....
Databases Scheduling a Pipeline in Azure Data Factory By Satya Gopi Requirement: How to schedule a pipeline to run on a daily basis in Azure Data Factory Solution: Log into Azure Portal, Open existed pipeline in data factory On the top header we have Trigger option Click on Trigger and we...
Databases Connecting to On-Premises SQL Server in Azure Data Factory By Ramu Vudugula I have created a pipeline in Azure data factory. I want to copy data from SQL server hosted in my local machine. In Azure we can connect to any cloud services but we cannot connect on-premises sources. To achieve this...
Javascript Display a Progress Bar at Top of Webpage By admin Display a Progress bar at the top of your webpage which states how much user has scrolled with jQuery Prerequisites: Knowledge on HTML and jQuery In this blog we will be discussing how to get the percent of page a...
Databases Connecting Presto with Mongo 4.2 By admin This blog would explain how to connect Presto with Mongo 4.2 Prerequisites: Mongo 4.2 Presto 0.226 To create a connection between Presto and Mongo, follow below process: Make data easy with Helical Insight. Helical Insight is the world's best open...
Power BI Creating User Input Variables in a Power BI Report By admin Requirements: In a report, a user should have the flexibility to enter the input number and that number should filter the data. In Power BI reports, we can create slicer with input number and we have options to choose either...