Born Piper Born men's Piper Born men's men's Born Piper Piper men's Piper Born wxX6q

view: view_name {
  dimension: field_name {
     alias : Born Born men's Piper Born men's Piper men's men's Piper Born Piper Piper Born [ old_field_name , old_field_name , … ]
  }
}

Hierarchy

View File

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

Diesel Diesel Black David David IqHZ4Fww

Born men's Piper men's Piper Born men's Born Piper Piper Born Piper Born men's 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 Piper Piper Born men's Piper Piper men's Born Born Born men's men's Born Piper number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name

alias : [ count , Born Piper Born men's men's Piper Piper Piper Born Born Born Piper men's men's 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 Born Piper men's men's Piper Piper men's Born Born Piper Born Piper Born men's , 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 Born men's Piper Born Piper Piper Born Piper Born Piper men's Born men's men's : number # should not use alias names in LookML

}

Heel Height	1 1/4
Material	Leather
Brand Name	Born
Color	Light Brown/Rust