SAP Knowledge Base Article - Public

3610843 - Why does my case attribute transformation have more rows than my event collector transformation?

Symptom

In a successful ETL/TL run in Process Intelligence, why does my Case Attribute Transformation have more rows than my Event Collector Transformation?

Cause

This is because cases are allowed to have or not have any related case attributes, while cases that do not contain any events are not included in the downstream analysis.

Resolution

If you believe that some event data is missing, please navigate to your source system to ensure that the data actually exists.

If the data does exist, please ensure that it was indeed extracted into Signavio Process Intelligence. You can test this by creating a test Data View in your Process Data Pipeline. Once created, you can search within the extracted data for specific records using an SQL script that includes WHERE clauses like:

SELECT * FROM <TABLE>
WHERE <identifying_column_name> = <identifying_value>

If the data is present in the Data View preview, you need to decide if your Transformation scripts include any modifications/customisations:

  1. If the scripts are part of a standard SAP template that was not customised, please reach out to SAP Sigavio Support and raise a case, referencing this article.
  2. If customisations were made, either remove them and revert back to the standard template, or reach out to our Signavio Consulting colleagues via your SAP Sales Representative for help fixing this issue.

If the data is not present, you need to do the same as above:

  1. If the extraction setup is part of a standard SAP template that was not customised, please reach out to SAP Sigavio Support and raise a case, referencing this article.
  2. If customisations were made to the extraction setup, either remove the customizations and revert back to the standard template, or reach out to our Signavio Consulting colleagues via your SAP Sales Representative for help fixing this issue.

Keywords

process, intelligence, soe, data, view, event, collector, transformation, attribute, more, row, record , KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , Problem

Product

SAP Signavio Process Intelligence 3.0