For this recipe, we will generate sales data in the script, as defined in the following. Load the following script into the Data load editor:

Calendar:
Load 
    DateID, 
    RowNo()                                   AS ID, 
    Year(DateID)                              As Year, 
    Year(DateID)&''&NUM(Month(DateID),'00')   AS YearMonth, 
    Month(DateID)                             As Month, 
    Date(DateID)                              As Date, 
    Day(DateID)                               As Day, 
    Week(DateID)                              As Week, 
    Floor(2000 * rand())                      AS Sales; 
Load 
RecNo()-1+makedate(2014) As DateID 
AutoGenerate(730);