Performance Analytics - Reporting on sys_history_set

Matt B4
Tera Contributor

I am new to Performance Analytics and I am hoping to satisfy the following requirement: When members of a certain team (or teams) update a record, I want it to be counted in a report. I created an indicator on the sys_history_set table as follows:

 

find_real_file.png

 

I then have an automated indicator that filters this by the groups I'm hoping to report on. I did it this way in case other groups want to use this functionality. I have some questions:

 

  1. Will this work?
  2. Will this have a negative impact on system performance like it would using the normal report editor, or is it okay since it's a once daily data collection?
  3. Does PA collect data as a snapshot, or will the data change if members are added/removed to a team?

Thanks for any assistance,

Matt

1 ACCEPTED SOLUTION

Vishnu Prasad K
Giga Guru

Hi Matt,

 

  1. Will this work? - Yes
  2. Will this have a negative impact on system performance like it would using the normal report editor, or is it okay since it's a once daily data collection?  -  Will take a toll on system performance during the initial job run. Later as it collects daily snapshots, shouldn't be causing much to the impact (Depends on how many other jobs you have in the backend). Check it with live data dump, can't comment on performance without knowing the amount of data your system is handling.
  3. Does PA collect data as a snapshot, or will the data change if members are added/removed to a team?  -  It collects data as a snapshot.

View solution in original post

2 REPLIES 2

Vishnu Prasad K
Giga Guru

Hi Matt,

 

  1. Will this work? - Yes
  2. Will this have a negative impact on system performance like it would using the normal report editor, or is it okay since it's a once daily data collection?  -  Will take a toll on system performance during the initial job run. Later as it collects daily snapshots, shouldn't be causing much to the impact (Depends on how many other jobs you have in the backend). Check it with live data dump, can't comment on performance without knowing the amount of data your system is handling.
  3. Does PA collect data as a snapshot, or will the data change if members are added/removed to a team?  -  It collects data as a snapshot.

Thank you Vishnu - it did work and I was able to satisfy the requirement.