Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Tuesday, 21 March 2017

Tip : Pentaho PRD : Cascaded drop down parameter(s) in Pentaho Report Designer

Display the month names based on selected year.

Query-1 :  Extract Year  

    EXTRACT(YEAR FROM "DATE")::integer as year
FROM dimcalendar 

Query-2 : Extract Month From selected Year ( In some cases report needs to display till current month)

select DISTINCT to_char("DATE", 'Month')::text Mon from dimcalendar
where EXTRACT(YEAR FROM "DATE")::integer = ${paramYear}