Invoking ODBC Extension Functions
The
following ODBC functions affect cache entries associated with the repository
specified by the ODBC connection. You can call these functions using the
nqcmd.exe command-line executable.
The syntax of the call will be as follows:
nqcmd
-d "Analytics Web" –u administrator –p sadmin –s purge.txt.
Where
purge.txt contains the call (for example, call SAPurgeAllCache())
The different Purging options in OBIEE are;
- SAPurgeCacheByQuery Read More
- SAPurgeCacheByTable Read More
- SAPurgeAllCache Read More
- SAPurgeCacheByDatabase Read More
Please add Event pulling table (S_NQ_EPT) option also.
ReplyDelete