User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
Originals Orange Adidas Olympiakos 2018 2017 Football Away Shirt aq81dq0w Originals Orange Adidas Olympiakos 2018 2017 Football Away Shirt aq81dq0w
New LookML
Old LookML
New LookML
alias

Originals Orange Adidas Olympiakos 2018 2017 Football Away Shirt aq81dq0w

view: view_name {
  dimension: field_name {
     alias : 2018 Originals Adidas Orange Away 2017 Football Olympiakos Shirt [ 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
Deeluxe Black Voltage Deeluxe Voltage Black Deeluxe fFnOnqz
Football Shirt Olympiakos 2017 Adidas Away Orange Originals 2018 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 2017 Football Orange Olympiakos Away Shirt Adidas Originals 2018 number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , Olympiakos Adidas Away Football Originals 2018 Orange 2017 Shirt 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 Olympiakos Away Adidas 2017 2018 Football Orange Originals Shirt , 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 Orange Football Adidas Olympiakos Away 2017 2018 Originals Shirt : number # should not use alias names in LookML
}

Top
Description
Brand new official Olympiakos Away Shirt for the 2017 2018 Greek League season. This authentic football kit is available in adult sizes S M L XL XXL XXXL and is manufactured by Adidas.This football shirt of the Greek Superleague side Olympiacos comes in a very different colour to that of the home shirt. A mainly solar orange design ensures you'll stand out in a crowd with dark blue trim and both the adidas and Olympiacos crest embroiderewed on the chest. Made from eco-friendly 100% recycled polyester incorporated within the shirt is also adidas ClimaCool technology which is designed to help keep the wearer feeling cooler drier and more refreshed during intense action both on and off the field. To enhance this cooling effect the underarms are also ventilated.Great for fans to wear for casual kickabouts training sessions and most appropriately in support of the team at matches show you're a true Erythrolefkoi fan with this adidas Olympiacos 17/18 Away S/S Replica Football Shirt.