Create an alert-based subscription in MicroStrategy Distribution Services

Create an alert-based subscription in MicroStrategy Distribution Services on Web

Subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. For example, a scheduled report executes which shows the Revenue by day for the past week. If the Revenue on any one day falls below a certain value, a subscription to another report or Report Services document can be triggered and delivered to a recipient. An alert based subscription can only be created directly on a report; however, another report or Report Services document can be delivered when the alert based subscription is triggered.

Note: you need a grid report to create an alert and you cannot create if you want to create on a document with text boxes.

The following example will walk through the basic steps on how to setup a subscription based on an alert like this:

Follow the brief steps below:

• In MicroStrategy Web, edit or execute a report.
• Right-click on the metric header to apply the condition or threshold and select 'Alerts':
• Specify the conditions to meet for the delivery to be triggered in the filter editor:
• Expand the Delivery Settings section.
• Specify the desired delivery options including recipient address, subscription name, delivery format, compression options and the schedule to run the report and check the condition.
• To deliver the same report when the condition is met, select the 'Send all data. Format cells that meet condition' option. To deliver a different report or document when the condition is met, select the 'Send different report or document' and select the report/document to deliver:
• Click OK to save the alert subscription.