Purging Cache in the Answers using Direct Database Request:

In order to purge cache using direct request create a new database in repository as follows;

1 )      Set Database to “ODBC Basic”

2 )      Check “Allow Direct Database Request by Default”

Next Step is to add connection pool in the database as follows;

1)      Set Call Interface to “ODBC 2.0”

2)      Set Data Source Name to “Analytics Web”

3)      Add username and password

In the next step create a direct database request and add following;

To Purge the whole cache;

1)      Add Call SAPurgeAllCache(); in the SQL Statement

2)      Provide connection poll information

To Purge cache by Query;

1)      Add Call SAPurgeAllCache(‘SQL QUERY’); in the SQL Statement

e.g. Call SAPurgeCacheByQuery('SELECT Ledgers."Charge #" saw_0 FROM Payments ORDER BY saw_0');

The query can be obtained from the Manage Session window in the administration;

2)      Provide connection poll information

To Purge cache by Table;

1)      Add Call SAPurgeCacheByTable (‘TABLE NAME’); in the SQL Statement

e.g. Call SAPurgeCacheByTable( ‘CHARGES’);

2)      Provide connection poll information

To Purge cache by Database;

1)      Add Call SAPurgeCacheByDatabase (‘DATABASE NAME’); in the SQL Statement

e.g. Call SAPurgeCacheByDatabase( 'SEQUELMED' );

2)      Provide connection poll information

Purge Cache report can also be added as a link on the dashboard to purge cache at any time;

Furthermore purge cache report can also be added in the conditional request of an iBot to schedule purging.

Cheers and Long Live Pakistan ;)