LKML Consulting it

Department

Department model for consulting it.

inferred

LKML LookML

department.view.lkml · 50 lines

inferred

view: department {
  sql_table_name: t_dept ;;

  dimension: deptarment_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.dept_id ;;
  }

  dimension: active_flag {
    type: yesno
    sql: ${TABLE}.active_flg ;;
  }

  dimension: description {
    sql: ${TABLE}.dept_desc ;;
  }

  dimension: head_employee_id {
    type: int
    hidden: yes
    sql: ${TABLE}.dept_head_emp_id ;;
  }

  dimension: name {
    sql: ${TABLE}.dept_nm ;;
  }

  dimension: sor_system_cd {
    hidden: yes
    sql: ${TABLE}.sor_sys_cd ;;
  }

  dimension: sor_systen_id {
    type: int
    hidden: yes
    sql: ${TABLE}.sor_sys_id ;;
  }

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

  measure: count {
    type: count
    drill_fields: [dept_id, emp.count]
  }
}

department.view.lookml · 38 lines

source-preserved

- view: department
  sql_table_name: t_dept
  fields:
  - dimension: deptarment_id
    type: int
    primary_key: true
    sql: ${TABLE}.dept_id
  - dimension: active_flag
    type: yesno
    sql: ${TABLE}.active_flg
  - dimension: description
    sql: ${TABLE}.dept_desc
  - dimension: head_employee_id
    type: int
    hidden: true
    sql: ${TABLE}.dept_head_emp_id
  - dimension: name
    sql: ${TABLE}.dept_nm
  - dimension: sor_system_cd
    hidden: true
    sql: ${TABLE}.sor_sys_cd
  - dimension: sor_systen_id
    type: int
    hidden: true
    sql: ${TABLE}.sor_sys_id
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.crt_dtm
  - measure: count
    type: count
    drill_fields:
    - dept_id
    - emp.count

department.view.lkml
department.view.lookml

Department

Blocks

Contents