dimension
Usage
view: view_name {
dimension: field_name { … }
}
dimension: field_name { … }
}
Hierarchy
dimension |
Accepts
A 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
a
throughz
(no capital letters),0
through9
, 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 ;;
}
}