Export (0) Print
Expand All

Create a Date Attribute (Master Data Services)

In Master Data Services, create a date attribute when you want users to enter a date as an attribute value.

Note Note

The attribute is called DateTime, but time values are not supported.

To perform this procedure:

To create a date attribute

  1. In Master Data Manager, click System Administration.

  2. On the Model View page, from the menu bar, point to Manage and click Entities.

  3. On the Entity Maintenance page, from the Model list, select a model.

  4. Select the row for the entity that you want to create an attribute for.

  5. Click Edit selected entity.

  6. On the Edit Entity page:

    • If the attribute is for leaf members, in the Leaf member attributes pane, click Add leaf attribute.

    • If the attribute is for consolidated members, in the Consolidated member attributes pane, click Add consolidated attribute.

    • If the attribute is for collections, in the Collection attributes pane, click Add collection attribute.

  7. On the Add Attribute page, select the Free-form option.

  8. In the Name box, type a name for the attribute. For a list of words that should not be used as attribute names, see Reserved Words (Master Data Services).

  9. In the Display pixel width box, type the width of the attribute column to be displayed in the Explorer grid.

  10. From the Data type list, select DateTime.

  11. From the Input mask list, select a format for dates.

  12. Optionally, select Enable change tracking to track changes to groups of attributes. For more information, see Add Attributes to a Change Tracking Group (Master Data Services).

  13. Click Save attribute.

  14. On the Entity Maintenance page, click Save entity.

To have the user interface display the time portion of a datetime value, you must select an appropriate input mask for the attribute. None of the built-in masks for Datetime attributes do this, but you can add a new mask that will allow you to display time. To do so, add a row in the mdm.tblList table of the MDS database, where the built-in masks are stored. The row should have the following values:

ListCode

lstInputMask

ListName

Input Mask

Seq

19

List Option

dd/MM/yyyy hh:mm:ss

Option ID

19

IsVisible

1

Group_ID

3

After you enter a row with the above values in the mdm.tblList table, the “dd/MMM/yyyy hh:mm:ss” mask will be available in the Input mask list box. You can then select that mask to display the date and time in a datetime attribute column of an entity in the MDS Explorer.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft