Configure Data Sources
Update data lookup tables
CRC Properties Configuration
In order for the CRC to know there are multiple fact tables the queryprocessor.multifacttable property in the crc.properties file needs to be updated. By default this property is set to false, however for the i2b2 on OMOP project this needs to be set to true.
Property: queryprocessor.multifacttable
| Value | Behavior |
|---|---|
| false | The CRC will continue to work as it does in the classic i2b2. Only one fact table (observation_fact) will be queried |
| true | The CRC will query multiple fact tables as defined in the OMOP CDM version 5 |
Update crc.properties file
1. Open the crc.properties file and scroll to the section called Derived/Multi fact table parameter
2. Edit the queryprocessor.multifacttable property to tell the CRC to query multiple fact tables.
Project Management Cell
# Derived/Multi fact table parameter
queryprocessor.multifacttable=true
4. Save your changes and close the file.
