Creating custom intelligent attributes
Oracle Unity allows you to create custom intelligent attributes.
In this topic:
Introduction
Custom intelligent attributes enable you to enrich your data objects with new attributes to meet your business needs. Ensure to review the ready-to-use intelligent attributes before creating custom intelligent attributes.
When you are thinking and planning about the custom intelligent attributes to create, it's important to clearly understand the operation or calculation you are looking to design, and then identify the key attribute behind the operation or calculation.
Use cases
Custom intelligent attributes are created for business use cases the ready-to-use intelligent attributes do not already meet. These are some examples of custom intelligent attributes:
-
Most purchased brand
Tracks the brand purchased most often.
-
Percent of money spent, returned
The percent of money a customer spent on purchases, then returned.
-
Average purchased item value
The average value of individual items purchased.
-
Percent of discounted items purchased
The percentage of items purchased by a customer that are discounted.
Metadata requirements
Custom intelligent attributes rely on other metadata objects to define the operations and calculations for the custom intelligent attribute. Note these metadata requirements.
Data source views
The Data source view linked to the new intelligent attribute must meet the following requirements. If one of the below requirements are not met, the custom intelligent attribute will not be successfully created.
-
A unique
dataSourceViewID. -
A complete
sourceTableQuerythat surfaces the attributes needed by the Model object.
To update the data source view:
- Get the data source view attribute that needs to be added.
- Create the query to get the existing data source view definition.
- Copy the response and the data source view attribute in the output attributes section and create the request.
Here is an example for the Average Purchased Item Value attribute updating the Data Source View "OrderItemDSV".
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "shipped"
}
]
}
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "ID"
},
{
"atype": ".StaticAttribute",
}
],
"alias": "purchase_orderitem_id"
}
Here is an example
[
{
"tenantId": 341,
"name": "CA_OrderItemDSV",
"versionTS": 1590157473011,
"active": true,
"lastModifiedBy": "MCPS_TEST_ADMIN_USER",
"createdTS": 1549677144859,
"dataSourceViewID": "CA_OrderItemDSV",
"sourceTableQuery": {
"MCPSQuery": {
"tenantId": 0,
"name": "OrderItem_Analytics",
"uniqueId": "OrderItem_Analytics",
"operation": {
"ctype": ".SetOperation",
"name": "TopOp",
"tenantId": 0,
"uniqueId": "query1",
"operands": [
Here is an example
{
"tenantId": 341,
"name": "CA_OrderItemDSV",
"active": true,
"dataSourceViewID": "CA_OrderItemDSV",
"sourceTableQuery": {
"MCPSQuery": {
"tenantId": 0,
"name": "OrderItem_Analytics",
"uniqueId": "OrderItem_Analytics",
"operation": {
"ctype": ".SetOperation",
"name": "TopOp",
"tenantId": 0,
"uniqueId": "query1",
"operands": [
{
"ctype": ".ObjectSet",
"tenantId": 0,
"name": "C1",
"description": "C1",
"objectName": "OrderItem",
"uniqueId": "DataWranglingOrderItem",
"outputAttributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "CustomerID",
"alias": "CustomerID"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "shipped"
}
]
}
},
{
"atype": ".FunctionAttribute",
"type": "CAST",
"attributes": [
{
"atype": ".FunctionAttribute",
"type": "UNIX_TIME",
"attributes": [
{
"atype": ".FunctionAttribute",
"type": "TIMESTAMP",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "OrderEntryTS"
}
]
},
{
"atype": ".StaticAttribute",
"data": "yyyyMMdd"
}
]
},
{
"atype": ".StaticAttribute",
"data": "INT"
}
]
},
{
"atype": ".StaticAttribute",
"data": 20700101
}
],
"alias": "first_purchase_date"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "shipped"
}
]
}
},
{
"atype": ".FunctionAttribute",
"type": "CAST",
"attributes": [
{
"atype": ".FunctionAttribute",
"type": "UNIX_TIME",
"attributes": [
{
"atype": ".FunctionAttribute",
"type": "TIMESTAMP",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "OrderEntryTS"
}
]
},
{
"atype": ".StaticAttribute",
"data": "yyyyMMdd"
}
]
},
{
"atype": ".StaticAttribute",
"data": "INT"
}
]
},
{
"atype": ".StaticAttribute",
"data": 19691231
}
],
"alias": "last_purchase_date"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "demand"
}
]
}
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "OrderID"
},
{
"atype": ".StaticAttribute"
}
],
"alias": "demand_orderid"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "shipped"
}
]
}
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "ID"
},
{
"atype": ".StaticAttribute"
}
],
"alias": "purchase_orderitem_id"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "shipped"
}
]
}
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "OrderID"
},
{
"atype": ".StaticAttribute"
}
],
"alias": "purchase_orderid"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "returned"
}
]
}
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "OrderID"
},
{
"atype": ".StaticAttribute"
}
],
"alias": "return_orderid"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "shipped"
}
]
}
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "ExtendedPrice"
},
{
"atype": ".StaticAttribute",
"data": 0
}
],
"alias": "purchase_ExtendedPrice"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "IN",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "shipped"
},
{
"ctype": ".StaticAttribute",
"data": "returned"
}
]
}
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "ExtendedPrice"
},
{
"atype": ".StaticAttribute",
"data": 0
}
],
"alias": "spent_ExtendedPrice"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "returned"
}
]
}
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "ExtendedPrice"
},
{
"atype": ".StaticAttribute",
"data": 0
}
],
"alias": "return_ExtendedPrice"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "shipped"
}
]
}
},
{
"atype": ".FunctionAttribute",
"type": "MONTH",
"attributes": [
{
"atype": ".FunctionAttribute",
"type": "CAST",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "OrderEntryTS"
},
{
"atype": ".StaticAttribute",
"data": "STRING"
}
]
}
]
},
{
"atype": ".StaticAttribute",
"data": 0
}
],
"alias": "order_month"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "shipped"
}
]
}
},
{
"atype": ".FunctionAttribute",
"type": "MONTH",
"attributes": [
{
"atype": ".FunctionAttribute",
"type": "CAST",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "OrderEntryTS"
},
{
"atype": ".StaticAttribute",
"data": "STRING"
}
]
}
]
},
{
"atype": ".StaticAttribute",
"data": 0
}
],
"alias": "order_hour"
},
{
"atype": ".FunctionAttribute",
"type": "CASE",
"attributes": [
{
"atype": ".CriteriaAttribute",
"criteria": {
"ctype": ".Criteria",
"operator": "EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "shipped"
}
]
}
},
{
"atype": ".FunctionAttribute",
"type": "UNIX_TIME",
"attributes": [
{
"atype": ".FunctionAttribute",
"type": "TIMESTAMP",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "OrderEntryTS"
}
]
},
{
"atype": ".StaticAttribute",
"data": "u"
}
]
},
{
"atype": ".StaticAttribute",
"data": 0
}
],
"alias": "order_dayofweek"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C_PROD",
"attributeName": "ProductName",
"alias": "ProductName"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C_PROD",
"attributeName": "Brand",
"alias": "Brand"
},
{
"atype": ".FunctionAttribute",
"type": "COMPLEX_FUNCTION",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C_PROD",
"attributeName": "Cat_Set",
"alias": "Cat_Set"
},
{
"atype": ".StaticAttribute",
"data": 0
}
],
"alias": "category_1"
},
{
"atype": ".FunctionAttribute",
"type": "CAST",
"attributes": [
{
"atype": ".FunctionAttribute",
"type": "UNIX_TIME",
"attributes": [
{
"atype": ".FunctionAttribute",
"type": "TIMESTAMP",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "OrderEntryTS"
}
]
},
{
"atype": ".StaticAttribute",
"data": "yyyyMMdd"
}
]
},
{
"atype": ".StaticAttribute",
"data": "INT"
}
],
"alias": "order_date"
}
],
"distinct": false,
"criteria": {
"ctype": ".Criteria",
"operator": "NOT_EQUALS",
"operands": [
{
"ctype": ".FunctionAttribute",
"type": "LOWER",
"attributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "SubType"
}
]
},
{
"ctype": ".StaticAttribute",
"data": "cancelled"
}
]
},
"objectJoin": {
"type": "LEFT_OUTER",
"condition": [
{
"left": {
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "ProductID"
},
"right": {
"atype": ".ReferenceAttribute",
"tableName": "C_PROD",
"attributeName": "ID"
}
}
],
"targetSet": {
"ctype": ".ObjectSet",
"tenantId": 0,
"name": "C_PROD",
"description": "C_PROD",
"objectName": "Product",
"uniqueId": "c_product",
"outputAttributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C_PROD",
"attributeName": "ID",
"alias": "ID"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C_PROD",
"attributeName": "Name",
"alias": "ProductName"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C_PROD",
"attributeName": "Brand",
"alias": "Brand"
},
{
"atype": ".AggregateAttribute",
"type": "COLLECT_SET",
"attribute": {
"atype": ".ReferenceAttribute",
"tableName": "C_PROD_CAT",
"attributeName": "Cat_Name",
"alias": "Cat_Name"
},
"alias": "Cat_Set"
}
],
"distinct": false,
"groupBy": [
{
"atype": ".ReferenceAttribute",
"tableName": "C_PROD",
"attributeName": "ID",
"alias": "ID"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C_PROD",
"attributeName": "Name",
"alias": "ProductName"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C_PROD",
"attributeName": "Brand",
"alias": "Brand"
}
],
"objectJoin": {
"type": "LEFT_OUTER",
"condition": [
{
"left": {
"atype": ".ReferenceAttribute",
"tableName": "C_PROD",
"attributeName": "ID"
},
"right": {
"atype": ".ReferenceAttribute",
"tableName": "C_PROD_CAT",
"attributeName": "ProductID"
}
}
],
"targetSet": {
"ctype": ".ObjectSet",
"tenantId": 0,
"name": "C_PROD_CAT",
"description": "C_PROD_CAT",
"objectName": "Product_Category",
"uniqueId": "c_product",
"outputAttributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C_PROD_CAT",
"attributeName": "ProductID",
"alias": "ProductID"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C_PROD_CAT",
"attributeName": "CategoryID",
"alias": "CategoryID"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C_CAT",
"attributeName": "Cat_Name",
"alias": "Cat_Name"
}
],
"distinct": false,
"objectJoin": {
"type": "LEFT_OUTER",
"condition": [
{
"left": {
"atype": ".ReferenceAttribute",
"tableName": "C_PROD_CAT",
"attributeName": "CategoryID"
},
"right": {
"atype": ".ReferenceAttribute",
"tableName": "C_CAT",
"attributeName": "ID"
}
}
],
"targetSet": {
"ctype": ".ObjectSet",
"tenantId": 0,
"name": "C_CAT",
"description": "C_CAT",
"objectName": "Category",
"uniqueId": "C_CAT",
"outputAttributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C_CAT",
"attributeName": "ID",
"alias": "ID"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C_CAT",
"attributeName": "Name",
"alias": "Cat_Name"
}
],
"distinct": false
}
}
}
}
}
}
},
null
],
"operator": "UNION",
"distinct": false,
"outputAttributes": [
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "CustomerID",
"alias": "CustomerID"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "first_purchase_date",
"alias": "first_purchase_date"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "last_purchase_date",
"alias": "last_purchase_date"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "demand_orderid",
"alias": "demand_orderid"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "purchase_orderitem_id",
"alias": "purchase_orderitem_id"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "purchase_orderid",
"alias": "purchase_orderid"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "return_orderid",
"alias": "return_orderid"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "purchase_ExtendedPrice",
"alias": "purchase_ExtendedPrice"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "spent_ExtendedPrice",
"alias": "spent_ExtendedPrice"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "return_ExtendedPrice",
"alias": "return_ExtendedPrice"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "order_month",
"alias": "order_month"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "order_hour",
"alias": "order_hour"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "order_dayofweek",
"alias": "order_dayofweek"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "ProductName",
"alias": "ProductName"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "Brand",
"alias": "Brand"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "category_1",
"alias": "category_1"
},
{
"atype": ".ReferenceAttribute",
"tableName": "C1",
"attributeName": "order_date",
"alias": "order_date"
}
],
"joinConditions": [
]
},
"type": "DW"
}
}
}
Models
The Model linked to the new intelligent attribute must meet the following requirements. If one of the below requirements are not met, the custom intelligent attribute will not be successfully created.
| Property | Required? | Data type | Description |
|---|---|---|---|
modelId
|
Yes | String | Unique identifier of the Model. |
type
|
Yes | String | The type of Model. Possible values include: Data Wrangling/ Customer Analytics / Sales / Product. |
dataSourceViewId
|
Yes | String | The Data Source View ID for the associated Data Source View. |
cube
|
Yes | Object | The associated cube for the model. |
incrementalField
|
Yes | Object |
Information about the attribute from a Data Source View to use to increment the data. The parameters |
incrementalFieldFormat
|
Yes | Date/timestamp | Date and time format to use for the incremental field. Must be "yyyyMMDD". |
Explore your models to find if the key attribute is already expressed within a model. If it is, then review its dimensions and measures to see if the desired operation or calculation is already exposed. If the operation or calculation is already exposed, you can reuse the model. Otherwise if the operation or calculation is not exposed, you must create a cube and define new dimensions and measures.
Cubes
A cube is a component of a Model. The Cube linked to the new intelligent attribute must meet the following requirements. If one of the below requirements are not met, the custom intelligent attribute will not be successfully created.
| Property | Required? | Data type | Description | Possible values |
|---|---|---|---|---|
cubeId
|
Yes | String | The Cube's unique identifier. | |
modelId
|
Yes | String | The ID of the Model linked to the Cube. | |
status
|
Yes | String |
The status of the Cube. |
|
state
|
Yes | String | The state of the Cube. |
|
type
|
Yes | String | The type of Model. |
|
dataSourceViewId
|
Yes | String | The Data Source View ID for the associated Data Source View. | |
cube
|
Yes | Object | The associated cube for the model. | |
incrementalField
|
Yes | Object |
Information about the attribute from a Data Source View to use to increment the data. The parameters |
|
incrementalFieldFormat
|
Yes | Date/timestamp | Date and time format to use for the incremental field. Must be "yyyyMMDD". |
Within Cubes, "measures" define additional information about the custom intelligent attribute.
To add a measure to a Cube:
- Create an API call to retrieve the existing Cube definition.
- Add the measure to the measures field.
- Create an API call to update the Cube metadata and update the Cube "state" to DELETED.
- In Oracle Unity, publish the changes. This will delete the Cube.
- Create an API call to update the Cube metadata and update the Cube "state" to ACTIVE.
- In Oracle Unity, publish the changes. This will create the Cube with the new metadata.
- Create an API call to retrieve the existing Cube definition. Confirm that the Cube has the new measure.
- In Oracle Unity, go to the Data feeds page and Start the System - Identity resolution pipeline job. This will populate the Cube with the new attribute data.
Here is an example.
{
"ctype": ".Cube",
"tenantId": 341,
"name": "CA_EventDSV",
"versionTS": 1585593984501,
"active": true,
"lastModifiedBy": "ec1b711f42d94d71877c901f68d5f938",
"createdTS": 1549677145238,
"cubeId": "CA_EventCube",
"modelId": "CA_EventModel",
"state": "ACTIVE",
"status": "READY",
"dimensions": [
{
"tenantId": 341,
"name": "CustomerID",
"versionTS": 1549677145272,
"active": true,
"createdTS": 1549677145272,
"dimensionId": "CustomerID",
"cubeId": "CA_EventCube",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "CustomerID"
},
"shardByColumn": true
}
],
"measures": [
{
"tenantId": 341,
"name": "last_sent_eventdate",
"versionTS": 1562180665534,
"active": true,
"createdTS": 1549677145299,
"measureId": "last_sent_eventdate",
"cubeId": "CA_EventCube",
"operation": "MAX",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "sent_eventDate"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "last_clicked_eventdate",
"versionTS": 1562180665573,
"active": true,
"createdTS": 1549677145308,
"measureId": "last_clicked_eventdate",
"cubeId": "CA_EventCube",
"operation": "MAX",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "clicked_eventDate"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "last_opened_eventdate",
"versionTS": 1562180665613,
"active": true,
"createdTS": 1549677145317,
"measureId": "last_opened_eventdate",
"cubeId": "CA_EventCube",
"operation": "MAX",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "opened_eventDate"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "last_subscribed_eventdate",
"versionTS": 1562180665651,
"active": true,
"createdTS": 1549677145326,
"measureId": "last_subscribed_eventdate",
"cubeId": "CA_EventCube",
"operation": "MAX",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "subscribed_eventDate"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "last_unsubscribed_eventdate",
"versionTS": 1562180665690,
"active": true,
"createdTS": 1549677145334,
"measureId": "last_unsubscribed_eventdate",
"cubeId": "CA_EventCube",
"operation": "MAX",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "unsubscribed_eventDate"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "last_email_opened_eventdate",
"versionTS": 1562180665728,
"active": true,
"createdTS": 1549677145342,
"measureId": "last_email_opened_eventdate",
"cubeId": "CA_EventCube",
"operation": "MAX",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "email_opened_eventdate"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "last_push_opened_eventdate",
"versionTS": 1562180665766,
"active": true,
"createdTS": 1549677145350,
"measureId": "last_push_opened_eventdate",
"cubeId": "CA_EventCube",
"operation": "MAX",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "push_opened_eventdate"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "last_sms_opened_eventdate",
"versionTS": 1562180665802,
"active": true,
"createdTS": 1549677145358,
"measureId": "last_sms_opened_eventdate",
"cubeId": "CA_EventCube",
"operation": "MAX",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "sms_opened_eventdate"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "last_delivered_eventdate",
"versionTS": 1562180665837,
"active": true,
"createdTS": 1549677145367,
"measureId": "last_delivered_eventdate",
"cubeId": "CA_EventCube",
"operation": "MAX",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "delivered_eventdate"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "last_bounced_eventdate",
"versionTS": 1562180665874,
"active": true,
"createdTS": 1549677145375,
"measureId": "last_bounced_eventdate",
"cubeId": "CA_EventCube",
"operation": "MAX",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "bounced_eventDate"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_clicked_count",
"versionTS": 1562180665912,
"active": true,
"createdTS": 1549677145383,
"measureId": "total_clicked_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "clicked_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_email_clicked_count",
"versionTS": 1562180665955,
"active": true,
"createdTS": 1549677145392,
"measureId": "total_email_clicked_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "email_clicked_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_push_clicked_count",
"versionTS": 1562180665996,
"active": true,
"createdTS": 1549677145400,
"measureId": "total_push_clicked_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "push_clicked_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_sms_clicked_count",
"versionTS": 1562180666041,
"active": true,
"createdTS": 1549677145408,
"measureId": "total_sms_clicked_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "sms_clicked_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_opened_count",
"versionTS": 1562180666079,
"active": true,
"createdTS": 1549677145417,
"measureId": "total_opened_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "opened_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_email_opened_count",
"versionTS": 1562180666119,
"active": true,
"createdTS": 1549677145425,
"measureId": "total_email_opened_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "email_opened_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_push_opened_count",
"versionTS": 1562180666156,
"active": true,
"createdTS": 1549677145434,
"measureId": "total_push_opened_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "push_opened_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_sms_opened_count",
"versionTS": 1562180666193,
"active": true,
"createdTS": 1549677145444,
"measureId": "total_sms_opened_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "sms_opened_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_sent_count",
"versionTS": 1562180666230,
"active": true,
"createdTS": 1549677145453,
"measureId": "total_sent_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "sent_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_email_sent_count",
"versionTS": 1562180666267,
"active": true,
"createdTS": 1549677145461,
"measureId": "total_email_sent_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "email_sent_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_push_sent_count",
"versionTS": 1562180666302,
"active": true,
"createdTS": 1549677145470,
"measureId": "total_push_sent_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "push_sent_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_sms_sent_count",
"versionTS": 1562180666341,
"active": true,
"createdTS": 1549677145478,
"measureId": "total_sms_sent_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "sms_sent_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_delivered_count",
"versionTS": 1562180666381,
"active": true,
"createdTS": 1549677145486,
"measureId": "total_delivered_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "delivered_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "total_bounced_count",
"versionTS": 1562180666416,
"active": true,
"createdTS": 1549677145494,
"measureId": "total_bounced_count",
"cubeId": "CA_EventCube",
"operation": "COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "bounced_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "most_popular_response_day",
"versionTS": 1562180666454,
"active": true,
"createdTS": 1549677145503,
"measureId": "most_popular_response_day",
"cubeId": "CA_EventCube",
"operation": "TOP",
"type": "STATIC",
"sourceAttribute": {
"atype": ".StaticAttribute",
"data": 1
},
"groupByAttributes": [
{
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "opened_event_dayofweek"
}
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "most_popular_response_hour",
"versionTS": 1562180666494,
"active": true,
"createdTS": 1549677145512,
"measureId": "most_popular_response_hour",
"cubeId": "CA_EventCube",
"operation": "TOP",
"type": "STATIC",
"sourceAttribute": {
"atype": ".StaticAttribute",
"data": 1
},
"groupByAttributes": [
{
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "opened_event_hour"
}
],
"sortedAttributes": [
],
"properties": {
},
"extraColumns": [
]
},
{
"tenantId": 341,
"name": "lastx_sms_sent_count",
"versionTS": 1585646435638,
"active": true,
"createdTS": 1585593986378,
"measureId": "lastx_sms_sent_count",
"cubeId": "CA_EventCube",
"operation": "LAST_X_COUNT_DISTINCT",
"type": "REFERENCE",
"sourceAttribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "sms_sent_messageid"
},
"groupByAttributes": [
],
"sortedAttributes": [
{
"atype": ".SortedAttribute",
"order": "DESC",
"attribute": {
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "event_date"
}
}
],
"properties": {
"1.label": "current_week",
"1.end_daysago": "1",
"1.end_truncateto": "WEEK",
"2.label": "current_year",
"2.end_yearsago": "1",
"2.end_truncateto": "YEAR"
},
"extraColumns": [
"lastx_sms_sent_count_current_week",
"lastx_sms_sent_count_current_year"
]
}
],
"dedupeTargetId": "Customer_MasterCustomer",
"masterIdentifiers": [
{
"atype": ".DSVAttribute",
"dsvId": "CA_EventDSV",
"attributeName": "CustomerID"
}
],
"config": {
},
"aggregationSettings": [
]
}
You will need to use a Cube measure to create the intelligent attribute. You can use the Cube measure as is (.ReferenceAttribute) or use it with supported functions (.FunctionAttribute).
If the Cube measure you need doesn't currently exist for the Cube, then follow the steps below to adding a Cube measure. Otherwise skip this task.
If the measure you are adding can be added with data in data source view attribute, continue with adding the measure to the Cube. If the attribute needed is not available in the data source view, follow the steps below for updating the data source view.
Creating custom intelligent attributes
Here are the high-level steps to create a custom intelligent attribute:
Step 1: Verify the attributeId is unique
You will need to verify that no existing intelligent attribute uses the attributeId you are creating.
To verify the attributeId is unique:
- Create an API call to retrieve the attributeId.
- Review the response to verify the attributeId is unique.
Step 2: Create the intelligent attribute
-
Send a request to create an intelligent attribute, for more information see the examples.
-
In Oracle Unity, visit the Intelligent attributes page to confirm the new intelligent attribute is listed. It will have an Inactive status.
Step 3: Activate the custom intelligent attribute
After creating the custom intelligent attribute, you will have to make it active so that you can access it from the segmentation canvas.
To activate the intelligent attribute:
- Open the navigation menu and select Intelligent attributes.
- Click the Action menu for the intelligent attribute and select Make active.
You will now have to publish the changes to implement the update to the intelligent attribute.
Step 4: Publish the changes
When you publish the changes, Oracle Unity adds the intelligent attribute to the MasterCustomer data object.
To publish the changes:
- Open the navigation menu and select Data model.
- In the top-right corner, click Publish changes.
- Confirm the publish job and click Publish.
- A notification will display to confirm the publish job successfully started.
Note: If a publish job is currently in progress, you will receive a notification that the publish job cannot run until the publish job already in progress completes.
You can monitor the status of the job from the Jobs dashboard.
Step 5: Run the Identity resolution pipeline job
The last task is to run the Identity resolution pipeline job so that Oracle Unity can calculate the values for the intelligent attribute.
To run the Identity resolution pipeline job:
- Open the navigation menu and select Data feeds. The jobs will be displayed at the top of the list of data feeds with the other system jobs.
- Click the Action menu for System - Identity resolution pipeline job and select Start.
The custom intelligent attribute will now have values and be available on the segmentation canvas.