ALTER SEMANTIC VIEW revenue_analysis 
  ADD MATERIALIZATION customer_year_rollup
  WAREHOUSE = my_wh
  AS
    DIMENSIONS 
     customers.customer_name
     , orders.order_year
    METRICS orders.total_revenue;