MicroStrategy ONE

Delete Report Cache statement

Purges (deletes) specific report caches in an Intelligence Server.

Copy 
DELETE [ALL] [INVALID] REPORT CACHES 
 [USER (<login_id> | NAME "<user_name>")]
 [USER GROUP (<user_group_id> | NAME "<user_group_name>")]
 [DBLOGIN (<dblogin_id> | NAME "<dblogin_name>")]
 [DBCONNECTION (<dbconnection_id> | NAME "<dbconnection_name>")]
 [LANGUAGE "<language_name>"]
 [FROM (PROJECT | PROJECTS) "<project_name1>" [, "<projectname2>" ...]];

or

Copy 
DELETE [ALL] ([INVALID] REPORT CACHES
 (WHTABLE "<WH_Table_name>" | SECURITY (FILTER | FILTERS)
 (<sec_filter_id1> [, <sec_filter_id2> ...] | NAME "<sec_filter_name1>" [FOLDER "<folder_name>"] [, NAME "<sec_filter_name2>" [FOLDER "<folder_name>"]  ...])) | REPORT CACHE ( "<cache_name>" [FOLDER "<location_path>"] | GUID <cache_guid> [, <cache_guid2> ...])

 [CHECKCACHEEXISTENCE]) FROM PROJECT "<project_name>";

where:

  • WHTABLE "wh_table_name" is the name of the warehouse table associated with the report caches to be deleted, 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 DBLogin that is associated with the report caches to be deleted, of type string.

  • DBCONNECTION "dbconnection_id" is the DBConnection that is associated with the report caches to be deleted, of type string.

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

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

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

  • FOLDER "location_path" is the location of the reports whose caches are to be deleted, of type string.

  • GUID cache_guid1..N are the GUIDs of the report caches to be deleted, of type GUID.

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

  • PROJECT "project_name1..N" are the projects from which the invalid report caches are to be deleted, of type string.

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

Example

Copy 
DELETE 
 REPORT CACHE "Customer List" IN PROJECT "MicroStrategy 
 Tutorial";