Monday, April 8, 2013

MSMDM Add a Business Rule

From the admin console select Manage ==> Business Rules

image

Select the model and entity:

image

Press the + sign

image

Double Click in the name field and change the name to JCountrys, enter a description:

image

Press the Edit Symbol:

image

Edit Business Rule:

image

Drag “starts with” from the Components panel to IF

image

Drag the name from Attributes panel to the Edit Condition panel

image

Enter “Ja” in the Attribute value input box.

image

Press save:

image

The expression has changed to:

image

From the Actions > Validation panel drag is not valid to the THEN panel

image

Drag “Code” from the Attributes Panel to the Edit Action panel

image

Press save:

image

Press <- to return to the main menu

image

image

You will see that the status has changed to activation pending.

Press the publish button to activate the changes

image

If everything is ok the status will change to active:

image

Open the entity in your Excel MDM plugin and press the apply rules:

image

You will see that Jamaica and Japan are invalid:

image

The tooltip will tell you why:

image

Till Next Time

Friday, April 5, 2013

Welcome to MSMDM 101

Welcome! This will be the drop place for all my Microsoft Master Data Management Tips, Tricks and Experiences!

Till Next Time