Skip to Content
Product Information
Author's profile photo Akhila Raparthi

Concento RDG Simplifies Creating Multi Value Derivation rules with Comparison Operators

Concento Rapid Data Governance (RDG ) is an SAP certified Cloud -based UI5 application which automates the MDG activities like Data Model maintenance, Designing Workflows, Managing Business rules, Configuring fields and interface configuration. This data governance tool will helps the users to accelerate the implementation and maintenance of  MDG.

This blog is a Part of series which covers another important Key Feature that is provided by Concento RDG.

     To create rules in BRF+, the user have to perform the below mentioned steps.

  1. Select the relevant Catalog to define the rule( FMDM_MODEL_<DATA_MODEL> ).
  2. Create a Function.
  3. Add context parameters to the created function.
  4. Create Ruleset.
  5. Create Rule.
  6. Define conditions for which the rule is triggered.
  7. Define the Action when the condition is met.

 

Concento RDG makes it easier for creating rules in BRF plus by automating all the configuration steps .

Users have to mention the condition, and what is the action item defined on that condition.

In the below example, you can find  how to create multi value derivation Rules by using comparison   operators.

 

Step 1 : Log on to RDG Screen and  Click on “Manage Business Rules ” tile.

                                                                     Figure 1 : RDG Initial Screen

 

Step 2 : After entering the “Manage Business Rule” , select the Change Request type from the dropdown. Select the entity for which the rule has to be created and select the type of rule from the dropdown.

 

                                                              Figure 2 : Manage Business Rules

 

  • Multi Value Derivation Rule using comparison operators :

 

   In this example, we take MATERIAL ( Basic Data ) as our entity for MM Data Model.

  Steps for Creating  Multi value derivation Rule: 

Step 1 :    Select “MATERIAL” entity from entities and from the dropdown, select “Multi value            Derivation “.

Step 2 :  Click on “Add Driving Attribute”. Enter the details for Entity (MATERIAL ) and  Attribute      (BRGEWMARA – Gross Weight) in the pop up  window. Click on Add Column.

Step 3 :  Add on more attribute by  Clicking  on “Add Driving Attribute” .  Give Entity = “MATERIAL “,  Attribute =  ” NTGEW – Net Weight ” and  click on Add column.

Step 4 :  Click on “Add Deriving Attribute “. Enter  Attribute = “GROES – Size/Dimensions” and  click  on Add column.

Step 5 : Now  click on add “Add Rule” . A row will get enabled.

Step 6 : Give the input values with comparison operators (BRGEWMARA = 100 and  NTGEW = 200  and select the “Work flow steps” , click on formula table, pop up  window appears .                                             .

Step 7 :  Select Mathematical Formula as a type under dropdown. Then enter the Condition.

Step 8 : Here our Condition is “Size/Dimensions”  should be the multiplication of NET WEIGHT and  GROSS WEIGHT. So, Enter Type  as ” Mathematical Formula” , click on “Add” enter the details for Entity , Attribute and Operator and save it.

 

Formula Table :

                                                       Figure 3 : Formula Table for Mathematical Expression.

 

Step  8  :  Similarly, You can add as many rules as you want , based on the business                      requirement. The Figure  mentioned below will refer to the number of rules that were                          added in this example.

RULE :

                                      Figure 4 : Mathematical Formula with different Operators  Rule in RDG

 

  • Triggering the rule on NWBC screen.

Derivation rule that is created on RDG screen  is going to be triggered when we                                   select  the  relevant  change request type.

 

  • Multi Value Derivation Rule :

       

                                                       Figure 8 : Deriving Volume in NWBC Screen

 

Concento RDG makes the MDG process much easier . So, users with out having any technical

knowledge on MDG can implement the whole governance process with the help of RDG.

Concento RDG is a certified BTP solution and is available on SAP  APP Store . To know more details  about the product .Please, check the blog Partner Add-on Solution.

Your ideas or suggestions about the product are highly important. Please , feel free to post your comments below.

 

Please, also check out for other features of Concento RDG from the blogs.

Concento RDG provides an effortless Cross Entity Rule Derivation

Concento RDG simplifies Field Property Configuration, lets you change fields in the UI without any hassle.

Concento RDG provides an effortless Parallel and Dynamic Workflow maintenance

 

Check out for other topics related to MDG Development :

SAP Master Data Governance at a Glance

Benefit from SAP Master Data Governance on SAP S/4HANA 2021

Mapping different domains in SAP Master Data Governance to SAP S/4HANA processes

SAP MDG – A Stepping Stone for SAP S/4HANA Journey – Part I

How to: SAP MDG Master Data Quality (Remediation) Process on S/4 HANA with BRF plus validation rules

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sabine Stellmacher
      Sabine Stellmacher

      Hi Akhila,

      I checked out the MDG related links - they are pretty old. Referring to blogs created in 2016, 2017 and 2018.
      With regards to Data Quality Management MDG provides a lot of 'new' functionality (starting with OP2019).

      Regards, Sabine

      Author's profile photo Akhila Raparthi
      Akhila Raparthi
      Blog Post Author

      Hello Sabine,

      Thanks for  your comment . I have updated the MDG related links with the latest one's. If you still need any information from our product you can find it in SAP App Store or directly reach out to marketing@datamigrationresources.com.

      Thanks & Regards ,

      Akhila