What is the ReportInstance table used for?

David Registro shared this question 2 years ago
Answered

What is the ReportInstance table used for?

It seems to be one of the largest tables in the Yellowfin DB.

Comments (1)

photo
1

This table stores a record for each report, each time it is run or edited. If you run the same report multiple times, you will get multiple rows for that report in this table.

This is used for things like;

  • Getting 'average report run time' and also used,
  • Using the 'Remember Filter Values' option
  • Editing a report (the draft copy is a separate record so you can roll back to the original activated version),
  • KPI reporting


The following article may also provide some useful info if you wanted to take it a bit further.


Regards,

David