dimension
Usage
view: view_name {
dimension: field_name { … }
}
dimension: field_name { … }
}
Hierarchydimension |
AcceptsA Looker identifier to name the dimension |
Definition
The dimension parameter declares a new dimension and specifies a name for that dimension.
The name must:
- be unique within any given view
- consist of characters
athroughz(no capital letters),0through9, or_ - start with a letter
There are many types of dimensions, as discussed further on this page.
Examples
Create an id and supplier_name dimension in a view named products:
view: products {
dimension: id {
primary_key: yes
sql: ${TABLE}.id ;;
}
dimension: supplier_name {
sql: ${TABLE}.supplier_name ;;
}
}