Projekt der SAPERION AG Qlik Tech

Projekt der SAPERION AG / Qlik. Tech / FH JOANNEUM 5. Expertengespräch in Regensburg June 26 th, 2007

Agenda • • • About me Motivation Architectural Concept Qlik. View Prototype Architecture Business Motivation Workflow Scenarios Showcase Outlook 5. Expertengespräch in Regensburg June 26 th, 2007 2

About Me • Name: Gottfried Jocham • Born: 1983 • Profession: Student at University of applied sciences (FH) JOANNEUM in Graz/Austria • Course of Studies: Information Management • Diploma Thesis: BAM Management Dashboard • Thesis Supervisors: o Prof. Dr. Erwin Zinser (FH JOANNEUM) o DI (FH) Christian Reibnegger (FH JOANNEUM) o Dr. Martin Bartonitz (SAPERION) 5. Expertengespräch in Regensburg June 26 th, 2007 3

Motivation • SAPERION o Visualization of SAPERION Workflow Statistics o Dashboard Functionality with Qlik. Tech™ Qlik. View • FH JOANNEUM o Implementation of theoretical BAM experience - Architectural Concept - Procedure Model o International cooperation/partnership with innovative companies 5. Expertengespräch in Regensburg June 26 th, 2007 4

Architectural Concept Event Display and Activities Event Processing Engine Event Channel Prozess Konfiguration Coral 8 Server Business Rules Engine Stream. Base Server Business Rules Engine Common Base Event Format Event Source Biz. Talk Agenten 5. Expertengespräch in Regensburg June 26 th, 2007 BTS 2006 Rule. Core Event Engine BTS 2006 MS Operations Manager Source: Reibnegger 5

Qlik. View • In Memory Business Intelligence Solution • Data Sources o ODBC – OLEDB Sources o Text or Database files (csv, xls, xml, …) • Execution of Load Script • Field Association by Qlik. View • Highly compressed and optimized Storage in *. qvw Files 5. Expertengespräch in Regensburg June 26 th, 2007 6

Prototype Architecture Event Display and Activities Event Processing Engine Chart & Table Engine Selection Engine Event Channel In Memory Data Model ODBC Event Source 5. Expertengespräch in Regensburg June 26 th, 2007 7

Business Motivation • No „user friendly“ Workflow Monitoring capabilities in SAPERION • Timely Information about current workflows o Incremental Data Loading • Alerts to inform about threshold exceeding 5. Expertengespräch in Regensburg June 26 th, 2007 8

Workflow Scenarios Forward Pull from Groupbox Forward Pushfrom Groupbox Pull into Forward 2. Rework 3. Reject Additional Delay! Loop! 4. User not push into Escalation Automated Available Userbox 4 Possibilities 1. End 5. Expertengespräch in Regensburg June 26 th, 2007 9

Showcase • Workflow Instances monitored o Quality of Service o Duration - Total - Per Activity o Loops o Exceptional Behavior o Bottlenecks • Threshold exceeding of Workflow instance o Alert and Mail 5. Expertengespräch in Regensburg June 26 th, 2007 10

Outlook • Planned work o Extension of Rules o Role based views • Further improvements o Extension of the two middle layers - Message Bus - Rule Engine Recognition of patterns in Workflow Data o Next SAPERION Release: SAPERION SNMP capabilities for System Monitoring 5. Expertengespräch in Regensburg June 26 th, 2007 11

Thank you for your attention • Gottfried Jocham o gottfried. jocham. ima 03@fh-joanneum. at • Christian Reibnegger o christian. reibnegger@fh-joanneum. at • Erwin Zinser o erwin. zinser@fh-joanneum. at 5. Expertengespräch in Regensburg June 26 th, 2007 12