What is the ReportInstance table used for?

David Registro shared this question ago

Answered

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

The same question

Replies (1)

David Registro ●

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

Reply URL