Jeffrey Klann added a comment - 27/Apr/22 1:44 AM Multifact by creating a large view of all fact tables now supported in all platforms. Needs to be tested in Oracle and Postgres. To use with multi-fact setups: Create a fact table view as the union of all your fact tables. (This is essentially going back to a single fact table, but it is only used for totalnum counting. This is needed to correctly count patients that mention multiple fact tables within a hierarchy.)   e.g.,     create view observation_fact_view as        select * from CONDITION_VIEW       union all        select * from drug_view     And then run the totalnum counter on that fact table view.

Jeffrey Klann added a comment - 11/May/22 8:39 PM This needs to be tested in Oracle.

Reeta Metta added a comment - 14/Jun/22 2:46 PM verified only on sql server currently no db set up for oracle and postgres

Jeffrey Klann added a comment - 14/Jun/22 5:48 PM This has been tested on Oracle by Ngan Chau at UCLA.