Icon

1. Projects_​BIRT

KBL: Producing data for BIRT
Workflow: Projects_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 report the money allocated, the moneyspent and the money remaining for each projecteach year. Calculating money spent for each project each year Calculating money in busget for each project each year Calculating money remaining for eachproject each year Projects filefrom KBLdatafoldermoney by project by yearmoney chartrenaming"<year>+Sum(...)" intojust "used <year>"enaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneymoney tableby RowIDby RowIDNode 18money assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowID File Reader GroupBy Data to Report Column Rename Column Rename Remaining Money Data to Report Sorter Sorter Joiner Pivoting Pivoting RowID RowID Workflow: Projects_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 report the money allocated, the moneyspent and the money remaining for each projecteach year. Calculating money spent for each project each year Calculating money in busget for each project each year Calculating money remaining for eachproject each year Projects filefrom KBLdatafoldermoney by project by yearmoney chartrenaming"<year>+Sum(...)" intojust "used <year>"enaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneymoney tableby RowIDby RowIDNode 18money assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowIDFile Reader GroupBy Data to Report Column Rename Column Rename Remaining Money Data to Report Sorter Sorter Joiner Pivoting Pivoting RowID RowID

Nodes

Extensions

Links