Icon

01.Deploying Schedule - Solution

<p>This workflow asks you to upload a report builder workflow onto KNIME 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 Space relative path. Therefore, it works locally, but fails to find the path on the Hub.
Change the path to the file be relative to the workflow:
knime://knime.workflow/../Data/Customer_data.xlsx

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 Hub

Exercise 01 Deploying a Schedule

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


Workflow description: This workflow asks you to upload a report builder workflow onto KNIME 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 Hub

  1. Upload the folder Part 1 to one of your spaces on KNIME Hub. Make sure to include the workflows and the data.

  2. Version the workflow on KNIME Hub.

  3. 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

  4. (Spoiler) The workflow will fail. Inspect the job and recognize the error.

  5. It's time to fix the bug! Edit the workflow and create a new workflow version.

  6. Schedule the workflow again and check the produced results. Remember to set the execution scope to User in the advanced settings!

Readingcustomer transactiondata
Excel Reader
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
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

Nodes

Extensions

Links