• I fix this problem with a update storeprocedure;

    -- Set to date flags

    MERGE DIM.DATE AS target

    USING

    (

    SELECT

    DATE.DAY_WID

    -- Week

    ,CASE WHEN DATE.WEEK_CURR_F = 1 AND

    DATE.WEEKDAY_NUMBER <= CWN.WEEKDAY_NUMBER THEN 1 ELSE 0 END AS

    WTD_CURR_F

    ,CASE WHEN DATE.WEEK_PREV_F = 1 AND

    DATE.WEEKDAY_NUMBER <= CWN.WEEKDAY_NUMBER THEN 1 ELSE 0 END AS

    WTD_PREV_F

    ,CASE WHEN DATE.WEEK_PREV_YEAR_CURR_F = 1 AND

    DATE.WEEKDAY_NUMBER <= CWN.WEEKDAY_NUMBER THEN 1 ELSE 0 END AS

    WTD_PREV_YEAR_CURR_F

    ,CASE WHEN DATE.WEEK_PREV_YEAR_PREV_F = 1 AND

    DATE.WEEKDAY_NUMBER <= CWN.WEEKDAY_NUMBER THEN 1 ELSE 0 END AS

    WTD_PREV_YEAR_PREV_F

    ,CASE WHEN DATE.WEEKDAY_NUMBER <=

    CWN.WEEKDAY_NUMBER THEN DATE.WEEK_OFFSET ELSE NULL END AS

    WTD_OFFSET