Is it possible that you are skewing on the week and blowing spool on a few amps? I don't like using week_code just for that reason. Maybe keep it at the day grain calculate the week within the BI tool? No sure.... just taking some wild stabs.
Thanks for the reply howwever week key holds the same 7 days which we use in date report so what's the difference ... how is it causing the issue