AS and RS 2005
My cube is built on views both for dimensions and the fact table.
I am using reporting services and the report i have designed works fine except it does not update when i change the data. I can see the change in a select from the view so it is definitly there. It does refresh if i reprocess the cube. This happens in rolap as well as molap.
Any Ideas?
Thanks,
Jules
Moving to Reporting Services forum.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
why have you moved this?
does that mean it is reporting services that is caching the data?
It looks more like a problem with analysis services to me given that the report displays the correct data if a reprocess the cube.
Whats you thinking here.
Please help
Thanks,
Jules
|||Most chances it is Reporting services problem. You can try and browse your AS cube using cube browser built-in in SQL Management studio to see if new numbers are avaliable.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
