Skip to main content

Microstrategy Alerts setup

Alerts Editor

Alerts can be sent to an email address or to an iPhone, iPad, or Android device with MicroStrategy Mobile. This allows users to be notified of data that is likely to be important for making business decisions. You can also have formatting automatically applied to metric values in the report, to draw immediate attention to the data that meets the alert's threshold conditions. For example, when the Inventory Count data in a report falls below 1,000 units, you can have the report sent to you, with the values below 1,000 displayed in red text.
You can specify a subject and message to display for the alert, as well as a report or document to be displayed when viewing the alert, as described below. You can receive and view alerts on a mobile device even if the MicroStrategy Mobile application is not running.
Prerequisites

  •   
  • You must have the MicroStrategy Distribution Services product installed and MicroStrategy Web must be configured to use Distribution Services.
  • You must have the Use Send Preview Now privilege to send a preview of the report to the selected recipients as soon as the alert is created.
  • For alerts to be sent to mobile devices:
    • Mobile device users must have the Use MicroStrategy Mobile and Mobile View Document privileges.
    •
  • For alerts to be sent to email addresses:
    • You must have the Web Subscribe to History List privilege to send a report or document to the History List.
    • You must have the Use Link to History List in Email privilege to send a link to the location of a report or document in the History List via email.
The Alerts Editor contains the following areas:

  • A toolbar at the top of the Alerts Editor, which contains options to create threshold conditions, specify the formatting to apply to data that meets the threshold condition, and so on.
  • A list of the threshold conditions: The middle area of the Alerts Editor lists all the threshold conditions defined for the report object selected in the toolbar. To create a threshold condition, from the Filter On drop-down list, select the attribute or metric to create the condition based on, then define the condition. 
  • The Delivery Settings section, which contains options to determine who receives the alert, how often to send the alert, what format to use to send the alert, and so on.
The options in each area are described in greater detail below.

The toolbar

The toolbar at the top of the Alerts Editor contains:

  • A drop-down list (at the far left), containing the name of each metric in the report. To create a new threshold condition, select a metric whose values you want to have automatically formatted, then click Click here to add a new condition. For detailed steps to define alerts, including steps to create threshold conditions.
  • Add Condition Add Condition icon: Add a new threshold condition to the alert.
  • Clear All Clear All icon: Delete all the threshold conditions for the report object selected in the drop-down list.
  • Cell Formatting Cell Formatting icon: Change the formatting that is automatically applied to data that meets the threshold condition. To format the threshold values by adjusting the font, color, alignment, and other options, make the appropriate selections within the Font, Number, Alignment, and Color and Lines tabs. 
  • Format Metric Only Format Metric Only icon: Select this option to apply formatting only to the metric values that meet the threshold condition. This option is selected by default.
  • Format Subtotals Only Format Subtotals Only icon: Select this option to apply formatting only to metric subtotal values that meet the threshold condition.
  • Format Metric and Subtotals Format Metric and Subtotals icon: Select this option to apply formatting to both metric values and subtotals.

Delivery Settings

The following Delivery Settings options are available:

  • Name: Type a name for the subscription.
  • Schedule: Select a schedule or event to use to determine when to deliver the alert. The schedule choices available are created in the Schedule Manager in Desktop. 
  • To: Select the recipients to send the alert to, then click OK.
  • Send: Determine where the report is delivered. The options available may vary depending on the privileges you are assigned. For more information on the required privileges, see the prerequisites. This setting is only available for alerts sent to an email address. The options are:
    • Data in email: The report is displayed in the email.
    • Data in email and to history list: The report is displayed in the email and is also delivered to the History List.
    • Data and link to history list in email: The report is displayed in the email, along with a link to the History List location of the report.
    • Link to history list in email: A link to the History List location of the report is provided in the email.
    •
  • Delivery format: Select the format in which to send the report. If you select a format other than HTML, you can reduce the size of the attachment by selecting the Compress contents check box. When Excel or PDF is chosen, the report is included as an attachment in the email. This option is only available for alerts sent to email addresses.
  • Compress contents: Determine whether to reduce the size of the attachment by including the report in a zip file. This option is only available for alerts sent to email addresses.
  • Device type: Determine the type of mobile device you want to send the report to. This option is only available for alerts sent to a mobile device.
  • Target Application: Select the type of application you want to send the report to. This option is only available for alerts sent to a mobile device.
  • Subject: Type a description of the report, to display in the subject of the email or mobile notification. For mobile device alerts, the subject should not exceed 25 characters.
  • Message: Type a message to display in the body of the email or mobile notification. For mobile device alerts, the message should not exceed 50 characters.
  • Send a preview now: Determine whether to send a preview of the report to the selected recipients as soon as the alert is created.
  • Send all data. Format cells that meet condition: Select this option to send the report in which the alert is defined, with formatting applied to the metric values that meet the alert condition.
  • Send different report or document: You can specify a report or document to send as part of the alert notification when the alert's conditions are met. For example, when a metric in a report meets the conditions of the alert you have defined, you can choose to send a related report to a user's mobile device. Select this option to specify the report or document you want to send. Browse to and select the report or document to send in the email, then click OK. To be sure the system can successfully execute the selected report, ensure that the report contains default prompt answers.
  • Update application badge with the value of this metric: Select this option to update the badge next to the MicroStrategy Mobile application icon on a mobile device when the threshold condition is met. From the drop-down list next to the check box, select the metric that contains the number that you want to display next to the application icon. If there are multiple rows of data for this metric on the report, the mobile device will display the first value shown on the report for the selected metric. This option is only available for alerts sent to a mobile device.
  • Advanced Options:
    • Password protect zip file: Select this option to password protect a report included in a zip file. Select the Password protect zip file check box and type a password for the zip file. This option is only available for alerts sent to email addresses. This option is available only when the Compress Contents check box is selected.
    • Zip File Name: Type a name for the zip file in the Zip File Name field. This option is only available for alerts sent to email addresses. This option is available only when the Compress Contents check box is selected.
    • Do not deliver after: To specify an expiration date for the alert, select the Do not deliver after check box and choose a date from the calendar.
    • If you have selected multiple recipients, the following options are displayed:
      • Allow recipients to change delivery settings: Allow the recipient to change subscription delivery settings, such as the expiration date of the subscription.
      • Allow recipients to change personalization: Allow the recipient to view and change personalization settings, such as prompt answers for the report.
      • Allow recipients to unsubscribe: Allow the recipient to unsubscribe from the report.

Labels:

Comments

Post a Comment

Popular posts from this blog

Microstrategy "Error type: Odbc error. Odbc operation attempted

 "Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [HYT00:0: on SQLHANDLE] [MicroStrategy][ODBC Oracle Wire Protocol driver]Timeout expired" is shown when executing reports from Web When users are trying to execute some reports in MicroStrategy web in particular, they may receive the Error “SQL Generation Complete Index out of range” and “Timeout expired” error as shown below: Possible Causes: One possible cause is that the MicroStrategy Intelligence Server using a cached database connection that was already dropped by the RDBMS. To resolve this: Admin should delete the database connection caches and create a new DSNs in case they are sharing DSNs to connect to different databases. In addition, change the settings for the ‘Connection lifetime’ and the ‘Connection idle time out’.  Follow the steps below to perform the mentioned changes and verify the report after each step and some of the settings require i-server r...
4 comments
Read more

MicroStrategy URL API Parameters

MicroStrategy URL Structure The following table summarizes the root URL structure used for every request to MicroStrategy Web. Environment Main Application URL Administration URL J2EE http://webserver/MicroStrategy/servlet/mstrWeb http://webserver/MicroStrategy/servlet/mstrWebAdmin .NET http://webserver/MicroStrategy/asp/Main.aspx http://webserver/MicroStrategy/asp/Admin.aspx Every request sent to MicroStrategy Web calls a central controller. Parameters are appended to  Main.aspx  or  mstrWeb  (in a .NET and J2EE environment, respectively) to indicate to the controller how the request should be internally forwarded and handled. The following examples show a URL for accessing a MicroStrategy folder when the user does not have an existing session. The URL contains not only the parameters needed to connect to MicroStrategy Web, but also the parameters needed to log on and create a session. J2EE environment: <a href="http:...
2 comments
Read more

Types of filters in Microstrategy

Types of filters in Microstrategy Below are the types of filters: 1. Attribute qualification filter These types of qualifications restrict data related to attributes on the report. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. •  For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. An attribute form qualification might filter on the form Last Name, the operator Begins With, and the letter H. The results show a list of customers whose last names start with the letter H. b) Attribute element list qualification Filters data related to a business attribute’s elements, such as New York, Washington, and San Francisco, which are elements of the attribute City. • For example, the attribute Customer has the elements John Smith, Jane Doe, William Hill, and so on. An attribute element list qualification can filter data to display only those customer...
6 comments
Read more

Logical Views to specify an outer join between two attribute lookup tables when only attributes are on a report

Logical Views to specify an outer join between two attribute lookup tables when only attributes are on a report Apart from using the VLDB properties to create the left outer join,  article describes how to use the Logical View to specify an outer join between two attribute lookup tables when only attributes are on a report. This method exists as attribute only outer joins will not be generated on their own by the MicroStrategy SQL engine. This is because they are only necessary with r agged/unbalanced hierarchies which are not supported as null attribute IDs are not supported (parent elements with no child elements or child elements with no parents).  Brief instructions are provided using the example below. Consider, two attributes: Parent01 and Child01 have a parent-child relationship. Their Lookup tables are defined, as follows Parent01 Child01 Note that although there are 4 ID values for the attribute Parent01, there is no defined relationship ...
Post a Comment
Read more

Types of prompts in Microstrategy

Types of prompts in Microstrategy The different types of prompts allow you to create a  prompt  for nearly every part of a report. Prompts can be used in many objects including reports, filters, metrics, and custom groups, but all prompts require user interaction when the report is executed. The correct prompt type to create depends on what report objects you want users to be able to base a filter on to filter data, as described in the list below. Filter definition prompts   allow users to determine how the report's data is filtered, based on one of the following objects: Attributes in a hierarchy : Users can select prompt answers from one or more attribute elements from one or more attributes. The attribute elements that they select are used to filter data displayed on the report. This prompt lets you give users the largest number of attribute elements to choose from when they answer the prompt to define their filtering criteria. For example, on a repor...
1 comment
Read more

Email Subscription in Microstrategy

Create Email Subscription in Microstrategy Creates an email subscription. Do not include any leading or trailing spaces in the ANSWER parameters. This causes a SQL error and prevents the command from executing. Ex: CREATE EMAILSUBSCRIPTION "New Multi Users" FOR OWNER "administrator" SCHEDULE "Books Closed" CONTACTGROUP "TEST"  CONTENT "Electronics Revenue by Region" IN FOLDER "\Public Objects\REPORTS\SUBJECT Areas\Sales and Profitability Analysis" IN PROJECT "MicroStrategy Tutorial" DELIVERYFORMAT HTML  EXPIRATIONDATE NEVER EXPRIED FILENAME "file_name"   SUBJECT  "Test REPORT" MESSAGE "Please Test"; CREATE EMAILSUBSCRIPTION [ subscription_name ] [FOR OWNER login_name ] SCHEDULE schedule_name  (ADDRESS address_name | USER user_name  | CONTACT contact_name [ADDRESS contact_ address_name ] | CONTACTGROUP contact_group_name ) CONTENT ( report_or_document_name IN FOLDER   loc...
1 comment
Read more

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 bel...
3 comments
Read more

Scheduling a report or document to be sent to an FTP in MSTR

Scheduling a report or document to be sent to an FTP server You can have a report or document automatically delivered to a location on your FTP server on a specific schedule. To do so, you must subscribe to the report or document, as described in the steps below. You can customize your subscription by typing macros in the  File Name ,  Sub-folder , 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  File Name field, the name of the project in which the document is saved is displayed in the name of the document when it is delivered. • This procedure assumes that an administrator has already added your FTP server as a new device in Developer. Steps to do so are included in the  System Administrator Help . To send a report or document to an FTP server on a schedule ...
Post a Comment
Read more

Developer not starting with "invalid picture" message

Developer not starting with "invalid picture" message. This error could be due to the fact that t here is insufficient disk space on the drive used for the Windows Temp directory or the Optional Work Drive. https://support.microsoft.com/en-us/help/964421/error-481-invalid-picture Users may see the "Invalid Picture" error thrown when attempting to launch MicroStrategy Developer in Windows: CAUSE: This error is caused by a lack of available space on the user's hard disk to properly launch the platform. ACTION: To remedy the issue, simply clear up some active space on the hard drive to allow MicroStrategy to properly launch.
2 comments
Read more
Using stored procedures within Freeform SQL reports in MicroStrategy Database SQL to Stored Procedure in the DB execute procedure in Freeform Editor in MSTR Microsoft SQL Server CREATE PROCEDURE emp_search @DistCtrID INT as     SET NOCOUNT ON;     SELECT emp_id, emp_first_name + ' ' + emp_last_name     FROM lu_employee     WHERE dist_ctr_id = @DistCtrID; exec sp_ProcedureName @Parameter1= Prompt @Parameter2= Prompt .... ..... After adding the exec procedure statement in Freeform SQL Editor, Add the column for the output columns in the DB stored procedure. https://community.microstrategy.com/s/article/KB37783-Instructions-to-use-stored-procedures-within-Freeform
Post a Comment
Read more