Scheduling a report or document to be emailed

You can have a report or document automatically emailed, on a specific schedule.

Note: If you are sending a Flash-enabled document to another user, the recipient can use the Flash document only to the extent that you are able to. This is determined by your MicroStrategy privileges. For example, if you do not have the privilege to modify a widget in the Flash document, the recipient of the document will not be able to modify a widget in the document.

You can ensure that you or other users are notified when a report meets specific threshold conditions. For example, you can have an email sent to you when the units sold data in a report falls under 500 units. You automatically receive an email when this threshold is met.

You can also have emailed reports delivered to you automatically based on an alert condition that appears in a different report. For example, if your company-wide Monthly Revenue report is run on a schedule and displays revenue in the Northeast region below $1,000,000, the Sales Report for the Northeast Region can be automatically emailed to you based on the $1,000,000 threshold that is part of the company-wide Monthly Revenue report. For steps to email a report or document when threshold conditions are met, see the Basic Reporting Guide.

You can customize your subscription by typing macros in the File Name, Subject, Message, or Zip File Name fields. These macros are automatically replaced with the appropriate text when the report or document is delivered. For example, you create a subscription to a document. If you type {&Project} in the Subject field, the name of the project in which the document is saved is displayed in the subject of the email when the document is delivered.

For a list of the macros available, see the Automating Tasks chapter of the System Administration Guide.

Prerequisites

To email a report or document on a schedule

  1. Click on the name of the report or document. The report or document opens.

  2. From the Home menu, point to Subscribe to, and select E-mail. The Subscribe to E-mail dialog box opens.

  3. Type a name for the subscription in the Name field.

  4. From the Schedule drop-down list, select a schedule or event. The schedule choices available are created in the Schedule Manager in Desktop.

  5. Select To. The Recipients Browser dialog box opens. Choose an email address to send the report or document to.

  6. From the Send drop-down list, specify how the report is included in the email, by choosing one of the following:

    Note
    : The options available may vary depending on the privileges you are assigned. For more information on the required privileges, see the prerequisites.

  7. From the Delivery Format drop-down list, select the format in which to send the report.

  8. You can specify the delimiter character to use to separate values in a report, such as a comma or tab. From the Delimiter drop-down list, select one of the following:

  9. Note: This option is only available if the Delivery Format option is set to Plain Text.

  10. Expand page-by fields: Displayed only when the report contains grouped objects. Select this check box to print all objects in the Page-by drop-down lists when printing a report. To print only the objects currently displayed (currently selected in the Page-by field), clear this check box. For an introduction to page-by, see Grouping data by page: Page-by.

  11. In the Subject field, type a description for the emailed report.

  12. If you want a message to display in the body of the email, type the text in the Message field.

  13. If you want to preview the report or document, select the Send a preview now check box.

  14. Expand Advanced Options.

  15. To include the report or document in a zip file:

    1. Select the Password protect zip file check box and type a password for the zip file.

    2. Then type a name for the zip file in the Zip File Name field.

      Note
      : The above options are enabled only when you have selected the Compress Contents check box.

  16. Select the Do not deliver after check box and specify an expiration date for the subscription by choosing a date from the calendar.

  17. If you have selected multiple recipients, the following options are displayed.

  18. For a report with prompts, all prompts are displayed. The selections you make for these prompts will be used whenever the report is delivered.

  19. Click OK. The subscription is created, and the message will be sent to the selected email address on the specified schedule.

To verify that you are subscribed to the report or document, click My Subscriptions at the top of any page. The report appears in the Email Subscriptions list.