Strategy One

Create File Subscriptions

Create file subscriptions through Distribution Services. You can select one dashboard, document, or report to be delivered through a file device, define a schedule and message, and specify settings for the subscription object.

You can also add bursting to file subscriptions. Bursting in Strategy Distribution Services delivers reports and documents to a dynamic list of recipients with data sliced by a specific attribute. Bursting is used when you must send personalized slices of data to multiple file locations with a single subscription. Bursting allows easy distribution of data to multiple file devices dynamically and delivers data in a single execution enhancing the performance.

| Bursting is unavailable by default. It is only available for reports and documents that have at least one attribute in the page-by section.

  1. Open the Workstation window.
  2. In the Navigation pane, click Subscriptions.
  3. Click Create New Subscription.
  4. In the Create New window, if you are connected to multiple projects, select the project from the drop-down list on the left.
  5. In Name, enter a descriptive name for the subscription.

  6. From the Type drop-down, choose File.

  7. In the Content pane, click . Select content to add to one subscription, such as one dashboard, document, or report.

  8. In the Content pane, click More next to each dashboard or report to change the delivery format.

    S upported formats for dashboards are CSV, Excel, PDF, and .mstr files. Supported formats for reports are CSV, Excel, HTML, PDF, and plain text files.

    • If you select Plain Text, select the delimiter character from the Delimiter drop-down list.

    • If you select PDF for a dashboard, you can define PDF settings such as the range, page size, and showing page numbers. Click Settings to display the PDF Settings window. After you define the settings, click Save to return to the subscription.

    • If you select Excel for a dashboard, define the Range by specifying which pages and chapters to include, select whether each page or each visualization is exported to a worksheet by defining the Contents, and determine whether to Show Filters.

    • If you select Excel for a report, define the Range by specifying whether to expand all page-by fields and export the page-by information, selecting whether to Export the Report Title and Export Filter Details, and customizing the Header and Footer text.

    • If you select CSV for a dashboard, define the Range by specifying which pages and chapters to include and select the delimiter character from the Delimiter drop-down list.

  9. Expand the Schedule drop-down list and choose an existing schedule or click Add New Schedule. For information on creating schedules, see Create and Edit Schedules.

    To only view schedules you own, toggle on Show my schedules only.

  10. Once the schedule is set, you can optionally specify the date when the subscription should stop by selecting the date in Expire on or Stop After and choose a Timezone, if available.

  11. If you have selected a report or document with at least one page-by attribute, you can select an attribute for Bursting.

  12. Enter the desired File Name with the necessary macros for customized file delivery.

  13. To deliver the files to users' file delivery addresses, select File locations from Users . Click Add User to add users for the file delivery

  14. To deliver files to a file device or a user specified file location, select File locations from Sub-folder. Select the file devices from the drop-down or type in a path for a specific file location.

  15. Click to adjust subscription-level settings . You can set the contact security level, as well as choose the compression and zip file password. To learn more about the contact security level, see Create FTP Subscriptions.

  16. If necessary, you can opt to Send notifications to user’s email and Run the subscription immediately after saving.

  17. Click Save.