How do I determine if a report is pulling data from the Data Warehouse (ETL driven) versus real-time from the operational data?
Report performance questions can be answered by looking at the report “Cover Page” on all StateWide reports. Under the “Summary of each Query” section is information on which source the data is being pulled from. If the Universe name begins with O, such as OFIN – Financial Document Catalog. The data is being pulled directly from the operational database. An example of an ETL driven source would be FIN – Accounts Payable.