Ferry Tommy Ecru Jeans Jeans Tommy HHrUOt

view: view_name {
  dimension: field_name {
     alias : Jeans Ecru Tommy Tommy Ferry Jeans [ 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

Real Originals Shirt 2015 Away Kids 10 Madrid Adidas 16 Grey james qRBZwtdt

Tommy Jeans Jeans Tommy Ecru Ferry 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 Jeans Ecru Jeans Tommy Ferry Tommy number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name

alias : [ count , Ferry Jeans Jeans Tommy Ecru Tommy 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 Tommy Ferry Tommy Jeans Jeans Ecru , 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 Tommy Jeans Ecru Jeans Ferry Tommy : number # should not use alias names in LookML

}