Icon

14_​Theobald_​meets_​SAP_​HANA

Will They Blend: SAP Theobald meets SAP Hana

This workflow calculates various Key Perfomance Indicators (KPI) based on sales data extracted from two SAP tables via Theobald and SAP Hana. The KPIs are, for example, the total number of orders monthly, average net weights monthly, and the most popular product for each year, among other things. These various indicators are wrapped together nicely to form an interactive dashboard with visualizations of the KPIs.

The data are provided by SAP as part of the Sales and Distribution module.

This workflow demonstrates how to load SAP tables into KNIME via Theobald using the SAP Reader (Theobald) node, as wellas via the legacy way of using SAP Hana with DB Connector node. Fetch sales tables from SAP Hana Fetch SAP sales tables via TheobaldEnter the Theobald URL and your SAP credentials here! Interactive dashboard containing various KPIs select table VBAKimport to KNIMEadd prefix to col headersadd prefix to col headersextractYear and Monthjoin both tables onVBELN columnextract sales order itemsVBAPconnect to SAP HanaEnter your SAP HANA credentials here DB Table Selector DB Reader Column Rename(Regex) Column Rename(Regex) Extract Date&TimeFields Joiner KPI Dashboard SAP Reader(Theobald) DB Connector This workflow demonstrates how to load SAP tables into KNIME via Theobald using the SAP Reader (Theobald) node, as wellas via the legacy way of using SAP Hana with DB Connector node. Fetch sales tables from SAP Hana Fetch SAP sales tables via TheobaldEnter the Theobald URL and your SAP credentials here! Interactive dashboard containing various KPIs select table VBAKimport to KNIMEadd prefix to col headersadd prefix to col headersextractYear and Monthjoin both tables onVBELN columnextract sales order itemsVBAPconnect to SAP HanaEnter your SAP HANA credentials hereDB Table Selector DB Reader Column Rename(Regex) Column Rename(Regex) Extract Date&TimeFields Joiner KPI Dashboard SAP Reader(Theobald) DB Connector

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: dewi
Created at: 2020-06-24
On NodePit since: 2020-11-16
Last update: 2024-11-21
Created with KNIME version: v4.2.0
Tags: sapsap hanatheobaldkpiwill they blendvisualization

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

Try NodePit Runner!