New Features in MicroStrategy Intelligence Server 9.3/Abhilash(NALGAN)

Configurable formatting for table of contents
Customization of Report service Document’s table of contents by formatting such as font properties, title alignment, indentation and borders, the report look and feel can be improved.

Dashboards enhancements

Display forms and sort on selector: The elements in the report can be sorted in a desired manner so that the user can choose a flexible sorting option from multiple forms, before building a report.

Drilling across templates: Drilling on one Grid/graph to simultaneous drilling can be done on another Grid/graph.

Export a single report in a dashboard: The user can choose to export the grid/graph on the dashboard instead of exporting the entire dashboard as a PDF/Microsoft excel.

Search Box selector: In this new style selector as we type in the search box for an element it shows the matching list of elements so the user can select among the displayed list of elements.

Filter Panel: This type of panel stack contains only selectors, which users interact with to filter the data displayed in a dashboard.

Widget support:
Network Visualization widget: This widget displays on web. It displays different colors/line between Map markers depending on Metric values.

Image Layout widget: Displays an image overlaid with colored areas or bubble markers. Displayed in web as well as be used on applications for Microstrategy Mobile for ipad.

Mash up widget: This widget, previously available through the MicroStrategy SDK, is now available out of the box to support its use in Visual Insight analyses and MicroStrategy Web.
Density maps with MicroStrategy Mobile and the Map widget : Designers can define the Map widget for MicroStrategy Mobile for iPhone and iPad to display shades of color to indicate the concentration of locations on the map.
The following widget enhancements can now be used on applications for MicroStrategy Mobile for Android

Micro charts widget: Consists of compact representations of data that allow analysts to quickly visualize trends in data.

Visual Insight

Enhanced mapping options: New map visualizations include Density Maps and Image Layouts. Additionally, maps can be created by using latitude and longitude as attribute forms of a single attribute.

New Visualization support: Visual Insight has been enhanced to include support for the following visualizations.

Network Visualization: Displays lines between map markers, which can have different line thickness or colors depending on metric values.

Density Map Visualization: Displays data on an interactive map as areas color-coded based on the population density of locations on the map.

Graph Matrix Visualization: Includes several area graphs that display current values, each with a corresponding line graph above to show forecasted values.

Image Layout Visualization: Displays an image overlaid with colored areas or bubble markers.

Graph Matrix Visualization: This visualization has been enhanced as follows:

  • New formatting options are available, such as applying banding and showing or hiding grid lines.
  • A new graph element shape, the tick, has been added, which can help users more easily distinguish different data points in graphs.
  • A matrix of scatter graphs can be displayed.

Combined Visualizations: Multiple visualizations can be displayed at the same time. We can insert multiple visualizations as well as insert and format a text field in the same panel. Additionally, an element selected on one visualization can filter data in other visualizations.

Use multiple Datasets in a Visual Insight dashboard: Two visualizations, which are sourced from different datasets, can be displayed side-by-side.

Multiple Visual Insight panels: You can add panels to a layout tab to layer data in an analysis, creating stacks of analytic layers on a single analysis page.

Multiple Visual Insight worksheets with distinct filters: You can insert multiple layouts in a Visual Insight analysis, and each layout can have its own set of filters, page-by, and visualizations.

Using actions in a visualization to update data in a separate visualization: You can filter, drill, or select data in a visualization to automatically update the data displayed in another visualization.
Derived metric support: Derived metrics can be created and used within Visual Insight. This provides capabilities such as shortcut metric options as well as user-friendly interfaces to create derived metrics.
Searching enhancements

  • You can search long element lists used in attribute element selectors.
  •  A new Search Box selector is available, which is ideal for long element lists. As you type in the Search Box, a list of elements matching the search criteria is presented and an element can be selected.

Migration from imported data to the main data warehouse: The migration of data for an analysis to go from using imported data to connecting to the main data warehouse has been simplified.


  • Themes including Light and Dark can be applied to quickly update the formatting of the whole Analysis.
  • The default theme preference can be set at the user level.

Exporting options: A single visualization as well as the current view of the whole analysis can be exported as an image. Additionally, individual grids and graphs can be exported to Excel or as a PDF.

Enhancements in Flash View Mode of an Analysis:

  • Support for auto-resizing to adjust the size based on the web browser window size.
  • Filter panel capabilities including expand, collapse, resize, element count, filter summary, and apply are available.

MicroStrategy Distribution Services

Dynamic recipients list: The Dynamic recipients list allows you to select the recipients of subscriptions and personalization through the use of MicroStrategy reports. This can be used in addition to the standard support of choosing Distribution Services contacts directly as the recipients of subscriptions and personalization.

MicroStrategy Transaction Services

Attribute element selections for transactions: Allows users to select the element of an attribute to submit changes to their data in a Transaction Services-enabled document.

Offline transactions: Allows iOS mobile users to submit transactions while offline. Transactions submitted while offline are put into a queue and processed automatically when a connection to the MicroStrategy Mobile Server is re-established.
Signature capture: You can provide their signature in a Transaction Services-enabled document using the Signature Capture input object control.
Format verification for transactions: Designers can specify the format in which users must enter data in a text field input object control. For example, users might be required to enter data in a phone number or zip code format.

MicroStrategy Intelligence Server

Intelligent Total calculations: The Total subtotal for all metrics is calculated based on the metric’s function, rather than always defaulting to a simple summation. In addition, totals for derived metrics can also be calculated from the base level data available in a report. This is particularly useful for derived metrics such as distinct counts and averages.

Parallel SQL Execution: Independent passes of a multi-pass SQL can be processed in parallel to improve overall reporting execution time. This new option is particularly useful for reports that source data from multiple sources, including reports that source data from both relational and MDX cube sources.

Communication encryption: Communications between MicroStrategy Desktop and MicroStrategy Intelligence Server are encrypted to provide enhanced security.

Health Center configuration: Configuration of Health Agents and Master Health Agents is fully integrated into the MicroStrategy Configuration Wizard.

Intelligence Server SSL configuration:

  • The Configuration Wizard supports configuration of SSL for Intelligence Server.
  • The MicroStrategy Service Manager can be used to update the SSL port number.
  • Support for Open Office Calc: Output exported to Microsoft Excel 2007 or higher can be opened with Open Office Calc.

Currency internationalization: The International Currency Symbol ¤ is translated into an actual currency symbol based on the user’s choice of language for Number and Date formatting.

Enhanced History List storage and retrieval with database and file support: You can now store History List messages as a combination of a file on your Intelligence Server machine and a repository on a database. By storing History List messages using the combination of these techniques, the History List system can achieve faster response times for both the creation and retrieval of History List messages.

New database platform support for MicroStrategy 9.3:

  • MicroStrategy supports all of the major distributions of Hadoop through the use of the Hive infrastructure.
  • Action Vectorwise 1.6 and 2.0
  • Aster Data cluster 4.6.x
  • Composite 6.1
  • Enterprise DB Postgres Plus Advanced Server 9 and 9.1
  • Exasolution 4.0
  • Greenplum 4.2
  • IBM DB2 UDB for z/OS 10 (DB2 UDB V9 for z/OS)
  • Infobright 4.0.x
  • Informatica Data Services 9.1
  • Kognitio WX 7.2
  • Microsoft SQL Server 2008 SP1/SP2/SP3 and 2008 R2/R2 SP1
  • Microsoft SQL Server 2012
  • ParAccel 3.5
  • PostgreSQL 9.1
  • SAP BW 7.3
  • SAP HANA 1.0 SP2
  • Sybase Adaptive Server 15.7
  • Sybase IQ 15.3 and 15.4
  • Teradata 14.0
  • Vertica 5.1 and 6.0
  • MicroStrategy ODBC drivers version 6.1, including two new drivers: and Microsoft SQL Server.

MDX cube sources integration
Performance: Performance improvements have been implemented for reporting on large Microsoft Analysis Services data sources.

Support for dynamic metric aliases with SAP text variables: Metric aliases can be automatically populated with the results of an SAP text variable. If the name of an SAP measure contains an SAP text variable, MicroStrategy replaces that text variable with its resolved value and includes the value in the name of the metric.

Data mining support: Creating training and predictive metrics is supported when reporting on MDX cube sources. You can create training metric using models defined within MicroStrategy Data Mining Services, or you can create a predictive metric by applying PMML from an external source.

(26 Posts)