FDM, Essbase and Mapping Tables
I thought I’d do a quick little post on how to use FDM mapping tables to your advantage. To do this, I am taking advantage of the backend SQL tables that support FDM. I was recently given a scenario where I needed to use data mappings to load data into an Essbase reporting application. The……
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……
Hyperion Planning ASO Plan Type Setup
Aggregate Storage (ASO) plan types provide a powerful new dimension to Hyperion Planning. I thought today, we’d take a quick look at how to set one of these plan types up. Now at times, the initial setup can be a bit frustrating, especially if you’ve already set up your planning application and are creating the……
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……
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.……
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……
DRM Console – Access Denied
Thought I’d serve up a quick tip today on the DRM Configuration Console. Once in a while, you will come across an environment where you are unable to restart the DRM service even though you have administrator rights on the machine. I ran into this “access denied” error the other day and this is the……
DRM Import From Tables
For this post, I thought I’d take a look at DRM imports. Now we are all familiar with text imports, so I thought I’d look at how DRM imports work against relational tables (a new-ish feature). This is something developers had been asking for a long time. Just like text imports, imports from relational tables……
Unlocked Cube team at Tough Mudder in LA
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……
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……
DRM Partial Migrations
Now we’ve all been in situations where we’ve perform a lot of updates in an environment, let’s call it PROD and we need to perform a migration of only the objects (hierarchies, nodes, property values etc.) that changed, from that environment to, let’s say, DEV. In other words, we need a “delta” script. Since we……
DRM 11.1.2.4 Application Creation
Now that we’ve finished the DRM install, it’s time to create a new DRM application. This process is pretty straight-forward as well. As usual, let’s look at some of the pre-requisites. Pre-requisites Create a new repository (ensure you have the database rights to do this). Alternatively, you can choose to run scripts manually as well. Suitable……
Blank Hyperion Workspace Homepage
Sometimes when connecting to Workspace, you will get a message saying the start up document couldn’t load, resulting in a blank Hyperion Workspace homepage. This is because most of the time users have not been granted access to the location where the homepage is stored or sometimes it’s because the homepage file is simply gone, deleted by mistake.……
Oracle DRM 11.1.2.4 Installation Guide
So, to kick things off, I thought I would start off with a simple post on how to install DRM 11.1.2.4. This will be part 1 of a 2 part series. To start off with, let’s make sure we have the prerequisites ready. Installation Prerequisites Windows 2008 R2 server IIS (Internet Information Services) turned on……