Monthly Archives: December 2011

Ho Ho Ho - Happy Christmas & New Year

A break from Seismi’s blog is important for everyone over the Christmas period – both writers and readers!

Before we break up for the Christmas holidays we want to wish all our clients, suppliers and stakeholders a very Happy Christmas and here’s hoping for a masterdatatastic 2012!

The blog will be back in circulation on Wednesday 4 January 2012. This said in the meantime if you need to, please do not hesitate to contact us.


Oracle Hyperion DRM Basics | Adding Hierarchies & Nodes

Continuing with our beginner’s guide to Oracle Hyperion Database Relationship Management (DRM), we can now start looking at the core of masterdata management: nodes and hierarchies.

We recently created and saved our sample version. In our home page, under “Browse”, we can now select the sample version and have a look at the hierarchy section. As our version is new, there are no hierarchies.

To create the first hierarchy., simply click on the “Hierarchies” menu, select “New” followed by “Hierarchy…”.

Hierarchy groups are folders which are used to organize your hierarchies. They are particularly useful when your design is more complex. You can either use the small menu or there is a short cut to create a new hierarchy on the right of the “Hierarchies” menu.




You will need to give your hierarchy a name, a description and a top node that will also need a description. The top node can be a new node as it is in this case, or a node that already exists. You can also allocate it to an existing group.

Once your hierarchy is created it will appear in the list of hierarchies.



By double clicking on a hierarchy, you can open it and start navigating around it.





Our hierarchy only contains the top node for the moment. On the right hand of the screen, you can see the properties associated to the highlighted node. There are also some other tabs such as “Relationships”, “Clipboard” and “Shortcuts” on the right and we will investigate these later.

In order to develop this hierarchy we can add nodes by right clicking on the node “TotalGeography” and clicking on “New”.




Oracle Hyperion DRM prompts us for the following details:

  • Is the new node a leaf? A leaf node is a node that cannot have any children. It is the lowest node of the hierarchy;
  • The node name;
  • The node description;
  • If the node already exists, “Insert” the Node. Node names are unique therefore if you enter the name of a node that already exists in another hierarchy, Oracle Hyperion DRM will return an error message. If you select this property, it will insert the node as a shared node; and
  • Add As child” or “Sibling” – A child is a node in the level below the node you have selected. A sibling is a node on the same level in the hierarchy. In this case, we selected the top node, so the sibling option is disabled as every node in a hierarchy must be a descendant of the top node.

After adding some nodes here is how a hierarchy looks:




The glyphs (icons) above each represent different things:

represents a leaf node, which cannot have children; and
represents limb nodes, which can have children. As we will see at a later date, these glyphs can be configured.
Next week we will start looking at properties.  As always do get in contact if you would like to explore this and Oracle Hyperion DRM’s abilities in more detail. 

Tagged , , , ,

Integrating Acquisitions | More than just a consolidation exercise!

A blog focusing on mergers and acquisitions (M&A) may not seem to be topical in the context of the current economic malaise. However, the recent flurry of M&A activity shows that companies that have weathered the storm may have stronger balance sheets and be in a position to take advantage of market sentiment and acquire underperforming targets.

Once an M&A transaction completes all post-merger integration projects have one thing in common: a shortage of time! At best, the financial controller has 3 months to: align accounting policies and processes; create a data repository; and implement a short-term consolidation solution, all before the first quarterly return.

Most acquiring companies are of sufficient size and complexity to already have a consolidation tool sitting on top of their general ledger. The standard approach is to map the acquired company to the existing consolidation instance of the acquirer. The key challenges to this approach include the following:

1) How to physically manage these mappings, which can easily run to more than 200,000 data points? This is way too large to store in a spread sheet or to review and manage in a relational database.

2) How to ensure the accuracy and completeness of the mapping? Given that:

(a) the process of mapping is very time pressured;
(b) the source and target may use very different structures; and
(c) source and target are both moving!

In parallel to this immediate requirement, the post-merger integration team will also need to decide on the end state of the ERP (Enterprise Resource Planning) and management reporting. There are broadly 2 approaches: go for an immediate ERP conversion, or run the 2 ERP’s in parallel. There are distinct advantages to both approaches which I can go into in another blog. What is relevant to this blog, is that both require a robust and efficient solution to manage the account mappings.

To summarise, to optimally manage mappings during post-merger integration requires the following two key considerations:

(A) Requires a specialist masterdata tool to ensure the mapping process is efficient, accurate, complete, flexible and robust; and

(B) Is not just a tactical objective. Although the mappings are required for the short term financial consolidation, management reporting and ERP conversion, they will also be required when eventually you understand the strategic direction of your financial applications.

Experience with our clients has shown that using a combination of Oracle Hyperion Data Relationship Management (DRM) and Oracle Hyperion Essbase delivers rapid benefits in a highly controlled, robust and flexible environment. If you would like to learn more please get in contact.

Tagged , , , , ,