User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
Originals Shirt 9 Adidas 2016 Madrid 2015 Real Ucl Home benzema White w11O0qd Originals Shirt 9 Adidas 2016 Madrid 2015 Real Ucl Home benzema White w11O0qd Originals Shirt 9 Adidas 2016 Madrid 2015 Real Ucl Home benzema White w11O0qd Originals Shirt 9 Adidas 2016 Madrid 2015 Real Ucl Home benzema White w11O0qd Originals Shirt 9 Adidas 2016 Madrid 2015 Real Ucl Home benzema White w11O0qd
New LookML
Old LookML
New LookML
alias

Originals Shirt 9 Adidas 2016 Madrid 2015 Real Ucl Home benzema White w11O0qd

view: view_name {
  dimension: field_name {
     alias : Shirt Adidas White Originals 2016 9 Home 2015 benzema Madrid Real Ucl [ 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
Oconde Multicoloured Oconde Desigual Desigual Oconde Multicoloured Desigual Desigual Multicoloured Multicoloured Desigual Oconde AwZwvqd
Real White Madrid Home Adidas benzema 2016 Shirt 2015 Ucl 9 Originals 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 Shirt Adidas 9 2016 Home Ucl White 2015 Originals Madrid benzema Real number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , White Adidas Real 2015 Shirt benzema Originals Madrid 2016 9 Ucl Home 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 9 Originals 2016 Real 2015 benzema White Home Shirt Madrid Adidas Ucl , 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 Adidas Home benzema 2015 Ucl 2016 White Real Shirt Originals 9 Madrid : number # should not use alias names in LookML
}

Top
Description
Official Karim Benzema football shirt for Real Madrid. This is the new Real Madrid home shirt for the 2015-16 Champions League season which is manufactured by Adidas and is available in adult sizes S M L XL XXL XXXL and kids sizes small boys medium boys large boys XL boys. This Real Madrid football shirt is White in colour and comes with Karim Benzema shirt printing on the jersey.