MicroStrategy ONE
Create File Subscription statement
Creates a subscription to a file.
Do not include any leading or trailing spaces in the ANSWER parameters. This causes a SQL error and prevents the command from executing.
CREATE FILESUBSCRIPTION [subscription_name]
[FOR OWNERlogin_name] SCHEDULEschedule_name (ADDRESSaddress_name| USERuser_name | CONTACTcontact_name [ADDRESS contact_address_name] | CONTACTGROUPcontact_group_name) CONTENT (report_or_document_nameIN FOLDERlocation_name | GUID report_or_document_guid) [CONTENTTYPE (REPORT | DOCUMENT)] IN PROJECTproject_name DELIVERYFORMAT (PLAINTEXT [TEXTDELIMITER (COMMA
| SPACE | TAB | SEMICOLON | COLON | OTHER custom_delimiter)] | EXCEL | PDF | CSV | HTML | FLASH) [COMPRESSCONTENTS
[PROTECTZIPFILE ZIPFILENAMEzip_file_name ZIPFILEPASSWORDzip_file_passwordEXPIRATIONDATEmm/dd/yyyy]]] FILENAMEfile_name [SENDPREVIEWNOW(TRUE|FALSE)]
[[(SENDNOTIFICATION_ADDRESS "notification_address" | PHYSICALADDRESS "physical_address"
DEVICE "notification_device")] [MODIFICATIONBYRECIPIENTS (TRUE|FALSE)] [PROMPT
prompt_name1 ANSWER prompt_answer1 [, PROMPT prompt_name2 ANSWER prompt_answer2 [, .. PROMPT prompt_namen ANSWER prompt_answern]]];
where:
-
subscription_name is the name of the subscription
-
login_name is the login name of the subscription owner
-
schedule_name is the name of the schedule
-
address_name is the name of the address
-
user_name is the name of the user
-
contact_name is the name of the contact
-
contact address_name is the name of the contact address
-
contact_group_name is the name of the contact group
-
report_or_document_name is the name of the report or document
-
location_name is the name of thefolder where the report or document resides
-
report_or_document_guid is the GUID of the report or document
-
project_name is the name of theproject where the report or document resides
-
custom_delimiter is the single character used as a custom text delimiter
-
zip_file_name is the name of the zip file (for compression purposes)
-
zip_file_password is the password of the zip file
-
mm/dd/yyyy is expiration date for the zip file
-
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
-
file_name is the name of the file
-
prompt_name1..n are the names of prompts in the report or document
-
prompt_answer1..n are the answers to the corresponding prompts