Microstrategy Analytics

Subtotals across level are displayed at the bottom of the of the grid report instead  of distributed under each attribute element In certain reports, users may notice that subtotals defined across level are not  broken by attribute element in a grid report in MicroStrategy Developer 9.4.x-10.x and 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. ACTION: 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.

Generate a MicroStrategy Connection File to Connect Workstation to a MicroStrategy Environment A MicroStrategy connection file (.mstrc) is a text file that contains all of the information needed to connect Workstation to a MicroStrategy environment. When adding a new environment to Workstation, just drag and drop your .mstr file into the connection window, enter your credentials, and configuration is complete. Once you have connected to an environment, you can generate the .mstrc file for that environment for back up or to share and allow others to connect.  This article explains how to generate a .mstrc file for an environment.  How to create a MicroStrategy connection file (.mstrc) Open Workstation. Right-click on an existing environment and choose Properties.  If an environment does not already exist, an environment will need to be created first. In the bottom left corner, click on the button "Generate Connection File". No...

Defining custom subtotal displays in MicroStrategy By default, when users apply subtotals in a report, the name of the subtotal is displayed in the subtotal line items that appear in the report. Users can use custom subtotals to give more control over the characteristics of a subtotal. Custom subtotals allow users to define custom subtotal line items that appear on the reports  U sers can make the subtotal name dynamic by typing special characters in the subtotal name field as listed in the following table. Character Description #A The name of the attribute under which the subtotal appears. #P The name of the attribute to the left of, or above the attribute under which the subtotal appears. #0 All the forms of the parent element. #1 The first form of the parent element reading from left to right or from top to bottom. #2 The second form of the parent element reading from left to right or from top to bottom. #3 The third form of th...

Autotext  code/macros in  Microstrategy Document/dashboard This is a list of the available auto text macros that the Report Services Document engine recognizes. The following auto text codes allow you to add  document variable information to your document. These auto text codes are automatically replaced by information about the document. Auto text codes for MSTR document/dashboard:  AUTOTEXT DESCRIPTION   {&PAGE}  Display the current page.  {&NPAGES}  Display the total number of pages.  {&DATETIME}  Display the current date and time.  {&USER}  Display the user name that is executing the Report Services Document.  {&DOCUMENT}  Display the document name.  {&DOCUMENTID}  Display the document ID.  {&DESCRIPTION}  Display the document description.  {&PROJECT}  Display the project name.  {&EXECUTIONTIME}  Dis...

Microstrategy Release Types and Scheduling Organizations that use MicroStrategy have asked for a more frequent and predictable platform release schedule—and we listened! We want you to be able to adopt the latest innovations more regularly while having the ability to budget for your long-term upgrade roadmap. Recently announced by CTO Tim Lang in his newsletter, that’s why we’re adopting an annual cadence for future platform releases. This means that our upcoming platform release (v11.1) hits the streets in Q4 2018, followed by another platform release in Q4 2019. PLATFORM RELEASE Interval:  Annually every twelve (12) months in December Who:  Entire customer base What:  Focus on production level security, stability, and performance defect fixes for all customers. Expectation:  Customer has chosen platform path and wants product stability without new enhancements. Support:  Three (3) years, patches for approved P1 defects, an...

"Table structure cannot read or update"  in the warehouse catalog error while updating a table structure while using Warehouse Catalog in MicroStrategy Developer  This issue could be due to the incorrect prefix.  To fix the issue. 1. Open the Warehouse Catalog. 2. Select the table and assign the correct Prefix update the structure. 3. Save and close the warehouse catalog.

Create your own Open source Agile boards http://scrumblr.ca/Srikanth