Purging Options in OBIEE

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())

ü  SAPurgeCacheByQuery()

Purges a cache entry that exactly matches a specified query.The following call programmatically purges the cache entry associated with this query:

Call SAPurgeCacheByQuery(‘select lastname, firstname from employee where salary >
100000’ );

ü  SAPurgeCacheByTable()

Call SAPurgeCacheByTable(‘DBName’, ‘CatName’, ‘SchName’, ‘TabName’);

Additionally,DBName and TabName cannot be null. If either one is null, you will receive an error message.

ü  SAPurgecacheByDatabase()

Purges all cache entries associated with a specific physical database name.

Call SAPurgeCacheByDatabase( ‘DBName’ );

ü  SAPurgeAllCache()

Purges all cache entries. The following is an example of this call:

Call SAPurgeAllCache();