Strategy One

Attributes Array

The attributes array defines the business dimensions by which data can be grouped or filtered (for example, Call Center, Day Date). Attributes are composed of one or more "forms" (such as an ID form and a Description form) and can include "smart attributes" for time-based groupings.

Attribute Properties

Field Type Description Example

information

Object

Core identity of the attribute. Contains primaryLocale (the locale of the user who created the object), objectId (the unique 32-character hex identifier for the object), subType (attribute), name, and description.

 { name: "Day Date (2)" }

forms

Array

Different representations of the attribute such as ID, DESC, and more

[ { name: "Day Date" } ]

smartAttributes

Array

Automatically generated variations such as Hour, Day, and Week intervals. This field is optional.

 [ { smartAttributeType: "hour_interval" } ]
attributeLookupTable

Object

The primary logical table used to look up attribute elements.

{ name: "lu_day" }

keyForm

Object

Identifies which form acts as the primary key.

 { name: "Day Date" }

displays

Object

Defines report/browse display settings.

{ reportDisplays: [...] }

acl Object Access Control List for sensitive dimensions. For more information, see Access Control List. { "...": { granted: 255 } }

translations

Object

Localized strings for name and description. For more information, see Translations.

{ name: {...} }

nonAggregatable Boolean If true, this attribute cannot be used in simple aggregations. false

autoDetectLookupTable

Boolean

Defines whether to automatically infer the lookup table.

true

Form Properties

See the following structure in the forms array:

Field Type Description Example

id and name

 String

Form identity.

 { name: "Day Date" }

category

String

The category such as "ID", "DESC", and more.

"ID"

displayFormat

String

Formatting for the user interface such as "date_time", "text", "number", and more.

 "date_time"

dataType

Object

Precision, scale, and base type.

{ type: "time_stamp", precision: 26 }

expressions Array Column mappings across different tables. [ { expression: { text: "day_date" } } ]

lookupTable

Object

The specific lookup table for this form.

{ name: "lu_day" }

semanticRole String The role of the form. "datetime"

Example

See the following attribute file example:

Copy 
attributes:
- information:
    primaryLocale: "en-US"
    objectId: "5B17B8A3FEA64831878D042B5276C9FB"
    subType: "attribute"
    name: "Day Date (2)"
    description: "Date of the day in format YYYY-MM-DD HH:MM:SS.S"
  forms:
  - id: "45C11FA478E745FEA08D781CEA190FE5"
    name: "Day Date"
    description: "Date of the day in format YYYY-MM-DD HH:MM:SS.S"
    category: "ID"
    type: "system"
    displayFormat: "date_time"
    dataType:
      type: "time_stamp"
      precision: 26
      scale: 6
    expressions:
    - expression:
        text: "day_date"
      tables:
      - objectId: "87337802ED73459C9C721C45C653CB62"
        subType: "logical_table"
        name: "day_ctr_sls"
    - expression:
        text: "day_date"
      tables:
      - objectId: "A2C871BF7FB24D609E9213296EE1B8C7"
        subType: "logical_table"
        name: "lu_day"
    alias: "day_date"
    lookupTable:
      objectId: "A2C871BF7FB24D609E9213296EE1B8C7"
      subType: "logical_table"
      name: "lu_day"
    semanticRole: "datetime"
  smartAttributes:
  - information:
      primaryLocale: "en-US"
      objectId: "573D4738D78A4A4AAE1A1FCE059A01EC"
      subType: "attribute_smart"
      name: "Day Date (1) (15 min)"
    smartAttributeType: "15_min_interval"
    ascending: true
    forms:
    - id: "45C11FA478E745FEA08D781CEA190FE5"
      name: "ID"
      category: "ID"
      type: "system"
      displayFormat: "date_time"
      dataType:
        type: "time_stamp"
        precision: 0
        scale: 0
      alias: ""
    displays:
      reportDisplays:
      - id: "45C11FA478E745FEA08D781CEA190FE5"
        name: "ID"
      browseDisplays:
      - id: "45C11FA478E745FEA08D781CEA190FE5"
        name: "ID"
    acl:
      "294DEDC011D2F1D56000D98E67019608":
        granted: 255
        denied: 0
        inheritable: false
      "37DECDD94EAA4A2AF3C7A6B17080DADF":
        granted: 255
        denied: 0
        inheritable: false
      C82C6B1011D2894CC0009D9F29718E4F:
        granted: 255
        denied: 0
        inheritable: false
    translations:
      name:
        targetName: "Object Name"
        translationValues:
          1033:
            translation: "Day Date (1) (15 min)"
  - information:
      primaryLocale: "en-US"
      objectId: "99D958143D264135AD252FD03B9DEE13"
      subType: "attribute_smart"
      name: "Day Date (1) (30 min)"
    smartAttributeType: "30_min_interval"
    ascending: true
    forms:
    - id: "45C11FA478E745FEA08D781CEA190FE5"
      name: "ID"
      category: "ID"
      type: "system"
      displayFormat: "date_time"
      dataType:
        type: "time_stamp"
        precision: 0
        scale: 0
      alias: ""
    displays:
      reportDisplays:
      - id: "45C11FA478E745FEA08D781CEA190FE5"
        name: "ID"
      browseDisplays:
      - id: "45C11FA478E745FEA08D781CEA190FE5"
        name: "ID"
    acl:
      "294DEDC011D2F1D56000D98E67019608":
        granted: 255
        denied: 0
        inheritable: false
      "37DECDD94EAA4A2AF3C7A6B17080DADF":
        granted: 255
        denied: 0
        inheritable: false
      C82C6B1011D2894CC0009D9F29718E4F:
        granted: 255
        denied: 0
        inheritable: false
    translations:
      name:
        targetName: "Object Name"
        translationValues:
          1033:
            translation: "Day Date (1) (30 min)"
  - information:
      primaryLocale: "en-US"
      objectId: "0CC36426AFAB4E65A52C044BCB5EB3FE"
      subType: "attribute_smart"
      name: "Day Date (1) (Hour)"
    smartAttributeType: "hour_interval"
    ascending: true
    forms:
    - id: "45C11FA478E745FEA08D781CEA190FE5"
      name: "ID"
      category: "ID"
      type: "system"
      displayFormat: "date_time"
      dataType:
        type: "time_stamp"
        precision: 0
        scale: 0
      alias: ""
    displays:
      reportDisplays:
      - id: "45C11FA478E745FEA08D781CEA190FE5"
        name: "ID"
      browseDisplays:
      - id: "45C11FA478E745FEA08D781CEA190FE5"
        name: "ID"
    acl:
      "294DEDC011D2F1D56000D98E67019608":
        granted: 255
        denied: 0
        inheritable: false
      "37DECDD94EAA4A2AF3C7A6B17080DADF":
        granted: 255
        denied: 0
        inheritable: false
      C82C6B1011D2894CC0009D9F29718E4F:
        granted: 255
        denied: 0
        inheritable: false
    translations:
      name:
        targetName: "Object Name"
        translationValues:
          1033:
            translation: "Day Date (1) (Hour)"
  - information:
      primaryLocale: "en-US"
      objectId: "C857333B66844677B51E40E6D38ECAEF"
      subType: "attribute_smart"
      name: "Day Date (1) (Day)"
    smartAttributeType: "day_interval"
    ascending: true
    forms:
    - id: "45C11FA478E745FEA08D781CEA190FE5"
      name: "ID"
      category: "ID"
      type: "system"
      displayFormat: "number"
      dataType:
        type: "integer"
        precision: 0
        scale: 0
      alias: ""
    - id: "4FE01010705C4177B5ECB2E4F967F01B"
      name: "Start"
      category: "Start"
      type: "system"
      displayFormat: "date_time"
      dataType:
        type: "time_stamp"
        precision: 0
        scale: 0
      alias: ""
    - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
      name: "DESC"
      category: "DESC"
      type: "system"
      displayFormat: "text"
      dataType:
        type: "integer"
        precision: 0
        scale: 0
      alias: ""
    displays:
      reportDisplays:
      - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
        name: "DESC"
      - id: "4FE01010705C4177B5ECB2E4F967F01B"
        name: "Start"
      browseDisplays:
      - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
        name: "DESC"
      - id: "4FE01010705C4177B5ECB2E4F967F01B"
        name: "Start"
    acl:
      "294DEDC011D2F1D56000D98E67019608":
        granted: 255
        denied: 0
        inheritable: false
      "37DECDD94EAA4A2AF3C7A6B17080DADF":
        granted: 255
        denied: 0
        inheritable: false
      C82C6B1011D2894CC0009D9F29718E4F:
        granted: 255
        denied: 0
        inheritable: false
    translations:
      name:
        targetName: "Object Name"
        translationValues:
          1033:
            translation: "Day Date (1) (Day)"
  - information:
      primaryLocale: "en-US"
      objectId: "E55467B1A95B4FB1BE3FAADDB7BDB9B2"
      subType: "attribute_smart"
      name: "Day Date (1) (Week)"
    smartAttributeType: "week_interval"
    ascending: true
    forms:
    - id: "45C11FA478E745FEA08D781CEA190FE5"
      name: "ID"
      category: "ID"
      type: "system"
      displayFormat: "number"
      dataType:
        type: "integer"
        precision: 0
        scale: 0
      alias: ""
    - id: "4FE01010705C4177B5ECB2E4F967F01B"
      name: "Start"
      category: "Start"
      type: "system"
      displayFormat: "date_time"
      dataType:
        type: "time_stamp"
        precision: 0
        scale: 0
      alias: ""
    - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
      name: "DESC"
      category: "DESC"
      type: "system"
      displayFormat: "text"
      dataType:
        type: "integer"
        precision: 0
        scale: 0
      alias: ""
    displays:
      reportDisplays:
      - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
        name: "DESC"
      - id: "4FE01010705C4177B5ECB2E4F967F01B"
        name: "Start"
      browseDisplays:
      - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
        name: "DESC"
      - id: "4FE01010705C4177B5ECB2E4F967F01B"
        name: "Start"
    acl:
      "294DEDC011D2F1D56000D98E67019608":
        granted: 255
        denied: 0
        inheritable: false
      "37DECDD94EAA4A2AF3C7A6B17080DADF":
        granted: 255
        denied: 0
        inheritable: false
      C82C6B1011D2894CC0009D9F29718E4F:
        granted: 255
        denied: 0
        inheritable: false
    translations:
      name:
        targetName: "Object Name"
        translationValues:
          1033:
            translation: "Day Date (1) (Week)"
  - information:
      primaryLocale: "en-US"
      objectId: "1E5E746F5D44453D91255E4E92A689EE"
      subType: "attribute_smart"
      name: "Day Date (1) (Month)"
    smartAttributeType: "month_interval"
    ascending: true
    forms:
    - id: "45C11FA478E745FEA08D781CEA190FE5"
      name: "ID"
      category: "ID"
      type: "system"
      displayFormat: "number"
      dataType:
        type: "integer"
        precision: 0
        scale: 0
      alias: ""
    - id: "4FE01010705C4177B5ECB2E4F967F01B"
      name: "Start"
      category: "Start"
      type: "system"
      displayFormat: "date_time"
      dataType:
        type: "time_stamp"
        precision: 0
        scale: 0
      alias: ""
    - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
      name: "DESC"
      category: "DESC"
      type: "system"
      displayFormat: "text"
      dataType:
        type: "integer"
        precision: 0
        scale: 0
      alias: ""
    displays:
      reportDisplays:
      - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
        name: "DESC"
      - id: "4FE01010705C4177B5ECB2E4F967F01B"
        name: "Start"
      browseDisplays:
      - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
        name: "DESC"
      - id: "4FE01010705C4177B5ECB2E4F967F01B"
        name: "Start"
    acl:
      "294DEDC011D2F1D56000D98E67019608":
        granted: 255
        denied: 0
        inheritable: false
      "37DECDD94EAA4A2AF3C7A6B17080DADF":
        granted: 255
        denied: 0
        inheritable: false
      C82C6B1011D2894CC0009D9F29718E4F:
        granted: 255
        denied: 0
        inheritable: false
    translations:
      name:
        targetName: "Object Name"
        translationValues:
          1033:
            translation: "Day Date (1) (Month)"
  - information:
      primaryLocale: "en-US"
      objectId: "3B4F93EC34F5484283EAE41BCCF4B372"
      subType: "attribute_smart"
      name: "Day Date (1) (Quarter)"
    smartAttributeType: "quarter_interval"
    ascending: true
    forms:
    - id: "45C11FA478E745FEA08D781CEA190FE5"
      name: "ID"
      category: "ID"
      type: "system"
      displayFormat: "number"
      dataType:
        type: "integer"
        precision: 0
        scale: 0
      alias: ""
    - id: "4FE01010705C4177B5ECB2E4F967F01B"
      name: "Start"
      category: "Start"
      type: "system"
      displayFormat: "date_time"
      dataType:
        type: "time_stamp"
        precision: 0
        scale: 0
      alias: ""
    - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
      name: "DESC"
      category: "DESC"
      type: "system"
      displayFormat: "text"
      dataType:
        type: "integer"
        precision: 0
        scale: 0
      alias: ""
    displays:
      reportDisplays:
      - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
        name: "DESC"
      - id: "4FE01010705C4177B5ECB2E4F967F01B"
        name: "Start"
      browseDisplays:
      - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
        name: "DESC"
      - id: "4FE01010705C4177B5ECB2E4F967F01B"
        name: "Start"
    acl:
      "294DEDC011D2F1D56000D98E67019608":
        granted: 255
        denied: 0
        inheritable: false
      "37DECDD94EAA4A2AF3C7A6B17080DADF":
        granted: 255
        denied: 0
        inheritable: false
      C82C6B1011D2894CC0009D9F29718E4F:
        granted: 255
        denied: 0
        inheritable: false
    translations:
      name:
        targetName: "Object Name"
        translationValues:
          1033:
            translation: "Day Date (1) (Quarter)"
  - information:
      primaryLocale: "en-US"
      objectId: "844F4E17275D46AA9F9E36EE73605F63"
      subType: "attribute_smart"
      name: "Day Date (1) (Year)"
    smartAttributeType: "year_interval"
    ascending: true
    forms:
    - id: "45C11FA478E745FEA08D781CEA190FE5"
      name: "ID"
      category: "ID"
      type: "system"
      displayFormat: "number"
      dataType:
        type: "integer"
        precision: 0
        scale: 0
      alias: ""
    - id: "4FE01010705C4177B5ECB2E4F967F01B"
      name: "Start"
      category: "Start"
      type: "system"
      displayFormat: "date_time"
      dataType:
        type: "time_stamp"
        precision: 0
        scale: 0
      alias: ""
    - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
      name: "DESC"
      category: "DESC"
      type: "system"
      displayFormat: "text"
      dataType:
        type: "integer"
        precision: 0
        scale: 0
      alias: ""
    displays:
      reportDisplays:
      - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
        name: "DESC"
      - id: "4FE01010705C4177B5ECB2E4F967F01B"
        name: "Start"
      browseDisplays:
      - id: "CCFBE2A5EADB4F50941FB879CCF1721C"
        name: "DESC"
      - id: "4FE01010705C4177B5ECB2E4F967F01B"
        name: "Start"
    acl:
      "294DEDC011D2F1D56000D98E67019608":
        granted: 255
        denied: 0
        inheritable: false
      "37DECDD94EAA4A2AF3C7A6B17080DADF":
        granted: 255
        denied: 0
        inheritable: false
      C82C6B1011D2894CC0009D9F29718E4F:
        granted: 255
        denied: 0
        inheritable: false
    translations:
      name:
        targetName: "Object Name"
        translationValues:
          1033:
            translation: "Day Date (1) (Year)"
  attributeLookupTable:
    objectId: "A2C871BF7FB24D609E9213296EE1B8C7"
    subType: "logical_table"
    name: "lu_day"
  keyForm:
    id: "45C11FA478E745FEA08D781CEA190FE5"
    name: "Day Date"
  displays:
    reportDisplays:
    - id: "45C11FA478E745FEA08D781CEA190FE5"
      name: "Day Date"
    browseDisplays:
    - id: "45C11FA478E745FEA08D781CEA190FE5"
      name: "Day Date"
  nonAggregatable: false
  acl:
    "294DEDC011D2F1D56000D98E67019608":
      granted: 255
      denied: 0
      inheritable: false
    "37DECDD94EAA4A2AF3C7A6B17080DADF":
      granted: 255
      denied: 0
      inheritable: false
    C82C6B1011D2894CC0009D9F29718E4F:
      granted: 255
      denied: 0
      inheritable: false
  translations:
    name:
      targetName: "Object Name"
      translationValues:
        1033:
          translation: "Day Date (2)"
    description:
      targetName: "Object Description"
      translationValues:
        1033:
          translation: "Date of the day in format YYYY-MM-DD HH:MM:SS.S"
    forms:
      "45C11FA478E745FEA08D781CEA190FE5":
        name:
          targetName: "Attribute Form Name"
          translationValues:
            1033:
              translation: "Day Date"
        description:
          targetName: "Attribute Form Description"
          translationValues:
            1033:
              translation: "Date of the day in format YYYY-MM-DD HH:MM:SS.S"
  autoDetectLookupTable: true