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.
This comment has been removed by the author.
ReplyDeleteyour valuable information and time. Please keep updating.
ReplyDeleteLearn Micro Strategy Online
Micro Strategy Dossier Training