Add a Data Dictionary
Data Dictionaries contain a set of pre-defined values that can be assigned to attributes in Creo Elements/Direct Drawing Manager. You can either use the Data Dictionary provided with Creo Elements/Direct Drawing Manager or create your Data Dictionary.
To create a data dictionary,
1. In Creo Elements/Direct Drawing Manager Standalone, click Admin on the Workspace Bar.
2. In the left pane, under What do you want to manage?, click Data Dictionaries. The Data Dictionary Management pane opens.
3. In the left pane, under Data Dictionary, click Create New. The Create Data Dictionary dialog box opens.
4. Set the following values for the Data Dictionary:
◦ Name: Type a name for the Data Dictionary.
|
Choose a name which indicates the function of the Data Dictionary.
|
◦ DD Type: Select a Data Dictionary type. You can select one of the following types:
▪ base
▪ enumstr
▪ rangeint
▪ rangeflt
▪ rangetime
▪ coltype
◦ Base Type: Select a base type. Depending on the
DD Type, the value in the
Base Type box changes. For more information, see
Table 4.
◦ Value: Specify whether the value for the Data Dictionary is Required, or Optional, or Not Used.
|
If the Data Dictionary is Required and the Data Dictionary assigned to an attribute, right-click the attribute and select Enable setting of attribute during save. This allows you to type a value for the attribute during the Save operation. Otherwise, the Save operation fails.
|
◦ Default Value: Specify the default value for the Data Dictionary. This is optional.
◦ The following settings are available depending on the
DD Type and the
Base Type. For more information, see
Table 4.
▪ Round Off: For float values, limit the number of digits after point.
▪ Number of Decimals: Type the number of digits after decimal point to round off.
▪ String Case: Select one of the following:
▪ As Is: Retains your original string.
▪ All Uppercase: Converts the alphabets of the string to uppercase characters.
▪ All Lowercase: Converts the alphabets of the string to lowercase characters.
▪ Title Case: Converts the alphabets of the string to title-case characters.
▪ Trim: Removes the blank spaces from the left of the string.
▪ Truncation: Reduces the length of the string.
▪ Length: Specify the length to which the string must be reduced.
|
You need not reduce the length for database efficiency.
|
▪ Min and Max: For the rangeint, rangeflt or rangetime base types, type the minimum and the maximum limits.
▪ Table Name: Select a table name.
▪ Column Name: Select a column name.
▪ Enumeration Values: You can add or delete values available in the list. To add a value, click
and type the value in the
Add Enumeration Value box. To remove a value, select the value and click
.
| • If you click the Allow Values Outside of List check box, you can either select a value in the Enumeration Values or type a value. • You must click the Allow Values Outside of List check box if you create a Data Dictionary for the View attributes in BOM. |
Table 1
DD Type | Base Type | Value | Default Value | Round Off | Number of Decimals | String case | Trim | Truncation | Length | Min | Max | Table Name | Column Name | Enumeration values |
---|
base | INTEGER | yes | yes | no | no | no | no | no | no | no | no | no | no | no |
SMALLINT | yes | yes | no | no | no | no | no | no | no | no | no | no | no |
FLOAT | yes | yes | yes | yes | no | no | no | no | no | no | no | no | no |
VARCHAR | yes | yes | no | no | yes | yes | yes | yes | no | no | no | no | no |
CHAR | yes | yes | no | no | yes | yes | yes | yes | no | no | no | no | no |
UTC_TIME | yes | yes | no | no | no | no | no | no | no | no | no | no | no |
enumstr | VARCHAR | yes | yes | no | no | yes | yes | yes | yes | no | no | no | no | yes |
CHAR | yes | yes | no | no | yes | yes | yes | yes | no | no | no | no | yes |
rangeint | INTEGER | yes | yes | no | no | no | no | no | no | yes | yes | no | no | no |
rangeflt | FLOAT | yes | yes | yes | yes | no | no | no | no | yes | yes | no | no | no |
rangetime | UTC_TIME | yes | yes | no | no | no | no | no | no | yes | yes | no | no | no |
coltype | | yes | yes | no | no | yes | yes | yes | yes | no | no | yes | yes | no |