BookmarkSubscribeRSS Feed

Customer Intelligence 360 Plan – What are Custom Properties and How to Configure It?

Started ‎05-31-2019 by
Modified ‎06-07-2019 by
Views 1,128

 

ci360-gcs-tips.png

 

 

 

What are Custom Properties?

Would you like to store unique information within planning objects, digital assets and share it across business process? Customer Intelligence 360 offers ‘Custom Properties’ feature to define and store customer specific information.

 

How to configure Custom Properties?

To configure custom properties, follow the steps mentioned below:

  • Define ‘Custom Properties’ in a Microsoft Excel Spreadsheet as mentioned in the User Guide (Quick link is here)
  • Create three worksheets namely ‘Attributes’, ‘Picklists’ and ‘Dependencies’
    • ‘Attributes’ worksheet will contain objects that custom metadata should be associated with, such as digitalAsset, planningObject, workflowProcess and custom properties
    • ‘Attributes’ worksheet will contain following columns
                                                                            Attributes
Column Name What does it mean? Additional Details
Attribute Group Name Custom Properties Group Name  
Attribute Group Display Text Custom Properties Group Display Name  
Attribute Group Description Custom Properties Group Description  
Class Name of the objects Example: digitalAsset, planningObject, workflowProcess
Associated Categories The categories that are associated with the class These values correspond to the category types in the 'Categories' worksheet.
Attribute Name Custom Properties Field Name  
Display Text Custom Properties Field Display Name  
Description Custom Properties Field Description  
Data Type What kind of data it is Example: Text, Integer, Double
UI Type What is the user interface type Example: Multi-line, Dropdown list, Multi-select,
Format (Optional)Specifies the format for the data type Example: Currency type - DOLLAR10.0 or DOLLAR10.2
Constraints (Optional) Specifies constraints on the values Example: min=–20000;max=20000 or maxlength=150 (for a text field)
Default Value (Optional) Specifies a default value.  
Required Specifies whether an attribute must be set. The value can be true or false.
Search Field Specifies whether the attribute can be found through a search.  
Picklist Values Source The picklist that is associated with this attribute. Set the value to the name of the Picklists worksheet combined with the picklist name: Picklists.<picklist name>
Obsolete Specifies whether the attribute or attribute group is obsolete. The value can be true or false.
Ad Hoc Specifies whether this property is added through the user interface. The value can be true or false.
Dynamic Specifies whether the custom property’s value is populated dynamically by another product or solution. The value can be true or false.



  • ‘Picklists’ worksheet will contain predefined values that you want users to fill in fields. For example: If you want users to select from predefined list of brand names, then 'Picklists' worksheet will contain details about all brand names
  • ‘Picklists’ worksheet will contain following columns
                                                         Picklists
Column Name What does it mean? Additional Details
Picklist Name The name of the picklist  
Picklist Display Text The text that is displayed in the user interface for the picklist  
Picklist Description The description for the picklist  
Picklist Data type What kind of data it is Example: Text, Integer, Double
Picklist Value Name The values for the picklist as they are stored in the system  
Picklist Value Display Text The text in the user interface that is displayed for each of the picklist’s values.  
Obsolete Specifies whether the attribute or attribute group is obsolete. The value can be true or false.
  • ‘Dependencies’ worksheet contains lists of fields in which if a value of next field is dependent on value of a certain field. For example: List of states is dependent on name of the country. ‘Dependencies’ worksheet allows you to define such correlation between two fields
  • ‘Dependencies’ worksheet will contain following columns
                                                Dependencies
Column Name What does it mean? Additional Details
Dependency Name The name of the dependency  
Dependency Type The behavior type of the dependency Set the value to either value or visibility
Dependent Attribute Group Name The group that the specified dependent attribute belongs to This group corresponds to a value in the Attribute Group Name column of the Attributes worksheet
Dependent Attribute Name The name of the dependent attribute  
Parent Attribute Group Name The group that the specified parent attribute belongs to in the Attributes worksheet  
Parent Attribute Name The name of the parent attribute This name corresponds to a value in the Attribute Name column of the Attributes worksheet
Parent Attribute Value The values that must be entered by the user in order to show the dependent attribute  
Table Column The value of a column in a table-driven worksheet  
Operator The operator used to evaluate the Table Column entry Valid operators are eq or ne

 

  • Login to Customer Intelligence 360
  • Go to ‘General Settings’ under ‘Configuration’
  • Click on ‘Data Sources’ under ‘Data Management’
  • Click on ‘Upload Data’ icon
  • Click on ‘Custom Properties’
  • Browse the file
  • Click on ‘Upload Data’ button
  • Click on ‘Close’ button
  • Under ‘Data Sources’, click on ‘View Job Information’ icon to check the status of uploaded data

P.S. Example for custom properties for Digital Asset is attached with this post

Version history
Last update:
‎06-07-2019 02:27 AM
Updated by:
Contributors

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags