Event polling in OBIEE 11G


EVENT Polling Table in OBIEE 


An event polling table is a way to notify Oracle BI server that one or more physical tables have been updated. Each row that is added to an event table describes a single update event. The cache system read rows from – or polls – the event table, extracts the physical table information from the rows, and purges cache entries that reference those physical tables. The SQL for creating an event table can be found in the \\<OBIEE_MW_Home>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\schema folder.

Steps to create event table to purge the cache automatically



2)      Create the event table in the database by running the script in the SAEPT.sql .

3)      Import the created event table into the repository


4)      Go to Tools Ć  Utilities. Select Oracle BI Event tables and click execute.

5)      Select the event polling table. Here I have selected the event polling table S_NQ_EPT. Set the polling interval as the time u need to purge the cache.

6)       Now you can see that icon of the table S_NQ_EPT changes as now we have made it as the event polling table. Checkin the  changes and save the rpd.


Now lets see the working of the event polling table.

7)      Create an entry in the S_NQ_EPT table which will force the oracle BI server to purge the cache.



After the polling interval times verify that the cache entries corresponding to TABLE_NAME mentioned above gets deleted. The cache folder in OBIEE 11 G is \\<OBIEE_MW_Home>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\cache. The entry in the table S_NQ_EPT also get truncated after the polling interval.

All the best. J

No comments:

Post a Comment