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