MicroStrategy ONE

Create Mobile Subscription statement

Create a MicroStrategy Mobile subscription.

Do not include any leading or trailing spaces in the ANSWER parameters. This causes a SQL error and prevents the command from executing.

Copy 
CREATE MOBILESUBSCRIPTION [subscription_name] 
 [FOR OWNERlogin_name] SCHEDULEschedule_name (USERuser_name | GROUP user_group_name) CONTENT (report_or_document_nameIN FOLDERlocation_name | GUID report_or_document_guid) [CONTENTTYPE (REPORT | DOCUMENT)] IN PROJECTproject_name [EXPIRATIONDATEmm/dd/yyyy] [MODIFICATIONBYRECIPIENTS (TRUE|FALSE)] [DEVICE (SMARTPHONE| 
 TABLET)] [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

  • user_name is the name of the user

  • user_group_name is the name of the group

  • report_or_document_name is the name of the Report or Document

  • location_name is the name of the folder where the report or document resides

  • report_or_document_guid is the GUID of the report or document

  • project_name is the name of the project where the report or document resides

  • mm/dd/yyyy is the expiration date of the mobile subscription

  • prompt_name1..n are the names of prompts in the report or document

  • prompt_answer1..n are the answers to the corresponding prompts

The parameters and syntax are identical to a History List subscription (except DeliveryNotification)