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

Reduce Intelligent Cube Size By Finding Intelligent Cube Objects Which Are Not In Use

Reduce Intelligent Cube Size By Finding Intelligent Cube Objects Which Are Not In Use If the i-cubes can potentially be reduced in size an audit can be performed on the cube objects to see which cube objects are not being used by any of the view reports, documents, or dossiers.   The below are examples for a few of the common metadata database platforms . NOTE: To perform this audit, queries are run against the MicroStrategy metadata database. Ensure a metadata backup is taken prior to performing the below actions. Steps: 1) Identify the object ID of the Intelligent cube to be audited by checking the objects Property window 2) Identify the object ID of the project this cube exists within by opening the Project Configuration Sample Cube ID =   CFAF1E9B4D53990698C42E87C7AF2EB5 Sample Project ID =  B7CA92F04B9FAE8D941C3E9B7E0CD754   3) Run the below SQL against the metadata database by replacing the Cube ID and Project ID within the respective ...
Post a Comment
Read more

Algorithm to calculate Logical Table Size in Microstrategy

How are the fact tables determined using the logical table size for SQL generation in MicroStrategy The logical table size is an integer number that represents the granularity or level of aggregation of a particular table. It is called 'logical' because it is not related to the physical size of the tables (number of rows). It is calculated according to the attribute IDs that are present in the table and their level in the system hierarchy.   Even though, the number does not reveal the actual number of rows in the table, it is an accurate way of measuring a table size without having to access its contents.   IMPORTANT:   The system hierarchy is defined by the parent-child relationships between attributes of the same family (formerly known as a dimension), not by user-defined hierarchies (i.e., drilling hierarchies).   MicroStrategy Engine utilizes an algorithm based on attribute keys to calculate the Logical Table Size (LTS): Given the following tables: ...
Post a Comment
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

Conversion failed when converting the varchar value 'xxxx' Microstartegy

Error "Conversion failed  Error "Conversion failed when converting the varchar value 'xxxx' to data type int" happens when displaying Picture type attribute form using ApplySimple in expression against SQL Server 2012 in MicroStrategy  The attribute form is in Picture type and defined with the following ApplySimple function with Int type column [ID_BARANG] as the input parameter against SQL Server 2012.  Solutions is to use  Concat("Images/demo/s", [BARANG_ID_INT], ".png") ApplySimple("'images/demo/'&#0&'.png'", [ID_BARANG]) However, when running reports with attribute to show the picture form in Web, error message happens in both Web and Developer. Conversion failed when converting the varchar value 'images/demo/s' to data type int. STEPS TO REPRODUCE: SQL Server 2012 database should be used as the warehouse.  Create an attribute form as type Picture and us custom expressi...
1 comment
Read more

Activate MicroStrategy Geospatial Services

Activate MicroStrategy Geospatial Services MicroStrategy 10.11 introduces our new mapping capability: MicroStrategy Geospatial Services, powered by Mapbox. This enhanced map visualization is available for dossiers on all interfaces including MicroStrategy Desktop, Workstation, Web and Library (Mobile included). With MicroStrategy Geospatial Services, MicroStrategy now offers advanced geospatial analytics features that allow users to get more out of their location data. This new feature is available in addition to the out-of-the-box ESRI maps. MicroStrategy Geospatial Services allows users to: Plot polygon shapes for most countries, down to the zip code level Perform powerful interaction between layers (progressively hide or show data layers as zoom levels change) Identify and resolve location name conflicts Add thresholds to data points, size markers for metrics, and color by for both attributes and metrics Fine tune clustering behavior when aggregating data on a ma...
2 comments
Read more

Enable Incremental fetch in MSTR documents

Enable Incremental fetch in MSTR documents Incremental fetch divides large documents or layouts into pages, thereby loading the data in batches (or blocks) rather than all at the same time. This improves the usability and performance of a large document or layout, by reducing the load and overall memory usage on the web server. To apply incremental fetch to a document In MicroStrategy Web, open the document in the Document Editor. If the document contains multiple layouts, select the layout to apply incremental fetch to. From the  Tools  menu, choose  Document Properties . The Document Properties dialog box opens. On the left, under Layout Properties, select  Advanced . Select the  Enable Incremental Fetch  check box. From the  Fetch Level  drop-down list, select the object to be counted for the incremental fetch level. If the document or layout is grouped, the groups are displayed in the drop-down list. Groups that are displayed...
1 comment
Read more

Microstrategy Removing sections that do not have metric data

Removing sections that do not have metric data This is an interesting feature which might not be explored by many of us and it comes us handy. A  cross join between datasets can result in rows or Group Header/Footer sections that do not have metric data. For example, a document contains two datasets. Dataset 1 contains Year and Revenue, with data for three years (2007-2009). Dataset 2 contains Year and Profit, filtered to return data for only two years (2008 and 2009). If you place Year and Profit in the Details and execute the document, it displays three rows, although no profit data exists for 2007. This is a product of the cross join between the two datasets. You do not want to see the blank line for 2007 since it does not give you any data for profit. You can select the  Trim sections for which no metric value data is available  check box. This removes the row for 2007, since no metric data for Profit is available for 2007. The results are shown below: ...
Post a Comment
Read more

Predictive modelling in Data Science using Microstrategy

Creating a predictive modelling in MicroStrategy MicroStrategy Data Mining Services has been evolving to include more data mining algorithms and functionality. One key feature is MicroStrategy Developer’s Training Metric Wizard. The Training Metric Wizard can be used to create several different types of predictive models including linear and exponential regression, logistic regression, decision tree, cluster, time series, and association rules. Linear and exponential regression The linear regression data mining technique should be familiar to you if you have ever tried to extrapolate or interpolate data, tried to find the line that best fits a series of data points, or used Microsoft Excel’s LINEST or LOGEST functions. Regression analyzes the relationship between several predictive inputs, or independent variables, and a dependent variable that is to be predicted. Regression finds the line that best fits the data, with a minimum of error. For example, you have a dataset ...
1 comment
Read more

Customers Who Live in the Same City as Call Centers

Customers Who Live in the Same City as Call Centers Your new utility company has call centers located throughout the country, and your recent surveys indicate that customers who live in the same city as a call center are particularly satisfied with service due to extremely rapid repairs during power outages. To begin your new advertising campaign, you want to generate a list of Call Centers that coincide with Customer Cities. The following steps create an attribute-to-attribute qualification filter that generates the list of desired cities. To Create an Attribute-To-Attribute Qualification that Compares the Call Center and Customer City Attributes In MicroStrategy Web, log in to a project. Open any folder page (for example, click Shared Folders on the home page). Click the  Create Filter  icon  . From the Object browser on the left, select the  Customer City  attribute from the Customers hierarchy and drag it to the filter pane on the right. Change  Qualify...
1 comment
Read more

"System Prompt" and its uses in MicroStrategy

System Prompt and its uses in MicroStrategy WHAT IS A "SYSTEM PROMPT"? "System Prompt" is a system object that was introduced back in version 8.0.0. The object is named as "User Login" and is implemented as a prompt object. The object can be found under Public Objects > Prompts > System prompts, as shown below: Unlike ordinary prompt objects, system prompts don't require any answers from the user. When a report containing a system prompt runs, the prompt is answered automatically with the login of the user who runs the report. On the other hand, like other prompt objects, answers to system prompts are used to match caches. Therefore, users don't share caches for reports that contain system prompts. For details on how caches are matched, refer to the following MicroStrategy Knowledge Base document: KB5300-7X0-0147 - How are caches matched in MicroStrategy Intelligence Server 7.x? WHEN ARE SYSTEM PROMPTS USED?    System pr...
Post a Comment
Read more