Ask an Expert

Oracle EPM & BI Blog

The Future of Oracle EPM On-Prem, Version 11.2

There were a lot of Oracle EPM announcements at Kscope19 and it left some of us scratching our heads, wondering, “What’s my next step?” Well, first of all, you’re not in this alone. We’re here to help guide you and assist in making the decision that’s right for your company.

You also have time, but you should start evaluating your options now. Which is the reason for this blog post — it’s a starting point for you to understand where you’re headed with your on-premises EPM technology.

In this blog post, we’ll cover…

  • Updates and the plan for Hyperion 11.2
  • Features not included in 11.2
  • Details and planned features for 11.2
Read More

Why Is It So Difficult to Maintain Data Consistency Across the Enterprise?

Establishing a common set of data parameters that your organization follows seems like it should be simple, but the truth is that every group needs their own view of the data. Consider a simple concept like “Total Monthly Sales.” If I’m speaking from a sales group perspective, I’m referring to all the business my sales organization closed in the time period I’m reporting for. If, on the other hand, I’m asking the group controller, his definition is going to reflect all closed business that has been booked to the ledger.

Hence, at month end, when the CEO is trying to review how the organization is doing against the stated goals, the answer he gets for “Total Monthly Sales” will be different based on whom he asks. The detrimental effect of alternate views is the inconsistency of data across the organization. Departmental management makes operational decisions based on what they perceive is the truth, and corporate management makes strategic decisions based on these perceptions. If the data is not the same, it is easy to see how operational decisions can conflict or adversely affect the strategic corporate goals.

Read More

The Top 10 EPM & BI Downloads of 2016

We had a big year producing tools, white papers, videos, and more so that you can get the most return from your EPM and BI investment. This blog post counts down our 10 most popular downloads.

Read More

DRM Best Practices: Versions, Hierarchies, Nodes, Properties, and More

Oracle Data Relationship Management is a commonly misunderstood tool. Our expert data governance consultants continually see the same mistakes due to inexperience with the application. The good news is these mistakes can be fixed and your practices can be modified.

In this blog post, we’ll look at best practices for different components of DRM, including:

  • Versions
  • Hierarchies
  • Nodes/Members
  • Properties
  • Queries & Validations
Read More

3 Things to Know About Integrating Oracle DRM with Your Applications

If you think Oracle Data Relationship Management (DRM) can only integrate with Oracle Hyperion applications, then you probably don’t know the history of DRM. The tool was originally developed by an SAP shop with the goal of supporting hierarchy and hierarchy reference data for reporting.

We’ve already debunked myths about DRM’s functionality as well as DRM’s project costs and timeframes. In the third blog post of this series, we’ll talk about how DRM will integrate with your applications: using DRM with non-Oracle products, supporting a SaaS-based cloud architecture with DRM, and maintaining Oracle EPM products with DRM’s automated integration. 

Read More

4 Myths About Oracle DRM’s Functionality


Those who have Oracle Data Relationship Management (DRM) often don’t realize the power of their solution and end up underutilizing the tool. Because DRM has been continually optimized over decades, many organizations are missing facts about DRM’s capabilities — facts that could be keeping them from a higher return on investment.

We’ve already debunked common myths around DRM’s project costs and timeframes. Now, in this second post in the series, we’ll take a closer look at DRM’s functionality and how to get more from the tool. These myths revolve around DRM use cases, mappings, workflows, and data cleansing.

Read More

The Truth About Oracle DRM Project Costs, Timeframes, and Uses

“But DRM doesn’t do that… does it?” This is a question our consultants hear regularly. Because people are often surprised by the answers to their Oracle Data Relationship Management (DRM) questions, we’ve set out to separate fact from fiction and help organizations make informed decisions.

In this first post of the series, we’ll focus on myths that keep companies from getting started with DRM and investing in a high-ROI solution — myths around DRM’s use cases, costs, and projects.

So, what are the myths? And, more importantly, what are the facts?

Read More

DRM Tutorial: 8 Steps for Adding New DRM Users in Bulk


 Recently, I was tasked with adding Users to DRM. The list contained almost 200 users! Inputting the users one-by-one was, in my opinion, not a viable option. Instead, I was able to save time by bulk inserting the users into DRM.

Bulk inserting DRM Users involves modifying/writing to back-end database tables. In addition to READ access to the DRM relational tables, you will also need WRITE access to the following six tables:

  • RM_User
  • RM_User_Role
  • RM_Category_User
  • RM_Object_Access_Group
  • RM_Object_Access_Group_User
  • DAL_Sequence

In the following example, users will be added to DRM with the “Workflow User” role.

Note: The below steps were used for an environment using MS SQL Server.

Read More

The Biggest Challenge in Moving EPM to the Cloud

The industry is buzzing about digital transformation (DT) — the newest term to describe movement from on-premises to off-premises applications. Organizations eager to curb the never-ending costs associated with software and hardware upgrades as well as personnel management are moving in large numbers from on-prem Oracle EPM to the new cloud pod environment for Planning, Essbase, and Financial Close Management.

Read More

New Release: Oracle Hyperion Data Relationship Management (DRM)


If your organization currently has a DRM implementation or is considering purchasing DRM, now’s the time to seriously look at this power suite of data governance software. Oracle development continues its longstanding commitment to enhancing the DRM product to meet the needs of their user base and to meet their goal of seamless integration with the rest of the Hyperion Enterprise Performance Management (EPM) suite of tools.

Read More

Subscribe to Email Updates

Browse by Topic

See All