Operations

  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: 

Recovery of data in Essbase is sometimes confusing and time consuming depending on the type and frequency of backups previously taken. In this article, I’ll give you an idea of how you can back up your Essbase data for the purpose of restoring a slice of the database. Scenario: I am running a daily export […]

Essbase does its best to be friendly to us system admin types, but sometimes I just want to scratch my head in bewilderment. In 11.1.2.3 and later, Essbase performs a backup of the Essbase.sec file every 300 seconds and retains a default of two backups. This means that at any given time, you have two […]

At some point in working in Smart View, you might have received an “invalid session” error. This is a generic error, and it may occur due to any of the following reasons: Timeout issues with Internet Explorer EXCEL incompatibility with smart view versions.  This is becoming increasingly more common for organizations upgrading Office to 2013. […]

In Essbase 11.1.2.2, Oracle added a configuration option to improve the performance of Essbase Block Storage database restructures. RESTRUCTURETHREADS is a setting you can add to your Essbase.cfg file to enable parallel restructure of BSO databases. The proper syntax taken from the Essbase Technical Reference is: RESTRUCTURETHREADS [ appname [ dbname] ] n Application and […]

Occasionally, I see a friendly error when attempting to refresh or deploy a Planning application that indicates there are active users on the Essbase application. This error is often adjacent to the error, “Date &Time]Starting Cube Create/Refresh…[Date &time]: Cannot restructure. There are other active users on database [%s] [Date&tim]: An Exception occurred during Application deployment.: […]

As with most BI tools, QlikView can use Apache Hive (via ODBC connection) as the SQL access to data in Hadoop. Here we are going to talk about qlikview how to connect Hortonworks Hive via ODBC. Prerequisites 1.Those are versions of each component we installed in Hortonworks Hue HDP Hadoop Hive-Hcatalog Ambari HBase Hortonworks ODBC […]

The realization of competitive advantage has changed significantly over time. In the early days of IT automation, custom-built systems that handled the transactions of accounting or sales were a tremendous competitive advantage. Over time, building custom systems that handled all the transactions of a business provided competitive advantages to the leading companies who were able […]

Since the infamous Kim Kardashian Instagram post went up and the FDA issued a Warning Letter to Duchesnay, the company she was representing, a couple of things have happened. For one, Kim has issued a corrective post (i.e., ad), which outlined the safety information for Diclegis, the medication for morning sickness she is promoting. And, […]

Hyperion Planning Runtime Prompt Security Situation As many of you know, one of the benefits of using a business rule over a calculation script is their ability to utilize run time prompts.  Run time prompts allow the business rule to be dynamically customized to the point of view (POV) the user is currently working with.  […]

Leo Tolstoy‘s book Anna Karenina, begins: Happy families are all alike; every unhappy family is unhappy in its own way. I believe that is also true with RFPs. One of my responsibilities within the Strategic Advisory Team is to respond to RFPs. I am a contributor and in some cases coordinate the responses. When coordinating, I need […]

  If you visit the Gloucester Police Department’s Facebook page, you’ll notice their posts from September 16th and 18th received thousands of likes, shares, and comments. That’s for good reason. On September 16th, the department called out five pharma CEOs with the highest salaries and urged readers to contact them and ask what they’re doing […]