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 the Dimension, filter, and parameter types documentation page.
Examples
Create an id and a 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 ;;
}
}