Prepackaged OBIEE Applications does not have a module for Clinical Analytics and so there is a need to develop a complete custom OBI application in order to accomplish the requirements. This was untill Oracle has introduced Oracle Clinical Development Analytics (CDA)which is based on OBIEE+

Nonclinical Use of Business Intelligence in Clinical TrialThere are a number of ways in which business intelligence as a technology platform can be used to support the pharmaceutical value chain. There is ample evidence to show how business intelligence has been used successfully in a number of areas including:

Sales and Marketing

Manufacturing

Finance

Human Resources

Information Services

Executive and Portfolio Management

Clinical Use of Business Intelligence in Clinical Trial
Within clinical research, the strongest use of technology is in pre-clinical research, clinical, statistical programming and supporting other groups such as:

Data management (patient profiles)

Medical writing

Finance

Project management

Patient registries and post-marketing surveillance

Without CDA an OBIEE architect needs to understand CRM data model and also the actual business process flow of a CTMS application.It is observed that usually there is a customization to an extent of 25% on the CRM application.

Original Old Article on OBIEE for CTMS which was the only Business Intelligence solutions for Clinical trial management before Oracle announced CDA is Available at http://www.obieetalk.com

Requirements gathering sessions must be interactive with group of SME’s, Team of members from business, project sponsors to mitigate any risk of
slipping the time lines. It is recommended to plan for regular client reviews and approvals of every build to avoid any gaps in the expectations by the client .

At a high level the reporting requirements may include tracking budget and finance, clinical trials, activities, investigators,Initiations, enrollments, expiration’s, terminations. Cross dimensional hierarchies from Program to Protocol to Site to Subject is commonly desired.

Major dimension tables specific to CTMS includes Program, Protocol,Site,Subject, application, Investigator. Other common dimensions include Accounts, Contacts, Activities, Time, Geography,product, etc.