The first time a user launches the ODI Studio they will be prompted or required to set up the initial connection to the Master and Work repositories. This connection information is stored in each user profile. So each user that wishes to log into the ODI Studio console will have to perform this action. To……
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……
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……
PREREQUISITES Download the ODI install file http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html. Make sure you have a Java JDK installed. I used the version seen below. The Oracle support matrix shows any version greater than 1.7.0_55 as supported. I’m not sure if 1.8 is supported though so I stuck with version 7. Note that support for 7 is set to……
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……
