Object Values
- [Object Attributes] Adding custom attributes or properties to objects
- [Object Structures] Grouping and structuring object values in hierarchies
The object values are the members of the dimensions or the actual definitions of, for example, the customers or the departments.
Access Object Values by selecting Client administration > Objects > Objects > Object Values.
To add a new object value to the object, select the New button. Enter information and select Save.
To delete an object, select one or more records and press Delete. Only object values with no related data in the system can be deleted.
If you started to delete records, you can view the deleted row by clicking the View Deleted Rows button before you save the data in the grid.
Select Refresh to update and get the current data from the database.
The autofit, group, filter, and search functions make it easier to work with the data. It's also possible to sort the data by clicking on the column headers.
Select Export to export the data to an Excel file. Work with the Excel file and then upload the updated date using the Import button.
Below is a list of Object Value fields:
Field | Description | Example | Note |
|---|---|---|---|
Object value | The unique identifier of the object value. | 3010 | Keep short, no spaces. |
Description | The description of the object value. | Product revenue sales | |
[Custom defined attributes] | If any object attributes have been defined they will show as additional columns here. | ||
Active | Defines if the object value is active and available in other areas of the system. | ||
Valid from | Defines a start date from when the object value is valid and active in other areas of the system. | ||
Valid to | Defines the stop date to when the object value is valid and active in other areas of the system. | ||
Manual | Defines if the object value is created and should be maintained by a user, and not automatically maintained and updated by integration from other data sources. | This also impacts the maintenance of object attributes and object structures. | |
Updated by (Read Only) | Shows the user identity of the last user that updated the record. | Is set to DIUSER if standard integration procedures are used to integrate data. | |
Updated (Read Only) | Shows the date and time when the record was last updated. |
Additional Information
Manual - Defines if the object value should be maintained manually by a user, or by the integration. If yes, then the integration standard procedure to load object values will not update the record (stg.p_update_object_values). Also, the procedure to load object values attributes will not update or delete any attribute data related to the object value (stg.p_update_object_value_attributes).