Fixing the new Essbase FIXPARALLEL calculation command

Recently, Oracle released a fantastic new calculation command in the 11.1.2.3.500 patch set – the FIXPARALLEL calculation command (click here for details of this command).  Expanding the horizon of ways that Essbase developers can perform multi-threaded calculations. I recently finished a project at client that had some stellar Exalytics machines chock full of CPUs and……

Continue reading

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

Don’t forget the WORKERTHREADS!

Beginning in 11.1.2.4 Essbase, there is a new configuration setting that should not be forgotten – “WORKERTHREADS”. Why is this configuration setting important you may ask. Previously, Essbase operations that could run in parallel (calculations, data loads etc) used dynamically created threads for their work. Administrators need not bother setting thread pools or assigning threads.……

Continue reading

Update the Workspace Smart View version

This is quick tip for any admin that needs to update the Smart View version that is available to users for download from the Hyperion Workspace console. I was able to follow these steps so far since  Hyperion version 11.1.2.2 and this is still accurate for 11.1.2.3.500. As always be careful, and make sure the Smart……

Continue reading

Oracle Tool for Comparison of EPM Versions

Every wondered if there was a simple way to compare your current EPM version with a planned version upgrade. Some way to see all the cool new features that would come with the new version. Thankfully Oracle has a great online tool that provides a cumulative feature overview between EPM application versions. The tool can……

Continue reading

Dynamic Scripting Validation Goodness

With the arrival of Dynamic Scripting in DRM 11.1.2.3, JavaScript is a valid scripting option within DRM. This is pretty neat because a script provides a more robust alternative to traditional DRM formulas. I also like the fact that you can now put comments inside your code. I thought it would be nice to do……

Continue reading