Including Custom Attributes in the Model

The procedure of including custom attributes in the model is dependent on the Business Intelligence tool that you are using.

About this task

If you are using Google Looker, complete the following steps to include custom attributes in the model:

Procedure

  1. Log in to Google Looker.
  2. Turn the Development mode On.
  3. Navigate to Develop > unica_campaign_project.
  4. Open Campaign_Views and navigate to the corresponsing file view of the following custom attributes:
    • For Campaign attributes: uarc_camp_cust_attrib.view
    • For Offer attributes: uarc_offer_cust_attrib.view
    • For Cell attributes: uarc_cell_cust_attrib.view
  5. Capture the custom attribute information into the model view file. For example, if theCampaign custom attribute is Business Unit Name, and if the internal of the custom attribute is BUNAME, add following dimension to the uarc_campextattr.view model file: 
    dimension: buname {
	type: string
	sql: ${TABLE}.BUNAME ;;
}
  6. After adding the dimension mentioned in Step 5, the model file code will be as follows: 
    view: uarc_campextattr {
  sql_table_name: UARC_CAMPEXTATTR ;;

  dimension: campaignid {
    type: number
    value_format_name: id
    sql: ${TABLE}.CAMPAIGNID ;;
  }
  dimension: buname {
    type: string
    sql: ${TABLE}.BUNAME ;;
  }

  measure: count {
    type: count
    drill_fields: []
  }
}

    Add all fields into the respective model view file.

    Note: The database refresh process considers all fields as business dimension, which is the string format.