Microstrategy Analytics

Setting up a System Manager workflow to execute on a schedule in MicroStrategy In some instances, a MicroStrategy user may want a System Manager workflow to execute on a set schedule or after an event has been triggered. This can be accomplished by creating a simple batch file, and scheduling that batch file to execute with a third-party tool like Microsoft Task Scheduler.   Note : To avoid user permission conflicts, the following steps must be performed with highest privileges.   In the following example, a user would like to execute a workflow that restarts the Intelligence Server every day.   1. The user must first have a valid workflow. This particular workflow is a template that is delivered out-of-the-box with System Manager.     2. Save the workflow in  .smw  format.   3. In a text editor (such as Notepad), enter the command line statement that the task scheduler should execute.       4. Save the file in ...

The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager  Use the "CREATE USER" outline to write a script to create a new user. For example, to create a user with ID 'mstr_test' and full name "MSTR Test", type the following command: CREATE USER "mstr_test" PASSWORD "123" FULLNAME "MSTR Test" PASSWORDEXP NEVER; Use the "ADD USER" outline to write a script to add the user to multiple user groups. For example, to add user "mstr_test" to group "Managers" and "Developers", type the following command: ADD USER "mstr_test" TO GROUP "Managers", "Developers"; Example script for MSTR Cloud: CREATE USER "wlu" PASSWORD "" FULLNAME "Wendy Lu" PASSWORDEXP NEVER; ADD USER "wlu" TO GROUP "Managers", "MicroStrategy Desktop Designer";  CREAT...

Web URL to C onnect to the Web/Mobile Administrator page in MicroStrategy Cloud Environment   To access the Web/Mobile Administrator page in MicroStrategy Cloud,  you could use the following URLs to connect (where " machinename " refers to the actual machine name of the corresponding I-server/Web-server):   Web Administrator :   https://machinename:8443/MicroStrategy/servlet/mstrWebAdmin   Mobile Administrator :    https://machinename:8443/MicroStrategyMobile/servlet/mstrWebAdmin  

Subtotals across level are displayed at the bottom of the of the grid report instead of distributed under each attribute element in MicroStrategy . In certain reports, users may notice that subtotals defined across level are not  broken by attribute element in a grid report in MicroStrategy Developer are instead displayed at the bottom of the page as shown in the image below:       CAUSE: This behavior is observed because of the way in which the Advanced Sorting is defined in the report.  The subtotals are arranged in the observed way to preserve the sorting order.     To fix this: Make sure that the placing of the attributes on the template is consistent with the order defined in the advanced sorting options to display the subtotals in the expected position as shown in the image below.

Element browsing is not supported for this subtype of attributes]" error message appears MicroStrategy This happens when browsing attribute elements in a filter, prompt report or dashboard. When running a prompt dashboard in MicroStrategy Web 9.4.1 and above, the following error message appears when browsing prompt attribute. The issue does not occur in MicroStrategy Desktop.         "Element browsing is not supported for this subtype of attributes. The element net server was unable to load an element collection from the element server due to failure." CAUSE: Possible causes are: There is no browse forms selected in the attribute creation process, this also happens when one of the browse forms have been deleted by architect and forget to add another browse form. The attribute contains multiple browsing form and MicroStrategy Web is unable to load its elements.     WORKAROUND: Add a browsing form under display tab of the attribute, so that display form ...

Email bursting is in MicroStrategy  Email bursting feature allows users to send out personalized slices of a single report execution to a dynamic list of recipients. Prior to MicroStrategy 10, Distribution Services was able to burst page-by slices to file; this capability has been extended to email as well. Follow the steps below to  to burst to email: Build the following report with attributes and metrics Note that the Manager attribute appears in the page-by. Email bursting , like file requires at least one attribute in the page-by .         Also, at least one of the page-by attributes should have an email attribute form .   Right-click on the Manager attribute in the page-by and add the Email attribute form. Save the report as “Email Bursting” Open the report’s subscriptions in MicroStrategy Web: Scroll down to the Email subscription and click the option to “Add email subscription”: Choose the schedule by clicking the drop-down...

Tag Users in Microstrategy Dossier You can tag multiple users or user groups in a comment. You want to tag the team leader responsible for creating the dossier. Navigate to the first page of the Office Royale Sales dossier. On the  Overview  page, click the  Comments    icon. In  Comments , enter  @ . A list of suggested users appears as you type. The owner and/or certifier of the dossier appears at the top of the list with  Owner    and  Certifier    icons. Select a user from the list. If you want to include the filtered state of your dossier, enter  @  in  Comments  and click  filter . Enter your message. Click  Post .

Certify Dossiers in MicroStrategy Web Dossiers can be certified for an environment by users with certain permissions. Certified items have typically been reviewed by trusted members of your organization and are considered official sources of content, based on reliable data. Two of the Security Role which have the ability to certify dossiers: Application Administrator  - Users granted this role have access to all application specific tasks. Certifier  - Users granted this role can certify objects in addition to the authoring capabilities. Follow the steps  below   with a user who has   Certifier privileges  which has been added newly Users without certifier/application administrator privileges will not see the option to certify. In MicroStrategy Web, right-click on a dossier and select Properties.   Check the Certified option and click Ok.   Navigate to MicroStrategy Library and users will see the orange certified flag...

MSTR Reports drop records when two tables join on a column with null values CAUSE:   The MicroStrategy SQL Generation Engine does not support null values in attribute ID columns. Using column name as in attribute ID form is incorrect modeling for the MicroStrategy SQL Generation Engine. WORKAROUND:  Modify the ID form of the attribute definition to the following: ApplySimple('NVL(#0, 0)', ) This syntax is Oracle specific and this function replaces null fields with zeros. This function syntax, however, may be altered to replace Zero by any value. Ensure that single quotes are placed around the text. That should take care of NULL values in the joining column.

Enter a valid physical address error in Microstrategy  Web This issue occurs when adding an Email addresses with an apostrophe and trying to add it to the recipients list, the following error occurs in MicroStrategy Web 8.x/9.x/10.x/11.x etc This is a known issue in MicroStrategy Web 9.x/10.x.11.x and has never been fixed in Web. As a workaround MSTR suggests that to add the email from Developer. Work Around.  The email address can be entered from MicroStrategy Developer using the steps below: Login to Developer with admin privileges or access to create contacts. Go to Administration Click on Delivery Managers and then Contacts Right click in empty space in window where Contacts are displayed. Select New -> Contact Give the Name of the contact in the General tab and to to Addresses tab and click New Give the Name to be displayed on the contact and physical address Under Security tab select a user for "Link contact to user" Click on OK. Now go t...

Trick to Stop a Report Services Document subscription from sending if no data is returned in MicroStrategy Web The following steps are for stopping a Report Services Document subscription from sending if no data is returned: 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 condition " Is Not Null " to the metric for the delivery to be triggered in the filter editor as shown below. 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.  The subscription will be sent on the defined schedule only when data is returned in the Report Services Document.

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...

The 'Alert' option does not appear when attempting to create an alert-based subscription in MicroStrategy Distribution Services In MicroStrategy Distribution Service 9.x and 10.x, and 11.x versions it is possible to create an alert-based subscription. When right-clicking the metric header of a report in MicroStrategy Web 9.0.x, the 'Alerts' option does not appear:    Cause : This issue occurs because the user attempting to create the alert does  not have all of the necessary privileges on alerts.   Fix : In order to create an alert-based subscription, the following privileges are required: In order ti get permissions to create alerts the user should be given the following privileges by the admin: New Version of Microstrategy 11.x: Server- Distribution: Older Versions of Microstrategy 9.x, 10.x etc..: Web Reporter > Web user Web Analyst > Web create alert   ...