Please join your peers on either March 26 (8pm GMT) or March 28 (8am GMT) to watch as user extraordinaire and forum legend @"lindsay.stevens" demonstrates OpenClinica Insight.

See preview and register at

Insight makes it easy to ask questions of ALL of your clinical and operational data and visualize answers via interactive reports and dashboards. The idea is simple, but the results are powerful: ask your questions, choose your visualizations, then return often for updated, interactive results that link you to all of the underlying data.

live reporting sqldatamart



  • lindsay.stevenslindsay.stevens Posts: 403 ✭✭✭
    via Email
    @huamanzhu, the 20 views in DM schema is correct.

    I'm guessing the 22 refers to the example output screenshot. That is of a
    study schema, and is actually out of date so I've replaced it. Study
    schemas will have 17 matviews + 1 matview and 1 view for each item group in
    the study. So if you have 4 item groups you'll have 17 + 4 + 4 = 25 objects.

    The default_study and xxx schemas would be study schemas. Do you have
    studies with these names in OpenClinica?

    The public schema is the default schema created by postgres when a new
    database is made.

    I've added a section to the Introduction page of the wiki which describes
    in more detail what the expected output is.
  • huamanzhuhuamanzhu Posts: 50
    yes,I have two studies in openclinica,xiexie(thanks) @lindsay.stevens
  • ebsebs Posts: 119 ✭✭
    FYI, if you see "FATAL: role "oc" does not exist" in the log file try simplifying the password for the ocdm_fdw role. My original contained ^% characters which seemed to cause the issue.

    Thanks for the extension @lindsay.stevens
This discussion has been closed.