Performance Management Archives - Data & Analytics

Performance Management

Archive for the ‘Performance Management’ Category

Oracle Hyperion Planning 11.1.2 Installation & Configuration

At the end of this month, I’ll be teaching the Planning 11.1.2 Install and Configuration Oracle University course in the near future. In this course, you learn about the processes involved in installing, configuring, testing, and maintaining Planning. You learn about the layers in the Enterprise Performance Management System infrastructure. Discussions include planning the installation, […]

Read more

Surgical Essbase Recovery: How To Back Up Your Essbase Data

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 […]

Read more

A Solution to Essbase Security File Backups

Essbase does its best to be friendly to us system admin types, but sometimes I just want to scratch my head in bewilderment. In 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 […]

Read more

Why Smart View Users are Receiving Invalid Session Error

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. […]

Read more

How To Speed Up Your Essbase Database Restructure

In Essbase, 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 […]

Read more

Hyperion Planning – Essbase Exception – Cannot Restructure

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.: […]

Read more

What is Change Management?

Written by Matt Stehling Project managers are tasked with change management throughout the life cycle of a project’s duration. The balancing act required to implement changes in a project with an established scope, cost and schedule is challenging. When project managers apply change management, the impact changes will likely have on project cost and/or schedule […]

Read more

How to Migrate an Oracle Hyperion Planning Application

The purpose of this document is to provide a high level overview of the process for migrating EPMA enabled Planning applications between two completely separated environments.  I have made a couple assumptions while writing this that I mention below.  All of this information is available in the references mentions.  I have just tried to provide a […]

Read more

The 10 Commandments of a Successful Center of Excellence

    An organizations center of excellence may begin as an “informal body” comprised of experienced and knowledgeable personnel from the practice, but over time, the COE should get additional powers on the basis of noted contributions to successful projects and receive additional funding to expand the scope of its operations. The following are the […]

Read more

Perficient Data & Analytics

Trends, best practices, and technical perspectives from data and analytics experts. Readers will gain valuable insights and strategies in harnessing the power of data to drive actionable intelligence for a digital transformation journey.