Hyperion Planning Articles - Perficient Blogs

Posts Tagged ‘Hyperion Planning’

  • Topics
  • Industries
  • Partners





Customizing Oracle EPM Workspace Logon Page for Part I

It is very important for users to identify to which environments are they logging in. For this reason, I am sharing the following insights into how to customize the Oracle EPM workspace logo, which will help users determine if they are logging into a Production, Development, or QA environment. Out of the box Workspace log […]

Read more

Connect with Perficient at #Kscope18

Kscope18, ODTUG’s user conference known for providing a rich opportunity for networking and education on Oracle technologies, is just one month away and we’re excited to connect with you at the event. Perficient is proud to be a silver sponsor of Kscope18, which is being held June 10-14 in Orlando. Visit us at booth #312 […]

Read more

EPBCS – Rules usage report and adding data to suppressed rows

Oracle is doing a great job in continuously upgrading the PBCS / EBPCS based applications. Being a EPBCS consultant I always follow their latest updates to make sure we use it in our implementation or support process. This Blog is specific to two recent update which is really useful Below is the link for Oracle EPBCS latest update release : […]

Read more

How to Create a Rolling Three-Month Report Using FR Studio

Whether you are a consultant building reports for a client, or you are a report builder for your own company, chances are you will be asked to create a rolling three-month report. In this blog, I will discuss how to create a rolling three-month report for Planning using FR Studio. As you are probably aware, Planning […]

Read more

Hyperion EPM–How to Choose the Right Applications? Part 3

From my latest post (Post 2), we talked about starting the process to identify your needs, the importance of a partner and the value of planning ahead.  We will continue down that path in this post.  I’m trying not to spend too much time on gathering project requirements in these posts; however, they are a […]

Read more

Hyperion EPM–How to Choose the Right Applications? Part 2

From my earlier post (Post 1), we talked about what EPM is and how it can help organizations.  This post will focus on starting the process to determine what the organizational needs are.  This is the first step in determining which applications to select and implement.  If at all possible, do not buy your new […]

Read more

Hyperion EPM–How to Choose the Right Applications for Your Needs?

Constant pressure from shareholders and upper management to improve the bottom line are driving factors to business leaders searching for new ways to be more effective and efficient. One of the many tools available to them is Enterprise Performance Management. Broadly defined, Enterprise Performance Management (EPM) is managing the profitability and performance of your business […]

Read more

How to Connect Oracle OAC to Planning & Budgeting Cloud?

Oracle Analytics Cloud (OAC) was updated recently to support direct connectivity with Oracle Planning & Budgeting Cloud Service (PBCS) and EPBCS. Consequently, we can now source data live from PBCS applications without the need to extract and import into OAC. I have seen several financial departments use PBCS as a source for budgets and forecasts […]

Read more

Step-by-Step Use Case: Goal Seek and Hyperion Planning

Goal Seek is one of the most commonly used spreadsheet features. The Goal Seek feature back calculates the source value or the input value based on a target value. Using Goal Seek, you can adjust a value used in a formula to achieve a specific goal. This is an incredibly powerful tool when it comes […]

Read more

Vacation Planning for Hyperion Administrators

When planning an out-of-town vacation, do you diligently ensure that you have someone lined up to water your plants, feed your goldfish, and keep an eye on your home?   What about your Hyperion environment? Do you hire a managed services provider to take care of your systems and watch over your applications while you are […]

Read more

How to Encrypt the Admin Password When Used on a Batch Script

In one of my previous blog posts, the EPMAUTOMATE encrypt command was used to encrypt the administrator’s password on a batch script. Here, I describe the process for how to encrypt the password when used on a batch file. Before continuing, ensure the EPMAUTOMATE has been installed on the computer from which you are running […]

Read more

PBCS vs. EPBCS: The Planning Cloud Decision

“CLOUD! CLOUD! CLOUD!” Oracle offers TWO Planning applications on the cloud: PBCS and EPBCS. The following blog will describe the differences between the two and how Perficient can demonstrate the differences by attending our Planning Create & Manage class in Houston. First off, I am sure most of you are wondering, what do those acronyms […]

Read more

How to Restore PBCS Application Artifacts and Data from Snapshot

I recently wrote a blog post describing the process to create and download Oracle PBCS application SnapShots to local disks. Now I’m sharing a step-by-step look at the process of importing an application onto PBCS. In this article, I will describe how to remotely execute predefined commands to upload files and migrated Artifacts SnapShot. To […]

Read more

Build a Home Server Lab on a Budget

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

Read more

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

Integrate EPM Automate with Hyperion Smart View in Cloud

Source Image:https://blogs.perficient.com/2015/05/06/using-epm-file-transfer-utility-and-automate-utility EPM Automate Oracle came out with a bunch of good scripts for many of the repeatable tasks performed in a Cloud instance. For example Refresh Database Import and export metadata Import and export Planning application data Launch Business Rule(s) Copy data from one database to another database Upload files into the Oracle PBCS […]

Read more

How to Reassign Security Filters to a User in Hyperion Planning?

Recently at a customer site we saw the following issue with a user trying to run a FR report. The user was unable to run a report or connect to Smart view via an Essbase connection. However, the user could enter data using planning web forms. The user was getting the following error, “Cannot open […]

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

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

Subscribe to the Weekly Blog Digest:

Sign Up