The process of setting up the i2b2 to use multiple fact tables is straight forward. Once you have updated your software to at least version 1.7.0912 or higher, created create your new fact tables and loaded the data into them there are only two remaining steps.
- Update the terms in your metadata tables so the i2b2 server knows what fact table to query
- Turn the Multi-fact table feature feature on in the crc.properties file
- hive_cell_params table. Refer to Multi-fact table home