Profile cover photo
Profile photo
Sadakar Pochampalli
446 followers -
Software Engineer DWH-BI Specialist
Software Engineer DWH-BI Specialist

446 followers
About
Sadakar's posts

Post has attachment

Post has attachment
MySQL - different joins on multiple same value of field from two tables
create table logic_test(id int); insert into  logic_test values(1); insert into  logic_test values(1); select * from logic_test; /* # id '1' '1' */ create table logic_test2(id int); insert into  logic_test2 values(1); insert into  logic_test2 values(1); ins...

Post has attachment

Post has attachment
Tip : show parameter value in an alert in Table Component Click Action function in Pentaho CDE
Use below code to see what is the parameter values on dashboard in java script alert function. In my case, I needed to show it in Table Component Click action method and on confirmation I can pass it to drill down report. function f(){ var pDate=this.dashbo...

Post has attachment
Jaspersoft Custom Reports Testing Scenarios and Areas
Below are the few common Jasper Reports Testing Scenarios  General Browser UI 1) Verify the end-user is able to login with the credentials For example: biuser/biuser 2) Verify report layout as per the mock-up 3) Verify the title of the report – preferable t...

Post has attachment
Incorrect String value issue while loading text data from source MySQL to target MySQL

Post has attachment
Incorrect String value issue (\xC4 \x90 .... ) while loading data from MySQL source to MySQL target (utf-8, latin1 character set usecases)
In this post, you will learn how to fix special character issue while loading data from source MySQL to destination MySQL table. You may see below kinda of error during the ETL execution. Starting job Test at 18:17 24/04/2017. [statistics] connecting to soc...

Post has attachment
Line Graph Based on Multi Select Parameter in Pentaho CDE

Post has attachment
Line Graph Based on Multi Select Parameter in Pentaho CDE
In this example, one can learn how to make multi-select parameter values as series in Pentaho CCC line graph.  Display two lines when selected 2 values in drop down  Display 1 line when selected 1 value in drop down   Display 1 line when selected another 1 ...

Post has attachment
JFree Stacked Bar Chart Example in Jasper Design Studio
Wait while more posts are being loaded