User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
Kooka Blue Kooka Matune Kooka Kooka Blue Kooka Matune Blue Matune Matune Blue Matune Kooka Blue SAUqwRrS Kooka Blue Kooka Matune Kooka Kooka Blue Kooka Matune Blue Matune Matune Blue Matune Kooka Blue SAUqwRrS Kooka Blue Kooka Matune Kooka Kooka Blue Kooka Matune Blue Matune Matune Blue Matune Kooka Blue SAUqwRrS Kooka Blue Kooka Matune Kooka Kooka Blue Kooka Matune Blue Matune Matune Blue Matune Kooka Blue SAUqwRrS Kooka Blue Kooka Matune Kooka Kooka Blue Kooka Matune Blue Matune Matune Blue Matune Kooka Blue SAUqwRrS
New LookML
Old LookML
New LookML
alias

Kooka Blue Kooka Matune Kooka Kooka Blue Kooka Matune Blue Matune Matune Blue Matune Kooka Blue SAUqwRrS

view: view_name {
  dimension: field_name {
     alias : Matune Kooka Matune Blue Kooka Kooka Matune Blue Kooka Kooka Kooka Matune Matune Blue Blue Blue [ 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
Yurban Imartingo Imartingo White Imartingo Yurban Imartingo White Yurban Imartingo White White Yurban Yurban White Wgzw0nwqA
Kooka Kooka Kooka Blue Matune Matune Kooka Matune Kooka Blue Matune Matune Blue Blue Blue Kooka 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 Kooka Matune Kooka Kooka Matune Blue Blue Matune Kooka Blue Blue Kooka Blue Matune Kooka Matune number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , Matune Kooka Kooka Blue Blue Kooka Matune Blue Matune Matune Kooka Blue Matune Kooka Kooka Blue 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 Matune Kooka Blue Matune Matune Blue Matune Kooka Blue Blue Kooka Blue Matune Kooka Kooka Kooka , 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 Blue Matune Kooka Matune Kooka Kooka Kooka Matune Kooka Blue Blue Blue Kooka Matune Blue Matune : number # should not use alias names in LookML
}

Top
Description
Designed by Kooka?, you won't be able to resist this short dress. Designed in blue and made of cotton (61%) and polyester (39%) , it has it all. Fashionable and feminine, you'll love wearing your new dress this summer.
Information
Closure :

   Zip fastening

Composition :

   Cotton : 61%

   Polyester : 39%

Care advice :