I have a WebI report which has combination of blocks with Oracle and SAP BW queries as a datasource. I am coming across a strange issue which is that some of my BW based queries don't refresh which refreshed. All other ones do and all oracle based queries also refresh properly. It's a big report containg more than 30 Queries.
When a new Webi is created on top of same query, it shows refreshed data whereas data block doesn't refresh as part of actual report. Strangely when universe is refreshed and exported, everything suddenly runs fine for sometime. After sometime the problem starts again.
Anyone came across this before?
Environment: BOE XI 3.1 RTM.