Skip Headers
Oracle® Health Sciences Mobile Clinical Research Associate Server Installation and Configuration Guide
Release 1.3
E38578-04
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Feedback page
Contact Us
Go to previous page
Previous		 Go to next page
Next
PDF · Mobi · ePub

3 Installing the OBIEE Tier

This section details the deployment of Mobile CRA Server - OCDA OBIEE repository (RPD) in the Mobile CRA Server environment.

This chapter includes the following sections:

For information about OBIEE and RPD in Oracle® Health Sciences Clinical Development Analytics (OHSCDA), see the following:

3.1 Creating Backup

Before deploying Mobile CRA Server OBIEE, back up all OBIEE catalogs, RPD, and security profiles.

3.2 Before Deploying Mobile Clinical Research Associate Server OBIEE Component

Before deploying Mobile CRA Server OBIEE component, ensure to collect the following files and DB user information:

3.3 Configuring OBIEE Admin User

To configure OBIEE admin user, perform the following:

  1. Log in to OBIEE server.

  2. Log in to WLS Enterprise Manager as admin by entering the URL using the server address in Step 1 (for example, http://<server:port number>/console).

  3. Click Security Realms.

  4. Select myrealm from the list.

    The Settings for myrealm screen is displayed in the right-side window panel.

  5. Click Users and Groups.

  6. Click Users tab and click New to create a user.

  7. Enter the name.

  8. Enter the description.

  9. Retain the default value in the Provider field.

  10. Enter a password of your choice.

  11. Re-enter the password in the Confirm Password field.

  12. Click OK to create the user.

  13. Assign groups to the user as follows:

    1. Click the user Mobile CRA-admin and select Groups.

    2. Assign Administrator and BI Administrator groups to the user.

  14. Click Save to save the user profile.

3.4 Configuring Mobile Clinical Research Associate Server Repository

To configure Mobile CRA Server RPD to point to Mobile CRA Server database, perform the following:

  1. Open the OBIEE Administration tool.

    Figure 3-1 OBIEE Administration Tool

    Description of Figure 3-1 follows
    Description of "Figure 3-1 OBIEE Administration Tool"

  2. Open MobileCRA_Server_01.rpd.

  3. Enter the password.

    Oracle recommends you to modify the password of the RPD provided by Oracle. To change the password, perform the following:

    • From the File menu, select Change Password.

    • Enter the old and new password in the respective fields.

  4. To configure Mobile CRA Server, navigate to the Physical tab, right-click on Mobile CRA Server Connection Pool, and choose Properties.

    Figure 3-2 Connection Pool Properties Screen 1

    Description of Figure 3-2 follows
    Description of "Figure 3-2 Connection Pool Properties Screen 1"

  5. Modify the data source name, user name, and password to the database user created for the Mobile CRA Server data model.

    • Enter the data source name in the following format:

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=<port>))(CONNECT_DATA=(SID=<oracle db sid>)))

    • Enter the user name and password for the Mobile CRA Server schema.

      Figure 3-3 Connection Pool Window Screen 2

      Description of Figure 3-3 follows
      Description of "Figure 3-3 Connection Pool Window Screen 2"

  6. Save the RPD file.

  7. Test your connections by viewing data on one of the tables in the datastore.

    Figure 3-4 Testing Connections

    Description of Figure 3-4 follows
    Description of "Figure 3-4 Testing Connections"

    For example, if you see data return, it indicates that your configuration is working.

  8. Click OK to save.

3.5 Upgrading OCDA Repository to Add Mobile Clinical Research Associate Server Rule Engine Data Source (Required for Installation with OCDA)

To upgrade OCDA repository to add Mobile CRA Server Rule engine data source, perform the following:

  1. Refer to Section 3.11, "Updating OCDA with Mobile Clinical Research Associate Server Rules Engine" for instructions.

  2. Save the created RPD as OCDA_MCRA_01.rpd.

3.6 Merging Repository

To merge RPD, perform the following:

  1. Take a backup of the following repository:

    • Updated version of OCDA repository (updated with Mobile CRA Server Rules Engine data source) OCDA_MCRE_01.rpd.

    • Mobile CRA Server Repository - MobileCRA_Server_01.rpd

  2. Open the updated OCDA RPD, that is OCDA_MCRA_01.rpd.

    Figure 3-5 Opening RPD

    Description of Figure 3-5 follows
    Description of "Figure 3-5 Opening RPD"

  3. From the File menu, select Merge.

    Figure 3-6 Selecting Merge Option

    Description of Figure 3-6 follows
    Description of "Figure 3-6 Selecting Merge Option"

    The Merge Repository Wizard is displayed.

  4. Select dummy.rpd in the Original Master Repository.

    Figure 3-7 Selecting Repository

    Description of Figure 3-7 follows
    Description of "Figure 3-7 Selecting Repository"

  5. Enter the repository password for the dummy repository.

  6. Select MobileCRA_Server_01.rpd in the Modified Repository.

  7. Enter the repository password for Mobile CRA Server repository.

  8. Retain Save Merged Repository as is and note down the saved merged repository name and location.

  9. Click Next.

    Figure 3-8 Selecting Input Files

    Description of Figure 3-8 follows
    Description of "Figure 3-8 Selecting Input Files"

    A screen is displayed which shows the conflicts.

  10. Click the Decision column in the conflict row and select Current.

    Figure 3-9 Defining Merge Strategy

    Description of Figure 3-9 follows
    Description of "Figure 3-9 Defining Merge Strategy"

  11. Click Next.

    The Merge Repository screen is displayed.

  12. Click Finish.

  13. Verify that the physical layer has Mobile CRA Server, Mobile CRA database, and OCDA data warehouse schemas available in the Physical section.

  14. Verify that the Mobile CRA Server and OCDA-DM are available in the Business Model and Mapping section.

  15. Open Dim - Study in OCDA-DM from the Business Model and Mapping section, and verify that the HSM_OBI_STUDY_VW is included in the source.

  16. Open Dim - Study-site in OCDA-DM from the Business Model and Mapping section, and verify that the HSM_OBI_STUDY_SITE_VW is included in the source.

  17. Verify that the Mobile CRA Server and OCDA are available in the Presentation section.

  18. Verify that the Mobile CRA Alert Engine, -Study, and -Study-site presentation tables are available under OCDA.

  19. Save the updated OCDA repository (for example as OCDA_MCRE_MCSV_01.rpd).

3.7 Deploying Updated OCDA Repository to OBIEE

To deploy updated OCDA RPD to OBIEE, perform the following:

  1. Log in to Enterprise Manager (for example, http://<server:port number>/em).

  2. Navigate to Business Intelligence and select Coreapplication.

  3. Navigate to Deployment tab, and then to the Repository subtab.

    Figure 3-10 Coreapplication Screen

    Description of Figure 3-10 follows
    Description of "Figure 3-10 Coreapplication Screen"

  4. Click Lock and Edit Configuration to lock the application.

  5. In the Upload BI Server Repository pane, choose the RPD file that you want to upload, and load the updated OCDA repository (for example, OCDA_MCRE_MCSV_01.rpd).

  6. Enter the password for updated OCDA repository.

  7. Re-enter the password for the updated OCDA repository in the Confirm Password field.

  8. Click Apply.

  9. Click Activate Change.

  10. Restart to apply recent changes.

  11. Restart all BI components.

    Figure 3-11 System Shutdown and Startup Screen

    Description of Figure 3-11 follows
    Description of "Figure 3-11 System Shutdown and Startup Screen"

  12. Click Yes in the Confirmation window.

    Once the restart is complete, a message is displayed indicating that the RPD deployment is complete.

3.8 Creating User to Access the New OCDA - Mobile Clinical Research Associate Server Repository

To create a user to access the new OCDA - Mobile CRA Server RPD, perform the following:

  1. Navigate to the Oracle WebLogic server (for example, http://<servername>/console/login/LoginForm.jsp).

  2. Navigate to Security Realms and select myrealm.

    The Settings for myrealms screen is displayed.

    Figure 3-12 Settings for myrealms Screen

    Description of Figure 3-12 follows
    Description of "Figure 3-12 Settings for myrealms Screen"

  3. Click Users and Groups.

  4. Click New in the Users subtab.

    Figure 3-13 Users Tab

    Description of Figure 3-13 follows
    Description of "Figure 3-13 Users Tab"

  5. Enter the OBIEE user name (for example, Mobile CRA-admin).

  6. Enter the OBIEE password.

  7. Click OK to create user.

  8. Assign groups to the user as follows:

    1. Select the newly created user Mobile CRA-admin and navigate to Groups.

    2. Assign groups to this user. For example, Administrator and BI Administrator.

  9. Click Save to save the user profile.

  10. Test the user by navigating to the OBIEE Analytics site (for example, http://<servername>/analytics).

  11. Enter the user name and password.

    You should be able to log in to OBIEE.

  12. Create a new analysis.

    If you see the following subject areas, it indicates that your RPD and user are configured and deployed correctly.

    Figure 3-14 Select Subject Area Screen

    Description of Figure 3-14 follows
    Description of "Figure 3-14 Select Subject Area Screen"

3.9 Deploying Mobile Clinical Research Associate Server Pre-defined Alert

To deploy Mobile CRA Server pre-defined alert, perform the following:

  1. Log in to the OBIEE Analytics.

  2. Navigate to Catalog.

    The Catalog Screen is displayed.

    Figure 3-15 Catalog Screen

    Description of Figure 3-15 follows
    Description of "Figure 3-15 Catalog Screen"

  3. Select Shared Folders and click Unarchive in the bottom-left Tasks menu.

    Figure 3-16 Tasks Menu

    Description of Figure 3-16 follows
    Description of "Figure 3-16 Tasks Menu"

  4. Click Browse and select the Mobile CRA.catalog file.

    Figure 3-17 Selecting the Mobile CRA.catalog File

    Description of Figure 3-17 follows
    Description of "Figure 3-17 Selecting the Mobile CRA.catalog File"

  5. Click OK to unarchive the catalog.

    Figure 3-18 Unarchive Window

    Description of Figure 3-18 follows
    Description of "Figure 3-18 Unarchive Window"

  6. Navigate to Shared Folders and select Mobile CRA to see the predefined alert imported.

    Figure 3-19 List of Predefined Alert Imported

    Description of Figure 3-19 follows
    Description of "Figure 3-19 List of Predefined Alert Imported"

3.10 Deploying Mobile Clinical Research Associate Server Reports Alert

To deploy Mobile CRA Server Reports alert, perform the following:

  1. Log in to the OBIEE Analytics.

  2. Navigate to Catalog.

    The Catalog Screen is displayed.

    Figure 3-20 Catalog Screen

    Description of Figure 3-20 follows
    Description of "Figure 3-20 Catalog Screen"

  3. Select Shared Folders and click Unarchive in the bottom-left Task menu.

    Figure 3-21 Tasks Menu

    Description of Figure 3-21 follows
    Description of "Figure 3-21 Tasks Menu"

  4. Click Browse and select the Mobile CRA.catalog file.

  5. Click OK to unarchive the catalog.

    Figure 3-22 Unarchive Window

    Description of Figure 3-22 follows
    Description of "Figure 3-22 Unarchive Window"

  6. Navigate to Shared Folders and select Mobile CRA to see the predefined alert imported.

    Figure 3-23 List of Predefined Alert Imported

    Description of Figure 3-23 follows
    Description of "Figure 3-23 List of Predefined Alert Imported"

3.11 Updating OCDA with Mobile Clinical Research Associate Server Rules Engine

This section contains the following topics:

3.11.1 Opening OCDA Repository

To open OCDA RPD, perform the following:

  1. Open the Oracle Business Intelligence Enterprise Edition Administration tool.

    Figure 3-24 Opening Administration Tool

    Description of Figure 3-24 follows
    Description of "Figure 3-24 Opening Administration Tool"

  2. Open the OCDA repository (for example, OCDA_21_final.rpd).

    Figure 3-25 Opening OCDA RPD

    Description of Figure 3-25 follows
    Description of "Figure 3-25 Opening OCDA RPD"

  3. Enter the repository password when prompted.

    OCDA RPD will be loaded in the OBIEE Administration tool.

    Figure 3-26 Loaded OCDA RPD

    Description of Figure 3-26 follows
    Description of "Figure 3-26 Loaded OCDA RPD"

  4. Save this RPD and note down the file name (for example, OCDA_MCRE_01.rpd) and the location.

3.11.2 Adding Mobile Clinical Research Associate Server Rule Engine Data Source (Physical Layer)

  1. From the File menu, select Import Metadata.

    Figure 3-27 Selecting Import Metadata

    Description of Figure 3-27 follows
    Description of "Figure 3-27 Selecting Import Metadata"

  2. Select OCI 10g/11g in the Connection type.

    Figure 3-28 Selecting Connection Type

    Description of Figure 3-28 follows
    Description of "Figure 3-28 Selecting Connection Type"

  3. Enter complete data source name, database user name, and password in the respective fields. Oracle recommends the following data source name format:

    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=<port>))(CONNECT_DATA=(SID=<oracle db sid>)))

    Figure 3-29 Entering DB Connection Information

    Description of Figure 3-29 follows
    Description of "Figure 3-29 Entering DB Connection Information"

  4. Click Next.

  5. Select Views from the Metadata types to be imported.

    Figure 3-30 Selecting Views

    Description of Figure 3-30 follows
    Description of "Figure 3-30 Selecting Views"

  6. Click Next.

  7. Select the Mobile CRA Server Rule Engine Schema user from the list and select the following View object from the list:

    • HSM_OBI_STUDY_VW

    • HSM_OBI_STUDY_SITE_VW

    Figure 3-31 Selecting Metadata Objects

    Description of Figure 3-31 follows
    Description of "Figure 3-31 Selecting Metadata Objects"

  8. Rename the data source to MobileCRA Database.

  9. Rename the Physical schema to MobileCRA.

    Figure 3-32 Renaming Physical Schema

    Description of Figure 3-32 follows
    Description of "Figure 3-32 Renaming Physical Schema"

  10. Right-click HSM_OBI_STUDY_VW and select Update Row Count.

  11. Right-click HSM_OBI_STUDY_SITE_VW and select Update Row Count.

3.11.3 Creating Joins Between Mobile Clinical Research Associate Server and OCDA Tables (Physical Layer)

To create joins between Mobile CRA Server and OCDA tables, perform the following:

  1. Create Join for HSM_OBI_STUDY_VW.

    1. Select HSM_OBI_STUDY_VW from MobileCRA schema in the MobileCRA Database and Dim _W_RXI_STUDY_D from RXI schema in the OCDA Data Warehouse.

      Figure 3-33 Selecting Files

      Description of Figure 3-33 follows
      Description of "Figure 3-33 Selecting Files"

    2. From the View menu, select Physical Diagram, and then Selected Object(s) only.

      Figure 3-34 View Menu

      Description of Figure 3-34 follows
      Description of "Figure 3-34 View Menu"

    3. Click New Join.

    4. Click HSM_OBI_STUDY_VW and drag the cursor (hold the mouse) to Dim_W_RXI_STUDY_D and release the cursor (release the mouse).

      Figure 3-35 Creating Join

      Description of Figure 3-35 follows
      Description of "Figure 3-35 Creating Join"

    5. Select INTEGRATION_ID column from the Dim_W_RXI_STUDY_D table and STUDY_ID column from the HSM_OBI_STUDY_VW table (view).

      Figure 3-36 Physical Foreign Key Screen

      Description of Figure 3-36 follows
      Description of "Figure 3-36 Physical Foreign Key Screen"

    6. Click OK.

    7. Close the window.

  2. Create Join for HSM_OBI_STUDY_SITE_VW.

    The following steps are similar to creating join for HSM_OBI_STUDY_VW in step 1.

    1. Select HSM_OBI_STUDY_SITE_VW from the MobileCRA schema in the MobileCRA Database and Dim _W_RXI_STUDY_SITE_D from the RXI schema in the OCDA Data Warehouse.

    2. From the View menu, select Physical Diagram, and then select Selected Object(s) only.

    3. Click New Join.

    4. Click HSM_OBI_STUDY_SITE _VW and drag the cursor (hold the mouse button) to Dim_W_RXI_STUDY_SITE _D and release the cursor (release the mouse button).

      Figure 3-37 Creating Join for HSM_OBI_STUDY_SITE _VW

      Description of Figure 3-37 follows
      Description of "Figure 3-37 Creating Join for HSM_OBI_STUDY_SITE _VW"

    5. Select INTEGRATION_ID column from the Dim_W_RXI_STUDY_SITE_D table and STUDY_SITE_ID column from the HSM_OBI_STUDY_SITE_VW table (view).

      Figure 3-38 Physical Foreign Key Screen

      Description of Figure 3-38 follows
      Description of "Figure 3-38 Physical Foreign Key Screen"

    6. Click OK.

    7. Close the window.

3.11.4 Adding Mobile Clinical Research Associate Server Sources to OCDA Dimensions in the Business Model and Mapping Layer

To add Mobile CRA Server sources to OCDA Dimensions in the Business Model and Mapping Layer, perform the following:

  1. Update Dim - Study.

    1. Select OCDA-DM and expand by clicking +.

      Figure 3-39 Selecting OCDA-DM

      Description of Figure 3-39 follows
      Description of "Figure 3-39 Selecting OCDA-DM"

    2. Select Dim - Study and expand by clicking +.

      Figure 3-40 Selecting Dim - Study

      Description of Figure 3-40 follows
      Description of "Figure 3-40 Selecting Dim - Study"

    3. Click Sources and expand by clicking +.

      Figure 3-41 Selecting Source

      Description of Figure 3-41 follows
      Description of "Figure 3-41 Selecting Source"

    4. Drag HSM_OBI_STUDY_VW from the Physical section and drop on Dim - Study in the Business Model and Mapping section.

      Figure 3-42 Drag and Drop

      Description of Figure 3-42 follows
      Description of "Figure 3-42 Drag and Drop"

    5. Select HSM_OBI_STUDY_VW in Sources under Dim - Study.

    6. From the Edit menu, select Properties to open property window.

    7. Click Add to create join with Dim - Study.

      Figure 3-43 Creating Join

      Description of Figure 3-43 follows
      Description of "Figure 3-43 Creating Join"

    8. Click Dim_W_RXI_STUDY_D from the right side and then click Select.

      Figure 3-44 Selecting File

      Description of Figure 3-44 follows
      Description of "Figure 3-44 Selecting File"

    9. Click OK.

  2. Update Dim - Study-Site.

    1. Select Dim - Study-Site and expand by clicking +.

      Figure 3-45 Selecting Dim-Study-Site

      Description of Figure 3-45 follows
      Description of "Figure 3-45 Selecting Dim-Study-Site"

    2. Click Sources and expand by clicking +.

    3. Drag HSM_OBI_STUDY_SITE_VW from the Physical section and drop on Dim - Study-Site in the Business Model and Mapping section.

      Figure 3-46 Drag and Drop

      Description of Figure 3-46 follows
      Description of "Figure 3-46 Drag and Drop"

    4. Select HSM_OBI_STUDY_SITE_VW in Sources under Dim-Study-Site.

    5. From the Edit menu, select Properties to open property window.

    6. Click Add to create join with Dim - Study-Site.

      Figure 3-47 Creating Join

      Description of Figure 3-47 follows
      Description of "Figure 3-47 Creating Join"

    7. Click Dim_W_RXI_STUDY_SITE_D from the right side and then click Select.

      Figure 3-48 Selecting File

      Description of Figure 3-48 follows
      Description of "Figure 3-48 Selecting File"

    8. Click OK to close the window.

      The created join is displayed.

      Figure 3-49 Updated Table

      Description of Figure 3-49 follows
      Description of "Figure 3-49 Updated Table"

  3. Create Custom Columns for HSM_OBI_STUDY_VW.

    1. Create four new columns as follows:

      SUBSCRIPTION LAST_UPDATED_BY

      SUBSCRIPTION LAST_UPDATE_DATE

      SUBSCRIPTION CREATION_DATE

      SUBSCRIPTION CREATED_BY

    2. Map these columns to LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATION_DATE, and CREATED_BY respectively from HSM_OBI_STUDY_VW.

  4. Add new columns as follows:

    1. Right-click HSM_OBI_STYDY_VW, navigate to Properties, and then select the Column Mapping tab.

    2. Click Add New Column.

      Figure 3-50 Adding New Column

      Description of Figure 3-50 follows
      Description of "Figure 3-50 Adding New Column"

    3. Enter the column name, for example, SUBSCRIPTION LAST_CREATED_BY, and update the column mapping to select the correct source.

      Figure 3-51 Logical Column Screen

      Description of Figure 3-51 follows
      Description of "Figure 3-51 Logical Column Screen"

    4. Update the Physical Table as HSM_OBI_STUDY_VW and Expression as CREATED_BY.

    5. Repeat Step 5 for LAST_UPDATE_DATE, LAST_UPDATED_BY, and CREATED_BY columns as shown in the Figure 3-52.

      Figure 3-52 Update Logical Column

      Description of Figure 3-52 follows
      Description of "Figure 3-52 Update Logical Column"

    6. Click OK.

  5. Create Custom Columns for HSM_OBI_STUDY_SITE_VW.

    1. Create custom columns for LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATION_DATE and CREATED_BY columns as shown in Figure 3-53.

    2. Map these columns to LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATION_DATE, and CREATED_BY respectively from HSM_OBI_STUDY_VW.

    3. Add a new column INTEGRATION_ID mapped to INTEGRATION_ID of Dim_W_RXI_STUDY_SITE_D.

    4. Follow similar steps defined in Step 3 (Create Custom Columns for HSM_OBI_STUDY_VW).

      Figure 3-53 Update Logical Column

      Description of Figure 3-53 follows
      Description of "Figure 3-53 Update Logical Column"

3.11.5 Creating Presentation Tables for Mobile Clinical Research Associate Server (Presentation Layer)

To create presentation tables for Mobile CRA Server (presentation layer), perform the following:

  1. Create New Presentation Table for Grouping Purpose.

    1. Right-click OCDA in the Presentation section and then click New Presentation Table.

      Figure 3-54 Selecting New Presentation Table

      Description of Figure 3-54 follows
      Description of "Figure 3-54 Selecting New Presentation Table"

    2. Enter Mobile CRA Alert Engine in the Name field and click OK.

      Figure 3-55 Entering Name

      Description of Figure 3-55 follows
      Description of "Figure 3-55 Entering Name"

    3. Locate the newly created presentation table (that is, Mobile CRA Alert Engine) in the Presentation section, and then locate Fact for Presentation Folder.

    4. Drag and drop it on the Mobile CRA Alert Engine table in the presentation section.

  2. Create New Presentation Table for Study.

    1. Right-click OCDA in the Presentation section and then click the New Presentation table.

    2. Enter - Study in the Name field and click OK.

    3. Select the following columns from Dim - Study in the Business Model and Mapping section and drop on - Study presentation table in the Presentation section.

      HSM_RULE_SBSCRTIONS_ID

      USER_ID

      HSM_RULES_ID

      HSM_RULES_NAME

      HSM_RULES_DESCR

      HSM_RULES_FNCTN

      STUDY_ID

      ACTV_STUS

      FIRED_STUS

      THRESH_DT1

      THRESH_DT1_NM

      THRESH_DT2

      THRESH_DT2_NM

      THRESH_DT3

      THRESH_DT3_NM

      THRESH_DT4

      THRESH_DT4_NM

      THRESH_DT5

      THRESH_DT5_NM

      THRESH_NUM1

      THRESH_NUM1_NM

      THRESH_NUM2

      THRESH_NUM2_NM

      THRESH_NUM3

      THRESH_NUM3_NM

      THRESH_NUM4

      THRESH_NUM4_NM

      THRESH_NUM5

      THRESH_NUM5_NM

      THRESH_STR1

      THRESH_STR1_NM

      THRESH_STR2

      THRESH_STR2_NM

      THRESH_STR3

      THRESH_STR3_NM

      THRESH_STR4

      THRESH_STR4_NM

      THRESH_STR5

      THRESH_STR5_NM

      SUBSCRIPTION LAST_UPDATED_BY

      SUBSCRIPTION LAST_UPDATE_DATE

      SUBSCRIPTION CREATION_DATE

      SUBSCRIPTION CREATED_BY

  3. Create New Presentation Table for Study-Site.

    1. Right-click OCDA in the Presentation section and then click New Presentation Table.

    2. Enter - Study Site in the Name field and click OK.

    3. Select the following columns from Dim - Study-Site in the Business Model and Mapping section and drop on - Study Site presentation table in the Presentation section.

      HSM_RULE_SBSCRTIONS_ID

      USER_ID

      HSM_RULES_ID

      HSM_RULES_NAME

      HSM_RULES_DESCR

      HSM_RULES_FNCTN

      STUDY_SITE_ID

      ACTV_STUS

      FIRED_STUS

      THRESH_DT1

      THRESH_DT1_NM

      THRESH_DT2

      THRESH_DT2_NM

      THRESH_DT3

      THRESH_DT3_NM

      THRESH_DT4

      THRESH_DT4_NM

      THRESH_DT5

      THRESH_DT5_NM

      THRESH_NUM1

      THRESH_NUM1_NM

      THRESH_NUM2

      THRESH_NUM2_NM

      THRESH_NUM3

      THRESH_NUM3_NM

      THRESH_NUM4

      THRESH_NUM4_NM

      THRESH_NUM5

      THRESH_NUM5_NM

      THRESH_STR1

      THRESH_STR1_NM

      THRESH_STR2

      THRESH_STR2_NM

      THRESH_STR3

      THRESH_STR3_NM

      THRESH_STR4

      THRESH_STR4_NM

      THRESH_STR5

      THRESH_STR5_NM

      SUBSCRIPTION LAST_UPDATED_BY

      SUBSCRIPTION LAST_UPDATE_DATE

      SUBSCRIPTION CREATION_DATE

      SUBSCRIPTION CREATED_BY

  4. Create a new column Src Unique Site ID in Study-Site, which is mapped to logical column INTEGRATION_ID of Dim_Study Site created in Section 3.11.4, "Adding Mobile Clinical Research Associate Server Sources to OCDA Dimensions in the Business Model and Mapping Layer"(Step 4).

3.11.6 Saving the Repository

To save the RPD, perform the following:

  1. From the File menu, select Save.

3.12 Deploying Site-At-a-Glance Reports

To deploy site-at-a-glance reports, perform the following:

  1. Log in to OBIEE analytics.

  2. Navigate to Catalog.

    Figure 3-56 Navigating to Catalog

    Description of Figure 3-56 follows
    Description of "Figure 3-56 Navigating to Catalog"

  3. Select Shared folders and click Unarchive in the bottom-left Task menu.

  4. Click Browse and choose the Site-At-A-Glance-.catalog file.

    Figure 3-57 Selecting Site-At-A-Glance-.catalog File

    Description of Figure 3-57 follows
    Description of "Figure 3-57 Selecting Site-At-A-Glance-.catalog File"

  5. Click OK to unarchive the catalog.

  6. Navigate to the Shared folder and select Site-At-A-Glance.

    A list of predefined reports that are imported is displayed which will be deployed.

Go to previous page
Previous		 Go to next page
Next
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Feedback page
Contact Us