data.ml
LookML Software real estate

Users

Users model for software real estate.

source-preserved

Blocks

users.view.lkml · 120 lines
inferred 
view: users {
  sql_table_name: USERS ;;

  dimension: user_id {
    type: int
    primary_key: yes
    hidden: yes
    sql: ${TABLE}.USER_ID ;;
  }

  dimension: active {
    type: int
    hidden: yes
    sql: ${TABLE}.ACTIVE ;;
  }

  dimension: created_by {
    type: int
    hidden: yes
    sql: ${TABLE}.CREATED_BY ;;
  }

  dimension: email_address {
    sql: ${TABLE}.EMAIL_ADDRESS ;;
  }

  dimension: first_name {
    sql: ${TABLE}.FIRST_NAME ;;
  }

  dimension: last_name {
    sql: ${TABLE}.LAST_NAME ;;
  }

  dimension: middle_name {
    hidden: yes
    sql: ${TABLE}.MIDDLE_NAME ;;
  }

  dimension: name_abbrev {
    hidden: yes
    sql: ${TABLE}.NAME_ABBREV ;;
  }

  dimension: password {
    hidden: yes
    sql: ${TABLE}.PASSWORD ;;
  }

  dimension: password_change_required {
    type: int
    hidden: yes
    sql: ${TABLE}.PASSWORD_CHANGE_REQUIRED ;;
  }

  dimension: phone_number {
    sql: ${TABLE}.PHONE_NUMBER ;;
  }

  dimension: quick_login {
    hidden: yes
    sql: ${TABLE}.QUICK_LOGIN ;;
  }

  dimension: user_name {
    sql: ${TABLE}.USER_NAME ;;
  }

  dimension: user_type {
    hidden: yes
    sql: ${TABLE}.USER_TYPE ;;
  }

  dimension_group: created {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.CREATED_DATE ;;
  }

  dimension_group: last_login {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.LAST_LOGIN ;;
  }

  dimension_group: last_modified {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.LAST_MODIFIED ;;
  }

  dimension_group: password_change {
    type: time
    timeframes: [date, week, month]
    sql: ${TABLE}.PASSWORD_CHANGE_DATE ;;
  }

  dimension_group: quick_login_until {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.QUICK_LOGIN_UNTIL ;;
  }

  dimension_group: suspend_after {
    type: time
    timeframes: [date, week, month]
    sql: ${TABLE}.SUSPEND_AFTER ;;
  }

  dimension_group: suspend_until {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.SUSPEND_UNTIL ;;
  }

  measure: count {
    type: count
    drill_fields: [user_id, middle_name, first_name, last_name, user_name]
  }
}
users.view.lookml · 107 lines
source-preserved 
- view: users
  sql_table_name: USERS
  fields:
  - dimension: user_id
    type: int
    primary_key: true
    hidden: true
    sql: ${TABLE}.USER_ID
  - dimension: active
    type: int
    hidden: true
    sql: ${TABLE}.ACTIVE
  - dimension: created_by
    type: int
    hidden: true
    sql: ${TABLE}.CREATED_BY
  - dimension: email_address
    sql: ${TABLE}.EMAIL_ADDRESS
  - dimension: first_name
    sql: ${TABLE}.FIRST_NAME
  - dimension: last_name
    sql: ${TABLE}.LAST_NAME
  - dimension: middle_name
    hidden: true
    sql: ${TABLE}.MIDDLE_NAME
  - dimension: name_abbrev
    hidden: true
    sql: ${TABLE}.NAME_ABBREV
  - dimension: password
    hidden: true
    sql: ${TABLE}.PASSWORD
  - dimension: password_change_required
    type: int
    hidden: true
    sql: ${TABLE}.PASSWORD_CHANGE_REQUIRED
  - dimension: phone_number
    sql: ${TABLE}.PHONE_NUMBER
  - dimension: quick_login
    hidden: true
    sql: ${TABLE}.QUICK_LOGIN
  - dimension: user_name
    sql: ${TABLE}.USER_NAME
  - dimension: user_type
    hidden: true
    sql: ${TABLE}.USER_TYPE
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CREATED_DATE
  - dimension_group: last_login
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LAST_LOGIN
  - dimension_group: last_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LAST_MODIFIED
  - dimension_group: password_change
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.PASSWORD_CHANGE_DATE
  - dimension_group: quick_login_until
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.QUICK_LOGIN_UNTIL
  - dimension_group: suspend_after
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.SUSPEND_AFTER
  - dimension_group: suspend_until
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.SUSPEND_UNTIL
  - measure: count
    type: count
    drill_fields:
    - user_id
    - middle_name
    - first_name
    - last_name
    - user_name

Contents

  • users.view.lkml
  • users.view.lookml