MicroStrategy ONE

Invalidate Report Cache statement

Invalidates a report server cache in a MicroStrategy Intelligence Server.

Copy 
INVALIDATE ([ALL] REPORT CACHES 
 [WHTABLE "wh_table_name"] 
 ([SECURITY FILTER "sec_filter_id1" 
 | SECURITY FILTERS "sec_filter_id1" 
 [, .."sec_filter_idN"])] 
 [(USER "login_id") 
 | (NAME "user_name")] 
 [(USER GROUP "user_group_id") 
 | (NAME "user_group_name")] 
 [(DBLOGIN "dblogin_id") 
 | (DBLOGINNAME "dblogin_name")] 
 [DBCONNECTION "dbconnection_id"] 
 [LOCALE "locale_name"] 
 | REPORT CACHE "cache_name" 
 [GUID cache_guid] [CHECKCACHEEXISTENCE]) 
 IN PROJECT "project_name";

where:

  • WHTABLE "wh_table_name" is the name of the warehouse table associated with the report caches to be invalidated, of type string.

  • SECURITY FILTER "sec_filter_id1..N" is the list of all the security filters that are associated with the report caches to be invalidated, of type string.

  • USER "login_id" is the user login id that is associated with the report caches to be deleted, of type string.

  • NAME "user_name" is the name of a user that is associated with the report caches to be deleted, of type string.

  • USER GROUP "user_group_id" is the user group id that is associated with the report caches to be deleted, of type string.

  • NAME "user_group_name" is the name of a user group that is associated with the report caches to be deleted, of type string.

  • DBLOGIN "dblogin_id" is the DB Login id that is associated with the report caches to be deleted, of type string.

  • DBLOGINNAME "dblogin_name" is the name of a DB Login that is associated with the report caches to be deleted, of type string.

  • DBCONNECTION "dbconnection_id" is the DB Connection id that is associated with the report caches to be invalidated, of type string.

  • LOCALE "locale_name" is the locale name that is associated with the report caches to be invalidated, of type string.

  • REPORT CACHE "cache_name" is the name of the report cache to be invalidated, of type string.

  • GUID cache_guid is the GUID of the report cache to be invalidated, of type GUID.

  • CHECKCACHEEXISTENCE indicates to check for a given cache's existence before purging it.

  • PROJECT "project_name" is the project in which the report caches are to be invalidated, of type string.

This statement can only be used with three-tier or four-tier project source names.

Example

Copy 
INVALIDATE ALL REPORT CACHES WHTABLE "PMT_INVENTORY" 
 IN PROJECT "MicroStrategy Tutorial";