Data Manager - Finding and Selecting Data

Exercise Objectives

After completing this exercise, you will be able to:

• In this exercise you will use, and become more familiar with the various search features of the Data Manager.

Business Example

In order to effectively use the MDM Data Manager, users need to be able to use the various powerful search features it provides.

Task:

Search Exercises:

1. Connect to the MDM050_Exercise_Master repository from the MDM Data Manager using the user given to you by your instructor.

2. How many products are from the “Boss Holding, Inc.”? Of these, how many products are available in “Size” = “12” ? {HINT: size is an attribute in the Category table. }

3. Clear the search criteria. How many products have an "Overall Length [Nom]" = "120.000 mm” ? How many are less than “120.000 mm”?

4. Clear the search criteria. Which "Manufacturer(s)" have a "Type" =

"Activator" ?

5. Clear the search criteria. What Item Status is valid for products with “Tip Type” = “Pozidriv®” ?

6. Clear the search criteria. How many products are in the “Mask” called

“Convert ” ?

7. Clear the search criteria. How many records have a “UNSPSC” that starts with the word “Tool” ?

8. Clear the search criteria. What is the “Name” of the product whose "Temple Length" = "140.00 mm" ?

9. Clear the search criteria. What is the "Sale Price" in "Germany" for “Part Number” = “3126” ?

10. Clear the search criteria. How many of the products that do NOT have

Solution 2: Data Manager - Finding and Selecting Data

Task:

Search Exercises:

1. Connect to the MDM050_Exercise_Master repository from the MDM Data Manager using the user given to you by your instructor.

a) Double click on the Data Manager icon on the desktop, select the MDM050_Exercise_Master repository, and enter the user details as appropriate.

2. How many products are from the “Boss Holding, Inc.”? Of these, how many products are available in “Size” = “12” ? {HINT: size is an attribute in the Category table. }

a) Use the Manufacturer search tab to limit the selection to Boss Holding Inc - there should be 7 records that match this search. Then go to the Category search tab, and find the Attribute Size, and click on the value 12. There should only be one product.

3. Clear the search criteria. How many products have an "Overall Length [Nom]" = "120.000 mm” ? How many are less than “120.000 mm”?

a) Overall Length [Nom] is a Numeric attribute. Go to the Category search tab and find the attribute listed there. Find and select the value 120.000 mm - there should be 6 records. The values are listed in absolute size order, so hold Shift key down, and select the first value in the list to see how many records are less than 120.000 mm - there should be about 154 records.

4. Clear the search criteria. Which "Manufacturer(s)" have a "Type" =

"Activator" ?

a) Type is a text attribute. Look for this attribute under Category search tab, and select Activator. Then go to the Manufacturer search tab to find out which manufacturers remain. You should see Henkel, and RPM International

5. Clear the search criteria. What Item Status is valid for products with “Tip Type” = “Pozidriv®” ?

a) Tip Type is a text attribute. Find this value under the Category search tab, and then check the Status search tab for the valid value - only Active should be shown.

Continued on next page

6. Clear the search criteria. How many products are in the “Mask” called

“Convert ” ?

a) Go to the Masks search tab, and select the entry Convert. There should be 12 records displayed.

7. Clear the search criteria. How many records have a “UNSPSC” that starts with the word “Tool” ?

a) Searches based on text, and starts with, are usually free-form searches.

In this case go to the free-form search tab, and find the row for UNSPSC. Set the value in the second column (using the drop down box) to starts with, and enter the word Tool in the third column (titled value). There should be 140 records.

8. Clear the search criteria. What is the “Name” of the product whose "Temple Length" = "140.00 mm" ?

a) Temple Length is a numeric attribute. Search for this value under the Category search pane. The Name of the record should be Cricket Protective Eyewear.

9. Clear the search criteria. What is the "Sale Price" in "Germany" for “Part Number” = “3126” ?

a) Sales Price is part of the Qualified lookup for Pricing. Use the free-form search to find the part number 3126, then check the Pricing lookup in the Record Details tab. The Sale Price in Germany should be 12.17.

10. Clear the search criteria. How many of the products that do NOT have

"Image Details", but has a “Color” = “White” ? Save your last search as a Search –> Save as Local Search... In the dialog box enter the Search name:

White with no Image Details.

a) Under the Image Details search tab, select the [NULL] value. Under the Category search tab, find the attribute Color, and select the value White. There should be 16 records.

Lesson Summary

You should now be able to:

• Identify the different modes of the MDM Data Manager

• Use the various search features available in the MDM Data Manager