data.ml
LKML Consulting it

Job Code

Job Code model for consulting it.

inferred

Blocks

job_code.view.lkml · 40 lines
inferred 
view: job_code {
  sql_table_name: t_job_code ;;

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

  dimension: loaded_cost {
    type: number
    sql: ${TABLE}.loaded_cost ;;
  }

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

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

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

  dimension: userid_fte {
    type: number
    sql: ${TABLE}.userid_fte ;;
  }

  measure: count {
    type: count
    drill_fields: [job_code_id, name, emp.count]
  }
}
job_code.view.lookml · 29 lines
source-preserved 
- view: job_code
  sql_table_name: t_job_code
  fields:
  - dimension: job_code_id
    type: int
    primary_key: true
    hidden: true
    sql: ${TABLE}.job_code_id
  - dimension: loaded_cost
    type: number
    sql: ${TABLE}.loaded_cost
  - dimension: name
    sql: ${TABLE}.name
  - dimension: sor_sys_cd
    hidden: true
    sql: ${TABLE}.sor_sys_cd
  - dimension: sor_sys_id
    type: int
    hidden: true
    sql: ${TABLE}.sor_sys_id
  - dimension: userid_fte
    type: number
    sql: ${TABLE}.userid_fte
  - measure: count
    type: count
    drill_fields:
    - job_code_id
    - name
    - emp.count

Contents

  • job_code.view.lkml
  • job_code.view.lookml