MicroStrategy ONE

Alter Cache Update Subscription statement

Modify the properties of a cache update subscription.

Copy 
ALTER CACHEUPDATESUBSCRIPTION (subscription_name[MANAGE 
 ALL] | GUIDsubscription_GUID) [NAMEnew_subscription_name] [OWNERnew_login_name] [SCHEDULEnew_schedule_name] [(USERnew_user_name | GROUP new_user_group_name)] [CONTENT (new_report_or_document_nameIN FOLDERnew_location_name | GUID new_report_or_document_guid) [CONTENTTYPE (REPORT | DOCUMENT)]] IN PROJECTproject_name DELIVERYFORMAT (PLAINTEXT | EXCEL | CSV | HTML 
 | PDF | FLASH) [SENDNOTIFICATION (TRUE|FALSE)] [(SENDNOTIFICATION_ADDRESS 
 "notification_address" | PHYSICALADDRESS "physical_address" 
 DEVICE "notification_device")] [RUNFRESH (TRUE|FALSE)] [CREATEUPDATECACHE (TRUE|FALSE)];

where:

  • subscription_name is the name of the subscription

  • subscription_GUID is the ID of the subscription

  • new_subscription_name  is the new name of the subscription

  • new_login_name is the login name of the new owner of the subscription

  • new_schedule_name is the name of the new schedule used by the subscription

  • new_user_name  is the name of a user now subscribed to the subscription

  • new_user_group_name is the name of a group now subscribed to the subscription

  • new_report_or_document_name is the name of a report or document now delivered with the subscription

  • new_location_name is the name of the folder containing the report or document

  • new_report_or_document_guid is the GUID of the report or document

  • project_name is the name of the project containing the report or document

  • notification_address is the address to which notifications are sent

  • physical_address is the physical address to which notifications are sent

  • notification_device is the device to which notifications are sent