Monthly Archives: February 2012

Oracle DRM Technical Issue | Node Lookup

One of our analysts has spent some time looking into a small issue that was making the life of some business users difficult. The issue concerns the “Find” functionality in properties type “Node” in Oracle Hyperion Data Relationship Manager (DRM) version 11.1.2.1.

Context and configuration: The Oracle Hyperion DRM instance we were working on contained two hierarchies: a source hierarchy and a target hierarchy. Nodes in the source hierarchy could be associated to nodes in the target hierarchy through a mapping property. The property was configured with the type “Node”. Both hierarchies were configured to display nodes using the Name and Description.

Issue: Users would go to a specific node in the source hierarchy to define a value for the mapping property. In the “Select Node” pop-up they would try finding the node they are looking for by typing the name of the node. DRM would always return the message “Specified node not found” even if the node exists and is clearly visible.

 

 

 

 

 

 

 

 

 

 

Cause: The DRM Find is not querying the node name but the string displayed. The string displayed is the concatenation of the name and the description.

Workaround: The best workaround is to use the wildcard %. So instead of searching for the name alone, search for the concatenation of the node name and %.

 

 

 

 

 

 

 

 

 

 

 

 

We hope that you will find this helpful. We have alerted Oracle’s development team of this potential issue or bug. Please do reach out to Seismi’s technical team if you want to investigate any technical issues.

Tagged , ,

Video | Using Masterdata Governance to overcome Business Challenges (Part 4)

This week we will building on what we saw last week where we looked at using Oracle Hyperion Data Relationship Manager (DRM) to govern an ERP system – Oracle E-Business Suite (EBS) but it could be any ERP suite. In addition to governing Oracle EBS, Oracle Hyperion DRM will be used to govern the Hyperion Financial Management (HFM) consolidation tool and a reporting tool (Oracle Essbase).

As you will see in the video the user interface is very intuitive and we aim to build on your understanding of the true power and potential of Oracle Hyperion DRM. We will see that we can control structures in our transactions, consolidation and reporting applications. This demonstration will also show how easy it is to implement business rules and that users, of Oracle Hyperion DRM are forced to consider the impact of their changes on all other related applications.

See you next week where we will be looking at how using an integrated Oracle Hyperion DRM template allows us to extract data out of Oracle EBS, supply it with a mapping and load it into Essbase & HFM in an automated and reliable way.

 

Tagged , , , , , , , ,

Video | Using Masterdata Governance to overcome Business Challenges (Part 3)

In last week’s video blog Ross Gilfillan continued on our theme of how Oracle Hyperion Data Relationship Manager (DRM) can be used to solve business issues. Specifically he looked at how integrated templates can be used to both reduce implementation risks and costs as well as rapidly deploy solutions.

This week he starts to explore integrated templates in more detail and starts at looking how they can be used to govern Oracle E-Business Suite. As you will also see Oracle Hyperion DRM’s user interface is much more user friendly and intuitive than the native Oracle EBS interface.

Ross will continue to look at the flexibility, adaptability and other benefits of integrated templates in his next video where he will show that integrated templates can be used to govern multiple applications when it will be used to govern Oracle Hyperion Essbase and Oracle Hyperion Financial Management (HFM).

As always we encourage people to get in touch if they want to explore these key benefits in more detail.

 

Tagged , , , , , , , ,

Video | Using Masterdata Governance to overcome Business Challenges (Part 2)

In our last video blog Ross Gilfillan looked at how Masterdata Governance, using Oracle Hyperion Data Relationship Manager (DRM) can be used to solve key business issues.

This week Ross will show how Oracle Hyperion DRM can be rapidly deployed using integrated templates and the benefits this provides. In addition he will make the distinction between integrated templates and standalone templates and specifically the additional functionality that integrated templates deliver to clients.

As always we encourage people to get in touch if they want to explore these key benefits in more detail.

Tagged , , , , , , , ,