Swapan wrote:Ok, thanks for the clarification. Event polling does work for us with AW objects, but only because we are using query rewrite. So we are inserting the base table names into the event table. You are probably hitting the cube directly, so you need actual AW objects for the event polling mechanism.
I am not talking of OBIEE Server cache. Actually, I have an SR (Bug#14104352) already open with Oracle on Event polling mechanism not working with AW's currently. Is Event Polling mechansim working for you with AW's?
This is related to the behavior of OLAP_TABLE being session based in general.