Hi All,
I have a SQL Job which runs daily at 8pm, it loads the DWH then processes the cube via an SSIS package.
We have found that when the job exceeds 4 hours (runs into the next day) some of the Cube calculations that use date and lag, current member, etc are incorrect because the date has changed.
Does anyone know how to get around this problem?
Thanks,
Rich