Tips & Tricks

Oracle Hyperion DRM Tips & Tricks | Quicker Navigation

A quick one this week we just thought we should share a small Oracle Hyperion DRM (Data Relationship Manager) feature that can be helpful and most importantly save time and raise your productivity.

Whenever you are working within a tab, you can right-click on the tab bar and see the different sections of the Home menu. This allows you to navigate directly from one module of Oracle Hyperion DRM to another, rather than having to click on Home then the name of the module you want. In the long run, this sav

140122_Seismi Blog_DRM Tips & Tricks_Quicker Navigation

es not just time but also frustration…

Tagged , , ,

Oracle Hyperion DRM Tips & Tricks | Clearing a Property Value

If you ever need to clear all values of a defined property within a hierarchy (prior to blending in a completely fresh set of property values, say), it can be done in a few brief steps.

Firstly select the top node of the hierarchy and choose the tab the property is on. If the top node does not normally show this property, you will have to select Show All Properties on the property viewer. Only administrators can do this but then again, only administrators should be doing this.

Next, right-click on the property label and choose Clear All Below, followed by Save. This removes all explicitly defined values from each node below the selected node. (This is a useful little option in itself.)

131211_Seismi Blog_Clear Property Value in Oracle DRM

Finally, right-click on the property label and choose Remove Value, then Save. This removes the property value from the top node.

There are action script equivalents of these two commands, so if you have a whole set of properties to clear an action script is probably the way to go:

131211_Seismi Blog_Clear Property Value in Oracle DRM_2

Tagged , , , , ,

HFM Redeploy from EPMA – Unspecified Error

When redeploying an Oracle Hyperion Financial Managemenent (HFM) application from Oracle Enterprise Performance Management Architect (EPMA), the deploy operation can fail and return a very unhelpful error message “Unexpected Error”. Although not immediately obvious, this error usually indicates there is an issue within the outline however, if the application has data, it may simply be that the data is being reorganized.

The screen shot below shows the EPMA summary:

130726_Seismi_HFM Redeploy from EPMA_1

The EPMA error log only is not much help either.  It returns the following information:

Error Reference Number: {5AD32CB5-7E26-4A48-A98C-5DC4870698E7}

Num: 0x80004005;Type: 0;DTime: 05/07/2013 13:54:20;Svr: UK1WHYPAPP11Q;File: CHsvMetadata.cpp;Line: 1056;Ver: 11.1.2.1.600.3779;

Num: 0x80004005;Type: 0;DTime: 05/07/2013 13:54:20;Svr: UK1WHYPAPP11Q;File: AgentHelper.cpp;Line: 1237;Ver: 11.1.2.1.600.3779;

Num: 0x80004005;Type: 0;DTime: 05/07/2013 13:54:21;Svr: UK1WHYPAPP11Q;File: CHfmAwbAgent.cpp;Line: 665;Ver: 11.1.2.1.600.3779;

To solve this, in the deploy screen uncheck the “Check Referential Integrity” option and check the “Full Deploy”.

130726_Seismi_HFM Redeploy from EPMA_2

Changing these options should allow you to deploy the HFM Application.

WARNING – Deploying without the option “Check Referential Integrity” means that data can be affected. Before doing so, be sure you have a backup of the application and a point of comparison to review any changes.

 

Tagged , , ,

Oracle Hyperion DRM Tips & Tricks | Save Your Work

Oracle Hyperion Data Relationship Manager (DRM) has a somewhat unorthodox interface, which can lead the unwary into losing their work. Grizzled Oracle Hyperion DRM veterans will have discovered these traps the hard way, but if you are relatively new to the product this blog post might spare you some pain, we hope.

Items Displayed in Tabs

Oracle Hyperion DRM uses tabs to display the details of queries, compares, imports, blends, exports and all the objects managed by a system administrator. When you have one of these open, as the image below shows the only indication that you have unsaved changes is an asterisk next to the item name (and even this cannot always be relied on).

130425_DRM Tips and Tricks_Save your work

 

If you close an item after making changes, you don’t see the Save / Don’t Save / Cancel dialog box that most programs would display – Oracle Hyperion DRM simply closes the item and discards any unsaved work. It is thus important to get into the habit of being conscious of whether you need to click the Save icon towards the top left before closing a Oracle Hyperion DRM tab.

Versions

When an Oracle Hyperion DRM version is created it starts in an unsaved state. Unsaved versions are deleted whenever the Oracle Hyperion DRM service is restarted (which happens every night at some sites). New versions are often used for importing data to blend into other versions, so are legitimately temporary. However, if you have created a version you want to keep, it does not matter how often you clicked Save after adding or moving nodes or updating properties. If the Oracle Hyperion DRM service is restarted you will lose everything.

You should save a version you want to keep as soon as you have created it, by right-clicking on its name and selecting Save. 

130425_DRM Tips and Tricks_Save your work_2

 

Once a version has been saved, all confirmed node changes and property updates are preserved without you having to save the version again.

Hopefully that should save you some time and stress!

Tagged , , ,

Oracle Hyperion DRM Tips & Tricks | Query Limitations

This is the first item in an on-going series of blog posts designed to help our readers get the most out of Oracle Hyperion DRM (Database Relationship Manager).

This post addresses a limitation in the way Oracle Hyperion DRM allows users to define queries. Specifically, Oracle Hyperion DRM allows you to structure queries using parentheses but does not allow you to put a NOT in front of criteria grouped in this way.

What if you were making a complex query and wanted to exclude nodes that meet two conditions? For instance you want to select all nodes that are below the top node, except leaf nodes if they are also linked in from another hierarchy. In Oracle Hyperion DRM terms what you are trying to achieve is:

  • Level Greater Than 1 And Not (Leaf Equal True And Linked Equal True)

You cannot code this as it stands in an Oracle Hyperion DRM query. However, the following rule of logic can help:

  • not-(A and B)     is logically equivalent to     (not-A or not-B)

Our example now becomes:

  • Level Greater Than 1 And (Leaf Equal False Or Linked Equal False)

Which as the screenshot below shows can be implemented in Oracle Hyperion DRM in the following way:

130417_Seismi_DRM Tips & TricksIf you have anything you want to add please do post a comment. Until next time….

 

Tagged , , ,