Posts Tagged ‘Oracle’

Fragmentation of Essbase block storage databases occurs as a result of routine data changes, data loads, and calculations. Essbase has two database statistics that measure database fragmentation: the average clustering ratio and the average fragmentation quotient. Check out this article from the Oracle Customer Engineering & Advocacy Lab for a more thorough description of BSO […]

One of the challenges that I face at my job is supporting multiple clients that use different versions of Siebel Clinical (CTMS). Not only are they different versions, but each instance has been uniquely configured and enhanced. With many clients to support, plus internal product development efforts, I needed to find a way to run […]

After teaching several HFM 11.1.2.4 Create & Manage Applications courses, I have found several functionality advantages of HFM 11.1.2.4. User Functionality Greatest user improvement comes in Smart View and the Journals Extension. Users now have to ability to create and manage journal entries in Excel. We know that any time functionality can be completed in […]

In my last blog post, I presented some thoughts on showing data changed since last review. Today, we will concentrate on the level of scrutiny and what happens when recording the user actions in the review. Not all data may require the same level of scrutiny during a review. Additional focus may need to be […]

Oracle recently announced the general availability of the latest patchset for Siebel Innovation Pack 2016 (IP2016). Patchset 16.9 can be found on Oracle Support, although it is a little tricky to locate. Use these search terms to find it: For Windows, you would select this file: This takes you to the download window and the […]

In my previous post, we discussed some examples of business rules that might be applied depending on how many people are performing a clinical data review. Today, we’ll discuss approaches for selecting the data that is being reviewed. In any data review that occurs multiple times during the course of a study there are two […]

Perficient’s Life Sciences practice regularly monitors the software release notes for several Oracle Health Sciences applications, as well as our own clinical and safety systems. The systems covered in our review are: Oracle Systems Argus Safety Oracle Clinical/Remote Data Capture (OC/RDC) Thesaurus Management System (TMS) Perficient Systems Accel-Account Manager Accel-Copy ASCEND (Siebel CTMS) Generally speaking, […]

In a few of my previous blog posts (4 Ways You Can Improve The Clinical Data Review Process and Using On-demand Data With Dynamic Data Writeback In Spotfire), I discussed using Spotfire as an aid for Clinical Review of data along with supporting writeback capabilities to record the user review actions. In the next several […]

In my last post, I discussed performing a clinical data review in Oracle’s Data Management Workbench, which takes value added data into consideration. Today, we’ll take it a step further and add external data into the mix. This scenario extends the data available for review by including data from external partners who may be managing […]

In part one and part two of this series I addressed two of the three methods I identified that can be used on PBCS to extract data from the command line and scheduled to run without user interaction. In this third and final post of the series, I will explain how to extract data using […]

The first blog post in this series, How to Extract Data from Planning Budget Cloud Service (PBCS), covered data extraction using the native data export PBCS functionality. Continuing with this series, I’ll describe the second method to extract data from an Oracle PBCS instance. Each method has its advantages and disadvantages. This post will focus on […]

For years, I have used either Oracle Virtual Box or VMWare Workstation for creating test servers so I could spend quality time with new versions of the Oracle EPM software.  This has required me to maintain a rather expensive and bulky workstation class laptop.  A high-end laptop capable of running a virtual machine with 4 […]