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
1)
Locate the SAEPT.sql
file in the loction \\<OBIEE_MW_Home>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\schema
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