/* Level of Detail example
store_sales.regional_sales 
  AS sum(total_sales)
    OVER (PARTITION BY 
      EXCLUDING 
        transactions.store_name) 
*/


CREATE OR REPLACE SEMANTIC VIEW 
  level_of_detail_example
  DIMENSIONS (
    store.store_name
    , store.region
    , transactions.tran_date
  )
  METRICS (
    transactions.total_sales
      AS sum(selling_price)
    , transactions.regional_sales 
      AS sum(total_sales)
        OVER (PARTITION BY 
                EXCLUDING 
                  store.store_name) 
  );