Reporting on Questionnaires

Detailed Reporting exclusively via Data Warehouse

Detailed Reporting on Questionnaires, i.e. reporting on individual Sections or Questions, will need to be done exclusively via the SAI360 BI, and the data warehouse database.

The technical reason behind this is that questionnaires details are stored in an "JSON construct" in the SAI360 database - a format designed to be read an interpreted by code, rather than by humans.

The BI ETL process converts this structure into a 'regular' table structure, which subsequently can be queried by SQL for reporting purposes.

To learn more about the BI Report Designer, please follow this link.

Questionnaire Table in the Data Warehouse

Here are some basic facts:

• The results of all Questionnaires are stored in the Datawarehouse table dw_data_questionnaires.
• The link to containing relationships needs to be established via the view rt_questionnaire.

  For example:

  
  

  This example would translate to the following SQL code:

  Select ...
FROM "rt_inspections"

  LEFT OUTER JOIN "rt_questionnaire" ON "rt_take_5"."dwk_checklists" = "rt_questionnaire"."dwi_questionnaire"

  RIGHT OUTER JOIN "dw_data_questionnaires" ON "rt_questionnaire"."dwi_questionnaire" = "dw_data_questionnaires"."dwk_questionnaire"