Today, I thought we’d look at a little proof of concept, in this part 1 of a 2-part series of posts. One of my co-authors and I were trying to figure out how to replicate security from a Planning application to an Essbase cube. Imagine the scenario, where we might have a planning application, for inputs……
This week, we will look at a feature of Essbase data load rules that has been around for ages. But, it is not as widely used as it should be (or maybe it is, what do I know). We’ve all been in situations where we perform a data load, but one of the members in……
This is the last in a series of posts related to deriving metadata from HFM’s backed tables. The earlier posts can be found here and here. It will be a short post and I’ve put it together mainly for the sake of completeness. Today, we will look at the Entity dimension. A quick look at EPMA……
Today’s post is just a quick follow up to the last one, on using HFM dimension tables. The disclaimers from the last post still apply. We will be looking at additional code to generate the dimension extracts from HFM’s Account tables. As mentioned in the last post, the accounts dimension has additional attributes and additional……
I need to preface today’s post with the following disclaimer, “I am not an HFM guy”. I understand it and respect it, but I am not an HFM developer. What I wanted to do today though, was look at how we can extract dimensions from HFM directly. A lot of times, we have to depend on……
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……
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……
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……
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……
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……
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……
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……
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……
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……
