There are 2 options in the note.The main solution in the note is to use ODBC procedures that can be used to purge all cache.
We should go to OAC Analytics Console -> Issue SQL and use any one of the below based on the requirements.
In the SQL window we don't run the command as is. Some more information can be found in Oracle On-Prem. docs, or blogs such as this one.
Two quick examples:
SAPurgeAllCache - Purges all cache on BI Server. For example:
Call SAPurgeAllCache ()
SAPurgeCacheByTable - Purges cache of specific table.
Call SAPurgeCacheByTable( 'DBName', 'CatName', 'SchName', 'TabName' );
DBName and TabName cannot be null. from my experience, SchName should not be null as well.
For the following definition in the RPD:
We can use:
call SAPurgeCacheByTable('ADW',,'SEM_A', 'DIM_COUNTRY');
Where we have the following response values of Result_Code:
1 - SAPurgeCache returns successfully.
59115 - Operation not performed because caching is not enabled.
59116 - The database specified does not exist.
59117 - The table specified does not exist.