Icon

01.Deploying Schedule - Exercise

<p>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.</p>

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


PULL FOR THE 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.


Part 1 - KNIME Business Hub

Exercise 01 Deploying a 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 folder Part 1 to your space on KNIME Business Hub. Make sure to include the workflows and the data.

  3. Version the workflow on KNIME Business Hub.

  4. Schedule an execution of this workflow:

    • 2 min later, send yourself a notification on successful/unsuccessful execution,

    • In Advanced settings, select the User execution scope, and create the deployment

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

  6. It's time to fix the bug! Edit the local copy of the workflow and upload the fixed version to KNIME Business Hub. Create a new workflow version.

  7. Schedule the workflow again on KNIME Business Hub and check the produced results. Remember to set the execution scope to User in the advanced settings!

Groups: Quarter, YearPivot: StoreTypeAggregation: sum of Price
Pivot
Group Loop Start
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
Readingcustomer transactiondata
Excel Reader
Setting the size andthe orientation ofthe report
Report Template Creator
Create a new column as a combination:"Year/Quarter"
Expression
Saving the reportas a PDF file
Report PDF Writer
Mountpoint Connector

Nodes

Extensions

Links