TopDown Blog

Category: Planning & Forecasting

Smart View Power Tools: Break New Analytical Ground with Smart Query

By on August 12th, 2015

Introduced in EPM v11.1.2.2, Smart Query, a feature of Hyperion Smart View, still doesn’t get a lot of attention; and it should because it’s the key to a number of analytical capabilities that Essbase users never had before.

Smart Query goes beyond the capabilities of standard Smart View. To put it more simply, Smart Query is an analysis type like the Essbasse Ad Hoc query tool or Smart View forms, but the cool difference is that Smart Query focuses on “set-based analysis.”

Sometimes it’s not necessary to log into web interface – just use Smart View

By on February 23rd, 2015

Oracle Hyperion Smart View for Office is a powerful user tool allowing for easy and flexible ad-hoc reporting and it’s a tool that can display things like web forms and grids. But, did you know that you can use also use it as an administrative tool?

Automating Calc Manager Rules for Oracle Hyperion Planning

By on January 21st, 2015

Oracle’s Calculation Manager has a host of features for creating business rules across the Hyperion suite of products. Today I want to focus on how to automate those rules in a Hyperion Planning environment. If you have Calculation Manager rules that you would like to schedule to run on a periodic basis, including rules with run-time prompts, this post is for you.

KPIs and the Pareto Principle

By on October 23rd, 2014

Focusing on the “vital few” is the first step in the strategic planning process, and allows you to identify your KPIs. According to the Pareto Principle (also known as the 80/20 rule), for most events, roughly 80 percent of the effects come from just 20 percent of the causes. The Pareto Principle is considered a common mode of operation in many business practices today – including driver-based planning.

Traditional Planning and Forecasting is Broken

By on September 4th, 2014

We’re kicking off a blogging series all about driver-based planning, in which you’ll learn how to implement a driver-based planning process from the top-down. Driver-based planning works by identifying and measuring only the key drivers of the business, and helps companies stay competitive is through informed decisions and agile business practices.

Creating the Sample Planning application with Oracle EPM

By on August 21st, 2014

In this blog post we’re going to look at an easy way to create a sample Planning application with Oracle EPM v11.1.2.3.

Poll Your Audience! – Oracle Hyperion Workforce Planning

By on July 22nd, 2014

Project teams often wrestle with the decision to initiate Hyperion Planning’s Workforce module or create a customized salary planning application. Surveying your team, and surveying their requirements can lead to discovery and uncover conversation catalysts to help make the decision clearer. To make sure you get critical information, you should remember some key characteristics when…

Migrating an Application, Repository, Individual Artifacts and Security

By on April 24th, 2014

Technology: Hyperion Lifecycle Management Tool. Migration for Oracle Hyperion Planning, 11.1.2 with Shared Services 11.1.2 Version: 11.1.2. Topic: Migrating an Application, Repository, Individual Artifacts and Security across product environments and operating systems. The question was: What is Lifecycle Management Tool is used for? The answer is: Lifecycle Management provides a consistent way for Oracle Hyperion…

Submit Data via Smart View to ASO type applications

By on April 15th, 2014

Technology:  Oracle Hyperion Version: Topic:            Submit Data via Smart View to ASO type applications Write back privileged users were not able to submit data via Smartview for older version ASO cubes. Users can now submit data via Smartview in version 11.1.2 The question was: Can I lock and send data in ASO? The answer…

Updating Built-in Calculation Manager Rules in Workforce Planning

By on April 9th, 2014

Oracle’s latest release of the Workforce Planning module for Hyperion Planning brings with it a host of new features. With those new features there is, of course, new complexity. If we take a look back at the documentation for the previous version ( – wfp_admin.pdf) we will see that there is an appendix that lists some of the predefined content that ships with the Workforce module. Included in this section is “Predefined Business Rules” which has the basic code related to the built in rules. An example is the “Add TBH Salary” rule.

© Copyright 2019 TopDown Consulting. All Rights Reserved.