SAP Knowledge Base Article - Public

3419631 - Filtering of PI data regarding current year only

Symptom

In the PI filters (e.g. in the widgets) I can see only the possibility to set a date filter with a custom or rolling date range. I would like to have filters, which show me the data for a current year or last quarter etc. How can I archive it?

Resolution

On the dashboard level, you can use the 'advanced filter' type. Here, a SIGNAL condition can be set. 

  • Current year:
DATE_PART('year', (SELECT FIRST(TIME_POINT_DATA))) = DATE_PART('year', NOW()))
  • Last year:
DATE_PART('year', (SELECT FIRST(TIME_POINT_DATA))) = DATE_PART('year', NOW() - 1 ))

"TIME_POINT_DATA" refers to the attribute/data used to check the condition. 

See Also

Advanced filters: https://help.sap.com/docs/signavio-process-intelligence/user-guide-beta/available-filter-types?locale=en-US&q=filter#advanced-filter

DATE_PART SIGNAL function: https://help.sap.com/docs/signavio-process-intelligence/signal-guide/date-part

Keywords

SIGNAL, filter, advanced, current, date, year, month, quarter, data, widget , KBA , BPI-SIG-PI-INV , Investigations for SAP Signavio Process Intelligence , BPI-SIG-PI-SIG , SiGNAL for SAP Signavio Process Intelligence , BPI-SIG-PI-INT , Integration / Schedules / SQL Filter / Delta criteria , Problem

Product

SAP Signavio Process Manager all versions