6 Replies Latest reply: Oct 14, 2013 2:43 PM by Alan Farrell RSS

    Calculated dimension

      How do I create a new calculated dimension from the sql load script? 

      I am loading date from sql query and would like to calculate week during load. 
      The below code works, but I cannot see WorkWeek as a dimension after load completes. 

      SELECT Epi_Lot.Start_Date
      FROM BlueDB.dbo.table;
      Let WorkWeek = Week(start_date);