TopDown Blog

Category: Governance

DRG – The Key to Effective Master Data Management in DRM

By on August 3rd, 2017

Regardless of the company size, at some point, the growing organization decides to implement workflow in order to capture the changes that you need to make to the master data. This is where Data Relationship Governance (DRG) comes in. Data Relationship Governance is native to Data Relationship Management with versions later than 11.1.2.3. It is a tool that allows you to do workflow in order to manage master data in DRM.

DRG – Creating Workflows in DRM

By on May 15th, 2017

Data Governance continues to be a big topic. Regardless of the company size, at some point, a growing organization decides to implement workflow in order to capture the changes that you need to make to the master data. This is where Oracle Data Relationship Governance (DRG) comes in. DRG provides essential change management and data quality remediation workflows, capturing business changes and applying them with consistency and accuracy across transactional and analytical system silos.

Managing and Integrating Hyperion Smart Lists Using DRM – Part 1

By on January 10th, 2017

Oracle Essbase is the industry leading Multidimensional Database platform. As a modeling and reporting technology, Essbase can only store numeric information, strings and other data types are not supported. However, both Essbase and Planning can get around this limitation using some functionality called Smart Lists, which are nothing more than lookup tables. This blog post will show you a design to manage both the Smart Lists themselves, as well as the association between member (in Essbase/Planning) and Smart List.

Lights Out DRM

By on November 8th, 2016

Oracle offers a powerful scripting tool called Batch Client. This tool provides the ability to fully automate many tasks in Data Relationship Management (DRM) and Data Relationship Governance (DRG) applications. In this post, I will outline an automated task I created using DRM Batch Client that let a TopDown client use DRM to manage the hierarchies for PBCS and HFM while keeping SAP as the source for the metadata.

Using JavaScript in Oracle DRM

By on February 9th, 2016

Beginning in DRM release 11.1.2.3, JavaScript has been added as a means to process business logic on derived properties and to create validations. This blog post will help you understand how to access the objects in DRM (versions, hierarchies, nodes, property values, and property objects), and how to leverage some of the methods available.

JavaScript Property Formulas within DRM

By on July 29th, 2015

Data Relationship Management (DRM) v11.1.2.3 includes a cool feature that changes the way to write dynamic scripting using JavaScript for your custom derived property and validations. JavaScript has been around for over a decade, but it hasn’t been available to use within DRM until the release of v11.1.2.3.

Getting Started with Oracle DRM v11.1.2.3—Part 5

By on May 20th, 2015

In addition to having an attribute dimension called Population, the Market dimension in Sample.Basic also has 3 UDAs, Major Market, Small Market, and New Market. Whereas we used the data type Global Node to manage the associations of the attributes, the UDA properties will have a data type of string. Below is a screenshot of the Major Market property.

Getting Started with Oracle DRM v11.1.2.3—Part 4

By on April 17th, 2015

In part 4 of this blog series, we’ll learn how to use Imports and Blenders in DRM to create a new version containing metadata from the Sample.Basic Essbase application.To read part 1, click here; to read part 2, click here; and to read part 3, click here.

Getting Started with Oracle DRM v11.1.2.3—Part 3

By on November 6th, 2014

In part 3 of this blog series, we’ll learn how to build properties in bulk using the Migration Utility, and will create six application-specific properties in the Custom.DRM namespace. In the prior post, we learned how to manually manage Versions, Hierarchies, Nodes, and Properties. In this post, we’ll use the Migration Utility to load the properties needed to manage the attributes of an Essbase application. The Migration Utility can also be used to migrate an application from one environment to another, using XML as the data medium.

Getting Started with Oracle DRM v11.1.2.3—Part 1

By on August 13th, 2014

In the first part of this blog series, we’ll learn how to create a DRM application. In subsequent posts, we’ll configure this application with the intent of managing & loading metadata for Essbase. Credits I’d like to recognize Steve Davis, TopDown Consulting Principal Architect. Steve has mentored me in the ways of DRM and was…

© Copyright 2017 TopDown Consulting. All Rights Reserved.