data.ml
LKML Consulting it

Project Task Category

Project Task Category model for consulting it.

inferred

Blocks

project_task_category.view.lkml · 40 lines
inferred 
view: project_task_category {
  sql_table_name: t_proj_task_cat ;;

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [proj_task_cat_id, proj_task.count]
  }
}
project_task_category.view.lookml · 28 lines
source-preserved 
- view: project_task_category
  sql_table_name: t_proj_task_cat
  fields:
  - dimension: project_task_category_id
    type: int
    primary_key: true
    hidden: true
    sql: ${TABLE}.proj_task_cat_id
  - dimension: active_flag
    type: yesno
    sql: ${TABLE}.active_flg
  - dimension: notes
    hidden: true
    sql: ${TABLE}.notes
  - dimension: name
    sql: ${TABLE}.proj_task_cat_nm
  - dimension: sor_system_cd
    hidden: true
    sql: ${TABLE}.sor_sys_cd
  - dimension: sor_system_id
    type: int
    hidden: true
    sql: ${TABLE}.sor_sys_id
  - measure: count
    type: count
    drill_fields:
    - proj_task_cat_id
    - proj_task.count

Contents

  • project_task_category.view.lkml
  • project_task_category.view.lookml