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";