Icon

01. Deploying_​Schedule_​Solution

Report Builder

This workflow reads customer sale data and builds a multi-page reports with insights for each customer group.

The workflow is ready to be deployed as a schedule and run at specific intervals e.g. once a week.


KNIME Business Hub

Exercise Deploying_Schedule

Learning objective: In this exercise you will learn how to move a workflow to production in KNIME Business Hub.


Workflow description: This workflow asks you to upload a report builder workflow onto KNIME Business Hub, schedule an execution for it, fix a bug, version the fixed version, and then finally re-execute it.


You'll find the instructions to the exercises in the yellow annotations.

Step 1. Uploading the workflow to KNIME Business Hub

  1. Add the KNIME Business Hub mountpoint.

  2. Upload the workflow group Exercise to KNIME Business Hub, inside your space. Make sure to include the workflow and the data.

  3. Schedule an execution of this workflow (2 min later) and send yourself a notification on successfull/unsuccessful execution.

  4. (Spoiler) The workflow will fail. Open the workflow job on KNIME Business Hub and recognize the error

  5. It's time to fix the bug! Edit the local copy and upload the fixed version. Create a new space version via the browser UI.

  6. Execute again the workflow on KNIME Business Hub and check the produced results.

SOLUTION

The Reader node is configured with a LOCAL mountpoint relative path. Therefore, it works locally, but fail to find the path on the hub.
Change the path to workflow relative and select the Data folder with the path '../data/filename'

Readingcustomer transactiondata
Excel Reader
Groups: Quarter, YearPivot: StoreTypeAggregation: sum of Price
Pivot
Group Loop Start
Create a new column as a combination:"Year/Quarter"
String Manipulation
Replace missing valueswith zeros
Missing Value
Generating a reportwith a header anda stacked area chart
Quarterly Sale Trend
Processing the transactiondate column
Date&Time Processing
Renaming pivotcolumns
Column Renamer
Report Loop End
Setting the size andthe orientation ofthe report
Report Template Creator
Saving the reportas a PDF file
Report PDF Writer

Nodes

Extensions

Links