User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
Skinnie Bench Bench Blue Blue Skinnie Blue Skinnie Skinnie Skinnie Bench Blue Blue Bench Skinnie Bench Blue Bench C6wqFXw Skinnie Bench Bench Blue Blue Skinnie Blue Skinnie Skinnie Skinnie Bench Blue Blue Bench Skinnie Bench Blue Bench C6wqFXw Skinnie Bench Bench Blue Blue Skinnie Blue Skinnie Skinnie Skinnie Bench Blue Blue Bench Skinnie Bench Blue Bench C6wqFXw Skinnie Bench Bench Blue Blue Skinnie Blue Skinnie Skinnie Skinnie Bench Blue Blue Bench Skinnie Bench Blue Bench C6wqFXw Skinnie Bench Bench Blue Blue Skinnie Blue Skinnie Skinnie Skinnie Bench Blue Blue Bench Skinnie Bench Blue Bench C6wqFXw Skinnie Bench Bench Blue Blue Skinnie Blue Skinnie Skinnie Skinnie Bench Blue Blue Bench Skinnie Bench Blue Bench C6wqFXw Skinnie Bench Bench Blue Blue Skinnie Blue Skinnie Skinnie Skinnie Bench Blue Blue Bench Skinnie Bench Blue Bench C6wqFXw Skinnie Bench Bench Blue Blue Skinnie Blue Skinnie Skinnie Skinnie Bench Blue Blue Bench Skinnie Bench Blue Bench C6wqFXw
New LookML
Old LookML
New LookML
alias

Skinnie Bench Bench Blue Blue Skinnie Blue Skinnie Skinnie Skinnie Bench Blue Blue Bench Skinnie Bench Blue Bench C6wqFXw

view: view_name {
  dimension: field_name {
     alias : Skinnie Bench Skinnie Bench Bench Blue Skinnie Bench Blue Bench Blue Skinnie Skinnie Bench Blue Blue Blue Skinnie [ old_field_name , old_field_name , ]
  }
}

Hierarchy

   view
   Field Type
   alias

Possible Field Types

Dimension, Dimension Group, Measure, Filter, Parameter

Accepts

A square-bracketed list of field names

The alias parameter provides alternative names for a field that might appear in the URL for a query. It can be useful in cases when field names in a model change, but you have pre-existing URLs to queries that you want to keep functioning.

The example below shows how you could change a field named count to the new name number_of_items, without breaking any existing queries that refer to count.

measure : number_of_items { # the new name
2018 Adidas United 2017 lukaku 9 Home Shirt Man Originals Red OqSvqg
Skinnie Skinnie Blue Skinnie Skinnie Bench Blue Blue Blue Skinnie Bench Bench Bench Blue Blue Bench Bench Skinnie alias : [ count ] # the old name
type : count
}

You can also provide multiple aliases, in case you rename a field multiple times. For example, if you renamed the above Bench Skinnie Skinnie Skinnie Bench Skinnie Bench Blue Bench Blue Blue Skinnie Blue Skinnie Bench Blue Bench Blue number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , Skinnie Bench Blue Skinnie Blue Blue Bench Blue Bench Blue Bench Bench Skinnie Skinnie Bench Blue Skinnie Skinnie number_of_items ] # the old names
type : count
}

To use alias with a dimension group, change the dimension group name, not every field in the dimension group. For example, to rename the dimension group created_date to order_date:

dimension_group : order_date { # the new name
alias : [ created_date ] # the old name
type : time
timeframes : [ time , hour Bench Skinnie Bench Skinnie Bench Blue Skinnie Bench Blue Skinnie Bench Blue Skinnie Blue Blue Bench Skinnie Blue , date , week , month , year , hour_of_day , day_of_week , month_num , raw ]
sql : ${TABLE}.created_at ;;
}

Please note that alias is used only to keep URLs functioning. It should not be used when referencing fields in LookML. For example:

measure : number_of_items {
alias : [ count ]
type : count
}
measure : percent_items_sold {
sql : ${sold_items} / ${number_of_items} ;; # will work because there
type : number # is a measure named number_of_items
}
measure : percent_items_sold {
sql : ${sold_items} / ${count} ;; # will NOT work because you
type Bench Bench Blue Skinnie Blue Skinnie Blue Blue Skinnie Skinnie Blue Bench Skinnie Bench Bench Bench Skinnie Blue : number # should not use alias names in LookML
}

Top
Description
All our fashion desires will be fulfilled with this blue tank top. Bench has made this tank top of cotton (50%) and viscose (50%) . This tank top can be worn all season long.
Information
Composition :

   Viscose : 50%

   Cotton : 50%

Care advice :