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
|
|---|
|
The attribute is called DateTime, but time values are not supported. |
To perform this procedure:
-
You must have permission to access the System Administration functional area.
-
You must be a model administrator. For more information, see Administrators (Master Data Services).
-
You must have an entity to create the attribute for. For more information, see Create an Entity (Master Data Services).
To create a date attribute
-
In Master Data Manager, click System Administration.
-
On the Model View page, from the menu bar, point to Manage and click Entities.
-
On the Entity Maintenance page, from the Model list, select a model.
-
Select the row for the entity that you want to create an attribute for.
-
Click Edit selected entity.
-
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.
-
-
On the Add Attribute page, select the Free-form option.
-
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).
-
In the Display pixel width box, type the width of the attribute column to be displayed in the Explorer grid.
-
From the Data type list, select DateTime.
-
From the Input mask list, select a format for dates.
-
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).
-
Click Save attribute.
-
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.
