Using SiGNAL in SAP Signavio Process Intelligence
Our lesson will start by looking at a business case process that we can use as our example throughout the lesson. This process is based on a simplified Order to Cash scenario at an international company that sells high quality, fair-trade T-shirts with prints on it. The customer can either order a pre-printed shirt from the online shop or can chose a custom print. In both cases, a prepayment is required before the order gets shipped.
The image shows the BPMN diagram of the Order to Cash process.
- The dataset consists of events and attributes.
- Events in our dataset represent the activities that are executed in our Order to Cash process. The event log therefore shows the individual activities such as Receive Payment, Print T-shirt, etc. The attributes dataset contains additional information such as order status, customer type, type of goods, etc.
- The dataset is needed to analyze the process with the events and the attributes.
- In the hands-on exercise, we will use the dataset to analyze SiGNAL data such as number of orders of T-shirts, payment type and many other data.
Access to SiGNAL
Get Your Own 30-day Trial Version!
Feel free to register for a free 30-day trial version and explore the SAP Signavio Process Intelligence (and other products of SAP Signavio Business Transformation Suite). No credit card or payment is required. With your trial license, you can implement the practical exercise directly in SAP Signavio.
Download Exercise Worksheet (Optional)
Download the Exercise Worksheet to solve the tasks after the course. After completing the chapters in the course, you will be able to solve the exercises on your own.
As the import of data is not included in the 30-days trial version, we can provide the data set upon request if you have purchased SAP Signavio Process Intelligence licenses. To get the access to the data set up, contact email@example.com. The team will provide you with the data set. However, the training can also be successfully accomplished without the data set and the completed Case Study. Thank you!
SIGN (SIGNAVIO) A (Analytics) L (Language)
SiGNAL is SAP Signavio's dedicated query language for process analytics. It provides an editable backend to:
- Create more in-depth process queries
- Retrieve data and perform calculations
- Visualize your results in detailed charts
The advantage of SiGNAL is its flexibility and extensibility. You can use the data from:
- SAP Signavio Suite (models and dictionary content, hub usage, workflows, etc.)
- External systems
- Machine learning models
- Simulation scenarios
With SiGNAL it's possible to get data visualizations of your results. Queries can be run for process-related behavior and KPI computation. SiGNAL is a SQL-oriented language, which makes it more familiar and easier to learn.
The SiGNAL Mining Engine is a cloud-based in-memory query engine that can process large event logs in real-time.
Mining at Scale
How does SiGNAL work?
The interaction below shows all the functions offered for SiGNAL. Don't get overwhelmed by the amount of functions! Once you begin using it, you will see which ones are commonly used for your organization.
With SiGNAL, simple as well as complex queries can be created. Let's have a look on a more complex one, to show you what functions SiGNAL supports.
VP Commentary on SiGNAL
To see what our Product VP for Process Intelligence has to say about SiGNAL, watch the video.
In the next lesson, we'll compare SiGNAL to SQL.
SiGNAL vs. SQL
How is SiGNAL different from SQL?
The difference between SiGNAL and SQL is the data model. With SQL, you query the data from multiple tables. However, SiGNAL queries the data from only one table, which contains nested events. Additionally, SiGNAL provides custom functions to work more effectively with this data structure.
SiGNAL vs SQL
- SiGNAL is not able to create inner joins like SQL.
- SiGNAL is not in data table format! This means that no data records can be deleted, written, moved, or changed.
- SiGNAL is used to start queries, we only use the data from the tables, we do not change them, we retrieve the data to perform analysis.
Great! So far, so good! In the next lesson, we will learn the basics of creating simple queries.
What is a Query?
A query is a request for information. In computer programming, a query is also a request for information, except the information that is requested comes from a database. You can manipulate data with queries, so you can add, delete, or change data from database tables.
It's not easy to write a query. In order to do this, you need to know a predefined code that the database understands in order to manipulate the data. This code is called the query language.
For database management, the standard query language is the Structured Query Language (SQL). Of course there are different languages, such as AQL and DMX, but SQL is the most popular.
The following hints may help you create queries faster and keep them comprehensible.
Helpful Hints for Creating Queries
Next, let's take a deeper look at the data models for queries.
Cases, Attributes, Events
end_time are always present. Case attributes like Customer ID, Status, and City have the same value throughout the case. An additional event attribute, such as Payment method, can have different values for each event.
There are two ways to use this data:
- Per case: Each case is treated as one row. The nested events and event attributes are represented as a nested table.
- Per event: Each event is treated as one row. The case ID and case attributes are repeated for each event.
The Data Type column defines which value the column can hold. All data types can occur on both case level and event level (nested).
SiGNAL supports the data types shown.
All of these data types can appear in the source file and in the query result.
Both case and event attributes can be Null, indicating the absence of a value or an unknown value.
The Syntax of SiGNAL is SQL oriented but includes extensions:
FROMtable or process
SELECT statement is used to select data from a process. The data returned is the result set. The
FROM clause produces the tabular structure – the starting set of data on which all other operations in a
SELECT statement are performed. The
WHERE statement is used to filter the records and to set conditions.
Let's look at an example. The image below shows a query for the number of canceled orders by Premium Customers. This is the type of query you can type in SiGNAL to obtain your data results and visualizations.
How can we use the data model for creating queries to analyze our processes?
When mining the data of a process, you retrieve the data of a single table. This table contains the case attributes and their events.
The following table shows this structure:
Using the Data Model to Create Queries - Example 1
Using the Data Model to Create Queries - Example 2
Using SiGNAL Functions and Operators
SiGNAL - Functions
SiGNAL supports a variety of aggregation functions.