I'm running a query on multi provider with 6 cubes and 1 of the cube has non-cumulative key figures.It used work fine before SP10 upgrade. Now it's working sporadically after SP10 upgrade. It broke in our quality environment for a few weeks, then error disappeared. Now it is broke in our production environment.
The weekly report works fine but monthly report still doesn't work.it's throwing the bellow error message
Error in BW : VALID_RETIME_ISECT-4-
Error reading the data of InfoProvider XXX
Error while reading data; Navigation is possible
Please advise if you have encountered this error and how to fix it!!