...
Data Consistency: Predefined datasets ensure consistency in data selection and entry.
Usability: Users can easily select records from predefined options, reducing the likelihood of errors.
Integration: Seamless integration with external data sources allows for efficient management of datasets.
...
Managing Master Data Tables
Via User Interface
Navigate to Admin Area: Access the admin area of Smartfacts CDCM. (Cogwheel icon at the bottom left in the side menu)
Select Master Data Tables
To add a master data table, press the button Add Master Data Table
Enter a name and a distinct key
Add columns
Each column has a name, a distinct key and a data type. Supported data types are
String
Integer
Double
Decimal
Boolean
Date-Time
Date
Duration
URL
Master Data
Click on button Select Table to reference a master data table
Click on button Set Mask to select certain columns of the selected master data table for use as mask
In addition, one of the rows can also be a row key. The row key attribute determines if values of the column are used for rows attribution. Once value of Row Key cell filled and saved, the row gets also assigned with that value a key property, that can be used to retrieve that row via web services.
Add data
Click on the tab Data
Set up inital data for the table columns
...