Message-ID: <1832521618.7982.1711655190140.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7981_112270309.1711655190137" ------=_Part_7981_112270309.1711655190137 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The multi-fact table project is a new feature that has been added to ver= sion 1.7.09 of the i2b2. Prior to this release, the i2b2 star schema could = only support one fact table (observation_fact). We have noticed = an increasing need for the i2b2 to be able to search multiple fact tables w= ith a single query. The i2b2 server has been updated to allow those sites t= hat want to use multiple fact tables will have the option to do so.This new= feature enables the i2b2 to adapt to the needs of such projects as the Pat= ient Centered Outcome Research Institute (PCORI) network and the Observatio= nal Medical Outcomes Partnership (OMOP) Common Data Model (CDM). It can als= o be used for sites that want to be able to query both genomic and phenotyp= e data but don't want the data to reside in a single table.
Starting with 1.7.12 version, you can set multifacttable= parameter in hive_cell_para= ms table. Using SQL editor, update the param_name_cd qu= eryprocessor.multifacttable value to true
example Oracle syntax:= u>
Example Oracle syntax
=20UPDATE hive_cell_params
set value =3D'true' where param_name_cd =3D'queryprocessor.multifacttabl= e' and cell_id =3D'CRC';
Deprecated Feature
=20Prior to 1.7.12 , the par=
ameter =E2=80=9Cqueryprocessor.multifacttable=E2=80=9D was set in crc.properties file. The setting is now configurable in the dat=
abase.
Beginning in 1.7.12, the CRC prope= rties are in the database! See this link.<= /p>