Analytic Reports

General:

• Charts will always tell you if the data is current returns’ data or trend report.
• Output file includes the “raw data” outputs from the Tabular database (which are the sources in the analytic output file dashboards/reports).
  • Name conversion of raw data sheets works like the first part of the name is QRTs which data is included. For example, S.06.02.xx_augmntd means that it is data from S.06.02 (and xx means that all S.06.02 QRTs are included).
• It is not available to modify charts, however you can create your own charts based on the same “raw data” sheets by linking to these sheets from a separate Excel file.
  

There are six dashboards/reports currently supported:

Investments (dashboard)
Investments dashboard is sourced from S(E).06.02 and S.06.03, note other investments QRTs are currently not in scope.

Underwriting performance and technical provisions (dashboard)
Split into Life and Non-Life lines of business reports.
These dashboards are sourced from S.05.01, S.12.01 and S.17.01 QRTs

Summary financials (report)
Pulling key data from across each of the main Balance sheet, Own Funds, Technical account and SCR/MCR QRTs.
There is ability to drill down into some of these sections (unhide next to the Excel data group icon).

Balance sheet and Own funds (dashboard)
This is sourced from S(E).02.01 and S.23.01 QRTs

SCR and MCR (dashboard)
This is sourced from S.23.01, S.25.01 and S.26’s QRTs. Note only Standard formula QRTs are currently supported.