By Steve Davis 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 18.104.22.168. It is a tool that allows you to do workflow in order to manage master data in DRM.
By Steve Davis 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.
By TopDown Team 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.
By TopDown Team 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.
By TopDown Team on February 9th, 2016
By Steve Davis on July 29th, 2015
By TopDown Team 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.
By TopDown Team 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.
By TopDown Team 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.
By TopDown Team 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…