Icon

Reporting_​w_​BIRT

KBL: Producing data for BIRT
Workflow: Reporting_w_BIRT In this workflow we prepare data to be displayedin a report.Starting from the accounting of a list of projects,on one branch we calculate the money in budgetfor each year for each one of the project and onthe other branch we calculate the money actuallyspent for each project each year.We then export the money allocated, the moneyspent and the money remaining for each projecteach year and build a report with the BIRTintegration within KNIME. Calculating money spent for each project each year Calculating money in busget for each project each year Calculating money remaining for eachproject each year money by project by yearmoney chartrenaming"<year>+Sum(...)" intojust "used <year>"enaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneymoney tableby RowIDby RowIDmoney assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowIDProjects.txt filewith path relative to"current workflow" GroupBy Data to Report Column Rename Column Rename Remaining Money Data to Report Sorter Sorter Pivoting Pivoting RowID RowID CSV Reader Joiner Workflow: Reporting_w_BIRT In this workflow we prepare data to be displayedin a report.Starting from the accounting of a list of projects,on one branch we calculate the money in budgetfor each year for each one of the project and onthe other branch we calculate the money actuallyspent for each project each year.We then export the money allocated, the moneyspent and the money remaining for each projecteach year and build a report with the BIRTintegration within KNIME. Calculating money spent for each project each year Calculating money in busget for each project each year Calculating money remaining for eachproject each year money by project by yearmoney chartrenaming"<year>+Sum(...)" intojust "used <year>"enaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneymoney tableby RowIDby RowIDmoney assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowIDProjects.txt filewith path relative to"current workflow"GroupBy Data to Report Column Rename Column Rename Remaining Money Data to Report Sorter Sorter Pivoting Pivoting RowID RowID CSV Reader Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2022-01-16
Last update: 2024-04-27
Created with KNIME version: v4.4.0
Tags: KNIMEPressEducationReportingPivotingAggregationBIRT

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!