Multi-fact Table
Space shortcuts
Space Tools

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

CRC Properties Configuration

In order for the CRC to know there are multiple fact tables the queryprocessor.multifacttable property in the 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


falseThe CRC will continue to work as it does in the classic i2b2. Only one fact table (observation_fact) will be queried ("single" mode)
trueThe CRC will work in both modes; single or multiple fact tables.

Update file

1. Open the 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.


titleMulti-fact table parameter

# Derived/Multi fact table parameter



3. Save your changes and close the file.


<div class="i2b2-panel">
    <table class="i2b2-note">
            <col width="24">
                    <img src="" width="16" height="16" align="absmiddle" alt="info" border="0">
                    <br><br>If the above parameter does not exist in the file, then you will need to add it in order for the CRC to be able to query multiple fact tables.