Index

A B C D E F H I K L M N O P Q R S T U V W

A

about

Oracle BI Answers, 3.5

presentation variables, 3.5.4.1

repository variables, 3.5.4.1

security in OCDA, 6.1

session variables, 3.5.4.1

variables, 3.5.4.1

accessing

OCDA, 2.2

requests, 3.5.2.1

subject areas, 3.5.2.1

tabs in workspace, 3.5.2.2

action links, 3.3

adding, new data source, 5.1.1

Approval & Verification Rates - Worst 25 reports, A.2.1

architecture

ETL programs, 5.1

OCDA, 1.2

Average Days from Complete to Initially Approved - Top 25 report, A.2.2

Average Days from Complete to Initially Verified - Top 25 report, A.2.3

Average Duration in Categorized Discrepancy Review Status report, A.2.4, A.2.6

Average Duration of Currently Open Discrepancies, by Site report, A.2.5

B

bulk and normal load

about, 5.1

setting up, 5.8

bulk load, 5.1

C

cache, definition, 2.4.7

changing criteria, 3.5.2.4

CO - Document Management

dashboard, A.1.1

dashboard pages, A.1.1.1

Document Collection Cycle Times, A.1.1.1.2

Document List, A.1.1.1.1

CO - Site and Recruitment

dashboard pages, A.1.2.1

CO - Site and Recruitment Overview

dashboard, A.1.2

dashboard pages

Comparative Site Enrollment, A.1.2.1.2

Enrollment Overview, A.1.2.1.5

Randomization Overview, A.1.2.1.6

Screen Failure Overview, A.1.2.1.4

Screening Overview, A.1.2.1.3

Site Status Overview, A.1.2.1.1

Subject Recruitment Over Time, A.1.2.1.7

CO - Study and Region Overview

dashboard, A.1.3

CO - Subject Retention

dashboard, A.1.4

dashboard pages, A.1.4.1

Early Termination Overview, A.1.4.1.2

Subject Retention Over Time, A.1.4.1.3

Subject Retention Overview, A.1.4.1.1

Comparative Site Enrollment

CO - Site and Recruitment Overview, A.1.2.1.2

Comparative Site Enrollment Status Table, A.2.7

Count of Currently Open Discrepancies by CRF and Type - Top 10 by Rank report, A.2.8

Counts of Categorized Open Discrepancies, by Review Status report, A.2.9

Counts of Discrepancies, by State and Review Status report, A.2.10

Counts of Open Multivariate Discrepancies, by Procedure report, A.2.11

CRA EDC

dashboard, A.1.5

dashboard pages, A.1.3.1, A.1.5.1

Discrepancy Workload, A.1.5.1.5

eCRF Workload, A.1.3.1.2, A.1.5.1.2

Home, A.1.3.1.1, A.1.5.1.1

Key Rates, A.1.5.1.3

Performance, A.1.5.1.4

creating

ETL programs, 5.4

requests, 3.5.2, 3.5.2.3, 3.5.2.4

custom reports in OCDA, 3.2

customizing ETL programs, 5.3

D

dashboard pages

CO - Document Management, A.1.1.1

Document Collection Cycle Times, A.1.1.1.2

Document List, A.1.1.1.1

CO - Site and Recruitment, A.1.2.1

CO - Site and Recruitment Overview

Comparative Site Enrollment, A.1.2.1.2

Enrollment Overview, A.1.2.1.5

Randomization Overview, A.1.2.1.6

Screen Failure Overview, A.1.2.1.4

Screening Overview, A.1.2.1.3

Site Status Overview, A.1.2.1.1

Subject Recruitment Over Time, A.1.2.1.7

CO - Subject Retention, A.1.4.1

Early Termination Overview, A.1.4.1.2

Subject Retention Over Time, A.1.4.1.3

Subject Retention Overview, A.1.4.1.1

CRA EDC, A.1.3.1, A.1.5.1

Discrepancy Workload, A.1.5.1.5

eCRF Workload, A.1.3.1.2, A.1.5.1.2

Home, A.1.3.1.1, A.1.5.1.1

Key Rates, A.1.5.1.3

Performance, A.1.5.1.4

definition, 2.1

DM EDC, A.1.6.1

Discrepancy Workload, A.1.6.1.3

eCRF Workload, A.1.6.1.2

Home, A.1.6.1.1

Key Rates, A.1.6.1.5

Performance, A.1.6.1.6

Quality, A.1.6.1.4

Study Discrepancies, A.1.6.1.7

Study Processing Detail, A.1.6.1.9

Study Processing Summary Page, A.1.6.1.8

DM Paper, A.1.7.1

Home, A.1.7.1.1

Page Workload, A.1.7.1.2

Performance, A.1.7.1.5

Quality, A.1.7.1.4

Study Processing Detail, A.1.7.1.7

Study Processing Summary, A.1.7.1.6

emailing, 2.4.5

dashboards

about, A.1

CO - Document Management, A.1.1

CO - Site and Recruitment Overview, A.1.2

CO - Study and Region Overview, A.1.3

CO - Subject Retention, A.1.4

CRA EDC, A.1.5

definition, 2.1

display values using variables, 3.5.4

DM EDC, A.1.6

DM Paper, A.1.7

embedding requests, 3.5.3

printing, 2.4.4

refreshing, 2.4.7

viewing, 2.2.2

viewing descriptions, 2.4.2

data tracking

See tracking data

data warehouse

maintaining, 4.2

data warehouse tables, modifying, 4.2.4

derivations

about, 4.2.1

definition, 4.2

descriptions of dashboards and requests, viewing, 2.4.2

dimensions in the presentation catalog, B.1

Discrepancies per Pages Entered - 25 highest rates, A.2.12

Discrepancies per Subjects Enrolled - Top 25 report, A.2.13

Discrepancy Overview with Ratios report, A.2.14

Discrepancy Workload

CRA EDC dashboard page, A.1.5.1.5

DM EDC dashboard page, A.1.6.1.3

displaying values in results and dashboards, 3.5.4

DM EDC

dashboard, A.1.6

dashboard pages, A.1.6.1

Discrepancy Workload, A.1.6.1.3

eCRF Workload, A.1.6.1.2

Home, A.1.6.1.1

Key Rates, A.1.6.1.5

Performance, A.1.6.1.6

Quality, A.1.6.1.4

Study Discrepancies, A.1.6.1.7

Study Processing Detail, A.1.6.1.9

Study Processing Summary, A.1.6.1.8

DM Paper

dashboard, A.1.7

dashboard pages, A.1.7.1

Home, A.1.7.1.1

Page Workload, A.1.7.1.2

Performance, A.1.7.1.5

Quality, A.1.7.1.4

Study Processing Detail, A.1.7.1.7

Study Processing Summary, A.1.7.1.6

Document Collection Cycle Times

CO - Document Management dashboard page, A.1.1.1.2

Document Collection Cycle Times - Days Outstanding by Type, A.2.15

Document Collection Cycle Times Table, A.2.16

Document Collection Cycle Times -Turn Around Time by Type, A.2.17

Document List

CO - Document Management dashboard page, A.1.1.1.1

Documents List, A.2.18

domain structure, OCDA, 5.1.2

drilling down results, 2.5.4

E

Early Termination Overview

CO - Subject Retention dashboard page, A.1.4.1.2

eCRF Workload

CRA EDC dashboard page, A.1.3.1.2, A.1.5.1.2

DM EDC dashboard page, A.1.6.1.2

emailing dashboard page and request, 2.4.5

embedding

requests in a dashboard, 3.5.3

Enrollment Overview

CO - Site and Recruitment Overview, A.1.2.1.5

Enrollment Overview By Region Chart, A.2.19

Enrollment Overview By Site, A.2.20

Enrollment Progress Over Time, A.2.21

ETL programs

architecture, 5.1

creating, 5.4

customizing, 5.3

definition, 5

executing, 5.2

modifying, 5.5

one or more tables, 5.5

without changes to the associated tables or columns, 5.5

scheduling, 5.7

source-dependent extract (SDE)

definition, 5.1

source-independent loads (SIL)

definition, 5.1

version management, 1.4.2

executing ETL programs, 5.2

exiting, Oracle BI, 2.4.1

extensions

about, 4.2.2

definition, 4.2

F

facts in the presentation catalog, B.2

filters, definition, 2.1

H

Home

CRA EDC dashboard page, A.1.3.1.1, A.1.5.1.1

DM EDC dashboard page, A.1.6.1.1

DM Paper dashboard page, A.1.7.1.1

I

incremental load, 5.1

indexes, managing, 4.2.4

introducing, OCDA, 1.1

K

Key Cycle Times for Paper Studies report, A.2.22

Key EDC Cycle Times report, A.2.23

Key EDC processing volumes report, A.2.24

Key Paper processing volumes reports, A.2.25

Key Rates

CRA EDC dashboard page, A.1.5.1.3

DM EDC dashboard page, A.1.6.1.5

L

List Discrepancy Details report, A.2.26

Listing of Subject-Pages, Awaiting EDC Processing report, A.2.27

Listing of Subject-Pages, Awaiting Paper Processing report, A.2.28

load

bulk, 5.1

incremental, 5.1

normal, 5.1

logging in, OCDA, 2.2.1

logging out, Oracle BI See exiting, Oracle BI

Low Approved to Entered Rate - Worst 25 report, A.2.29

Low Verified to Entered Rate - Worst 25 report, A.2.30

M

maintaining

data warehouse, 4.2

repository, 4.1

managing ETL versions, 1.4.2

managing indexes, 4.2.4

modifying

criteria See changing criteria

data warehouse tables, 4.2.4

ETL programs, 5.5

one or more tables without changes to the associated ETL programs, 5.5

without changes to the associated tables or columns, 5.5

requests, 3.5.2

My Account page, using, 2.6

N

navigation in Oracle BI, 2.5

normal load, 5.1

O

OCDA

about security, 6.1

accessing, 2.2

architecture, 1.2

custom reports, 3.2

domain structure in Oracle LSH, 5.1.2

logging in, 2.2.1

overview, 1.1

predefined reports, 3.1

online help, using, 2.4.3

Oracle BI

drilling down, 2.5.4

exiting, 2.4.1

navigating, 2.5

setting preferences, 2.6.1

setting time zone, 2.6.2

sorting table columns, 2.5.5

using, 2.3

Oracle BI Answers, 2.3.1.1

about, 3.5

accessing requests, 3.5.2.1

accessing subject areas, 3.5.2.1

accessing tabs in workspace, 3.5.2.2

refreshing selection pane, 3.5.2.6

start page, 3.5.1

using, 3.5.2

viewing results, 3.5.2.7

Oracle BI Delivers, 2.3.1.3

Oracle BI features links, using, 2.5.2

Oracle BI interactive dashboards, 2.3.1.2

Oracle BI pages, working, 2.5.3

Oracle BI Presentation Services, 2.3.1

Oracle BI Answers, 2.3.1.1

Oracle BI Delivers, 2.3.1.3

Oracle BI interactive dashboards, 2.3.1.2

Outstanding Documents by Category, Type, A.2.31

Overview

Randomization Overview

CO - Site and Recruitment Overview, A.1.2.1.6

Subject Recruitment Over Time

CO - Site and Recruitment Overview, A.1.2.1.7

overview, OCDA, 1.1

overview, using OCDA, 2.1

P

Page Workload, DM Paper dashboard page, A.1.7.1.2

pages

See dashboard pages, definition

Pages Awaiting Entry Completion report, A.2.32

panes, definition, 2.5.3

Paper Processing Cycle Times - 25 Longest report, A.2.33

parameters, definition, 2.1

patches, Preface

Patient Retention Table, A.2.34

Performance

CRA EDC dashboard page, A.1.5.1.4

DM EDC dashboard page, A.1.6.1.6

DM Paper dashboard page, A.1.7.1.5

Planned Sites vs. Sites Screening & Enrolling Chart (Bottom 10), A.2.35

Planned Sites vs. Sites Screening & Enrolling Chart (Top 10), A.2.36

predefined

reports, 3.1

variables, 3.5.4.5

predefined variables, referencing, 3.5.4.5

presentation catalog

dimensions, B.1

facts, B.2

oracle clinical sources, B.3.1

siebel clinical sources, B.4

presentation variables

syntax, 3.5.4.4

printing dashboards and requests, 2.4.4

prompts, definition, 3.1

Q

Quality

DM EDC dashboard page, A.1.6.1.4

DM Paper dashboard page, A.1.7.1.4

R

Randomization Overview By Region Chart, A.2.37

Randomization Overview By Site Table, A.2.38

referencing

predefined variables, 3.5.4.5

session variables, 3.5.4.2

refreshing

dashboards and requests, 2.4.7

information in selection pane, 2.4.8, 3.5.2.6

regulatory compliance, 1.4

data tracking, 1.4.1

ETL version management, 1.4.2

security, 1.4.3

reporting, using OCDA, 1.3

reports

Approval & Verification Rates - Worst 25, A.2.1

Average Days from Complete to Initially Approved - Top 25, A.2.2

Average Days from Complete to Initially Verified - Top 25, A.2.3

Average Duration in Categorized Discrepancy Review Status, A.2.4

Average Duration of Currently Open Discrepancies, by Site, A.2.5

Average Duration of Open Discrepancies in Review Statuses, A.2.6

Comparative Site Enrollment Status Table, A.2.7

Count of Currently Open Discrepancies by CRF and Type - Top 10 by Rank, A.2.8

Counts of Categorized Open Discrepancies, by Review Status, A.2.9

Counts of Discrepancies, by State and Review Status, A.2.10

Counts of Open Multivariate Discrepancies, by Procedure, A.2.11

custom, 3.2

defined, 2.1, 3.1

Discrepancies per Pages Entered - 25 highest rates, A.2.12

Discrepancies per Subjects Enrolled - Top 25, A.2.13

Discrepancy Overview with Ratios, A.2.14

Document Collection Cycle Times - Days Outstanding by Type, A.2.15

Document Collection Cycle Times Table, A.2.16

Document Collection Cycle Times -Turn Around Time by Type, A.2.17

Documents List, A.2.18

Enrollment Overview By Region Chart, A.2.19

Enrollment Overview By Site, A.2.20

Enrollment Progress Over Time, A.2.21

Key Cycle Times for Paper Studies, A.2.22

Key EDC Cycle Times, A.2.23

Key EDC processing volumes, A.2.24

Key Paper processing volumes, A.2.25

List Discrepancy Details, A.2.26

Listing of Subject-Pages, Awaiting EDC Processing, A.2.27

Listing of Subject-Pages, Awaiting Paper Processing, A.2.28

Low Approved to Entered Rate - Worst 25, A.2.29

Low Verified to Entered Rate - Worst 25, A.2.30

Outstanding Documents by Category, Type, A.2.31

Pages Awaiting Entry Completion, A.2.32

Paper Processing Cycle Times - 25 Longest, A.2.33

parameters, 2.1

Patient Retention Table, A.2.34

Planned Sites vs. Sites Screening & Enrolling Chart (Bottom 10), A.2.35

Planned Sites vs. Sites Screening & Enrolling Chart (Top 10), A.2.36

predefined, 3.1

Randomization Overview By Region Chart, A.2.37

Randomization Overview By Site Table, A.2.38

request, 2.1

Screen Failure Reason by Site Chart, A.2.39

Screen Failure Reason Chart, A.2.40

Screen Failure Reason Counts by Site Table, A.2.41

Screening Overview By Region Chart, A.2.42

Site Detail Table, A.2.43

Site Status by Region Chart, A.2.44

Subject Retention Over Time, A.2.45

Subjects who Failed Screening Table, A.2.46

Subjects Withdrawn List Table, A.2.47

Summary of Subjects Awaiting EDC Processing, A.2.48

Summary of Subjects Awaiting Paper Processing, A.2.49

view, 3.1.1

view on Apple iPhone, 3.4

Withdrawn Reason Chart, A.2.50

Withdrawn Reason Counts by Site Table, A.2.51

Withdrawn Reason Overview Chart (Top 10 # Early Terms), A.2.52

repository variables

about, 3.5.4.1

syntax, 3.5.4.4

repository, maintaining, 4.1

request

emailing, 2.4.5

searching, 3.5.2.1

requests

creating, 3.5.2, 3.5.2.3, 3.5.2.4

embedding in a dashboard, 3.5.3

modifying, 3.5.2

printing, 2.4.4

refreshing, 2.4.7

running, 3.5.2.3

saving, 3.5.2

saving to personal or shared folder, 3.5.2.8

sort order, 3.5.2.5

viewing descriptions, 2.4.2

required

user groups in Oracle LSH, 6.3.2

results

display values using variables, 3.5.4

downloading, downloading results, 2.4.6

viewing, 3.5.2.7

running, requests, 3.5.2.3

S

saving

requests, 3.5.2, 3.5.2.8

scheduling

ETL programs, 5.7

Screen Failure Overview

CO - Site and Recruitment Overview, A.1.2.1.4

Screen Failure Reason by Site Chart, A.2.39

Screen Failure Reason Chart, A.2.40

Screen Failure Reason Counts by Site Table, A.2.41

Screening Overview

CO - Site and Recruitment Overview, A.1.2.1.3

Screening Overview By Region Chart, A.2.42

searching, request, 3.5.2.1

security, 1.4.3

selection pane

refreshing, 3.5.2.6

selection pane, definition, 2.5.3, 3.5.2.1

session variables

about, 3.5.4.1, 3.5.4.1

referencing, 3.5.4.2

syntax, 3.5.4.3

setting preferences, Oracle BI, 2.6.1

setting time zone, Oracle BI, 2.6.2

setting up table processing type, 5.8

Site Detail Table, A.2.43

Site Status by Region Chart, A.2.44

Site Status Overview

CO - Site and Recruitment Overview dashboard page, A.1.2.1.1

sorting table columns in Oracle BI, 2.5.5

source-dependent extract (SDE)

definition, 5.1

features, 5.1

source-independent load (SIL)

features, 5.1

source-independent loads (SIL)

definition, 5.1

specifying sort order, 3.5.2.5

start page, Oracle BI answers, 3.5.1

Study Discrepancies

DM EDC dashboard page, A.1.6.1.7

Study Processing Detail

DM EDC dashboard page, A.1.6.1.9

DM Paper dashboard page, A.1.7.1.7

Study Processing Summary

DM EDC dashboard page, A.1.6.1.8

DM Paper dashboard page, A.1.7.1.6

Subject Retention Over Time, A.2.45

CO - Subject Retention dashboard page, A.1.4.1.3

Subject Retention Overview

CO - Subject Retention dashboard page, A.1.4.1.1

Subjects who Failed Screening Table, A.2.46

Subjects Withdrawn List Table, A.2.47

substitutions

about, 4.2.3

definition, 4.2

Summary of Subjects Awaiting EDC Processing report, A.2.48

Summary of Subjects Awaiting Paper Processing report, A.2.49

syntax

presentation variables, 3.5.4.4

repository variables, 3.5.4.4

session variables, 3.5.4.3

T

tracking data, 1.4.1

U

using

My Account Page, 2.6

Oracle BI, 2.3

Oracle BI Answers, 3.5.2

variables, 3.5.4

using OCDA, 2.1

using online help, 2.4.3

using Oracle BI features links, 2.5.2

V

variables

display values, 3.5.4

presentation, 3.5.4

repository, 3.5.4

session, 3.5.4

using, 3.5.4

viewing

dashboards, 2.2.2

descriptions of dashboards and requests, 2.4.2

predefined reports, 3.1.1

reports on Apple iPhone, 3.4

results, 3.5.2.7

saved requests, 3.5.2.1

W

what can i do using Oracle Clinical Development Analytics, 1.1.1

what is available to you after accessing Oracle BI, 2.5.1

Withdrawn Reason Chart, A.2.50

Withdrawn Reason Counts by Site Table, A.2.51

Withdrawn Reason Overview Chart (Top 10 # Early Terms), A.2.52

working

Oracle BI pages, 2.5.3