Hyperion Planning Security – Import, Export Utilities and More

Today, I’d like to review how we can quickly and easily setup Security in a Planning application using the Import & Export Utilities, as well as a custom Excel VBA template. Before anything else, I should probably explain or remind some basics about Planning security. Why do we need to setup security and how is security……

Continue reading

Download, install and configure Smart View

Here is an easy one. So you were told you have to start using Smart View: instead of using the old Essbase Excel add-in or because your company chose to use Essbase, Planning, HFM… for all their EPM needs. Either way, you’ll have to download, install and configure Smart View. You can download Smartview directly from the Oracle……

Continue reading

Hyperion Planning Dimension Updates

Starting with version 11.1.2.3, Hyperion Planning rolled out some cool new functionality for dimension (and data) updates to your planning applications. The idea is to make it really easy to update your dimensions without using ODI, the Outline Load Utility, the Planning Admin Extension for Smart View or manually. We’ll look at the Planning extension……

Continue reading

Real World Case Example for ODI Yellow Interface (w/ Dynamic Source and Target)

Until recently, I never encountered a situation where I needed a “yellow interface” in ODI (Oracle Data Integrator). Typical ODI interfaces leverage models that are manually created and point to static objects such as tables or files. On a recent project, I took to ODI to create an automation process that would be used to……

Continue reading