MicroStrategy ONE

What's New in MicroStrategy ONE

MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster.

Below are the new features exclusive to MicroStrategy ONE and its subsequent updates. For a smooth upgrade, be sure to review the important version-specific information regarding changes in the release that could impact functionality and performance. For customers with an upgrade gap of more than one version, the Readme for all intermediate versions can be found in Product Documentation.

Preview features are early versions of features and are not to be used in a production environment as the core behavior remain subject to change between preview and GA. By selecting to expose preview features in MicroStrategy Workstation, you can access these features and use them as you would any other dashboard functionality. The official versions of preview features are included in subsequent releases. Any preview features on this page are marked with Preview Feature.

You must perform a metadata update when upgrading from a pre-2021 release to MicroStrategy ONE or MicroStrategy 2021.

Use the buttons below to view what's new in the MicroStrategy ONE and MicroStrategy 2021 monthly and platform releases. All MicroStrategy ONE and MicroStrategy 2021 updates include the features from the 2021 Platform Release.

Features that are supported in MicroStrategy Cloud environments are marked with a cloud icon.

MicroStrategy ONE (December 2024)

MicroStrategy Library

MicroStrategy AI

  • Forget learnings from previous chat sessions, whether you are in active chat session or not.

  • You can allow Auto Answers and bots to use the most recent time frame in the data when a query does not specify a time period. This ensures that queries use timely and relevant data. For an example of this feature, see Example: Automatically apply a time filter when a query does not specify a time period. To allow this, enable the Apply Time Filter When Time Is Not Specified setting:

  • A single comprehensive answer is provided for open-ended questions in bots, Auto Answers, and Auto Dashboards. To see additional data, follow up on the response. For details and examples, see Ask Open-Ended Questions.

  • Configure your own Azure-supported OpenAI endpoint to use in your MicroStrategy environments. Contact MicroStrategy to assist with the configuration and note the following details and values that are needed for your configuration:

    • Your Service Principal must have the Cognitive Service User privilege at the subscription level.

    • Your DSI

    • endpoint

    • clientID

    • clientSecret

    • tenantID

Dashboards

MicroStrategy Workstation

Dashboards

  • You can enable the display of object descriptions as tooltips in chapter filters and selectors. Enable or disable it using the Dashboard Properties dialog box. For an example, see Filter panel.

  • You can enable incremental fetch for custom visualizations that include incremental fetch in their code. Enable it using the More Options dialog box for the custom visualization.

Administration

  • You can search "anything by everything" using the new global search in Workstation. This search engine provides a fast, powerful global search, not limited to one object type. Advanced search functions such as wildcards and filtering the search results are supported.

  • You can save your search criteria as a search object, so you can re-use and edit it whenever you need.

  • Application and content group enhancements:

    • You can enable Pre-cache for each content group in the application. This means that when a user logs into the application in iOS Mobile for the first time, all the dashboards in the content group are downloaded for offline use.

      • Each dashboard is pre-cached with the last closed view or the last saved view, depending on how the View in Library property is set in the Dashboard Properties Dialog Box.

      • The targets of any links in the dashboards are also downloaded, so users can smoothly transition between dashboards in offline mode.

      • Bookmarks, links defined with URLs, and dashboards with prompted datasets are not pre-cached, although you can manually pre-cache bookmarks so they are available for offline use. 

      • When a dashboard is available for offline use, either through pre-caching or downloading, the Available Offline indicator (a green check) displays on its cover. The indicator turns orange when the cache is not up to date or is incomplete. You should download the dashboard again before switching to offline mode.

      • For more details, see the Download and Pre-Cache Dashboards for Offline Use.

        • Before enabling pre-caching, clear any dashboard caches on the server that were generated before the upgrade to MicroStrategy ONE (December 2024).

    • You can disable some interactivity with visualizations in your application. You can disable the Maximize Visualization icon and/or the Show Data option on the menu icon.

    • You can customize the notification email that users receive when a subscription is created in Library. You can also select the color of the text, the content area background, and the email background for all emails. For instructions, see Configure Notification Emails When Sharing Content in Library.

  • Providing the MicroStrategy Library URL when you create an environment is easier. "MicroStrategyLibrary" is automatically added to the end of the URL.

  • Project descriptions display when you create an environment or edit the connected projects. Hover over a project to view the full description.

  • You can enable and disable auto-connect without disconnecting or reconnecting an environment.

  • Users with read-only access to users, can choose Edit in the user right-click menu to view user details but cannot make any changes.

  • A Date Created filter was added to Users and Groups.

  • Export user groups, contacts, and contact groups to CSV.

  • Administrators can assign security filters to users and user groups regardless of project access.

  • View dependent subscriptions for your dashboards, reports, schedules, and events.

  • Refresh multiple cubes on the caches monitor and datasets page.

  • Dataset and cube properties display its connection type.

  • A Last Refreshed column was added to the caches monitor table.

  • Use the Maximum memory consumption per cube publishing (MB) setting to define how much memory a user group can use when publishing a cube.

  • Preview and edit tables for a streamlined schema update process.

  • Add dynamic attributes and metrics to subscription email subjects and body text and edit subscription content file names with static or dynamic text.

  • The project-level setting, Cache encryption level on disk, now supports only AES with 256 bit key or None. If you upgrade your environment from an older version with Low (Simple) or High (AES with 128 bit key) values, they will not be updated. However, if you update this setting to the supported values, you can not revert it to the unsupported values.

  • Use the project-level setting, Permissive object handling for users without execute access, to automatically exclude objects that users lack execute permissions from dashboards and reports. This setting ensures dashboards run without errors by removing restricted objects. The default value is off for existing projects and on for new projects.

  • Retrieve database credentials for HashiCorp and AWS Secrets Manager vault systems and create database logins based on vault secrets.

  • Add system prompt mapping and nested groups to your OIDC authentication.

  • Configure Workstation redirect URIs when setting up OIDC authentication.

MicroStrategy HyperIntelligence

  • When you are viewing a HyperIntelligence card that is integrated with an Auto Bot, the bot includes the card's context in your query, using that context to filter the response.

    For example, you are viewing a card with information about a specific product, including which store has the most sales for the product. When you ask the bot what other products from this store have the most sales, the bot uses the store information from the card as the filter for the response. The card's context also affects the bot's suggested questions.

  • Support for OS 15 and SDK 15 for HyperMobile on Android.

R Integration Pack

The R Integration Pack is no longer supported. See KB487053 for more information.

MicroStrategy Library Mobile

Android

Support for OS 15 and SDK 15.

MicroStrategy Mobile

Android

Support for OS 15 and SDK 15.

MicroStrategy Office

Legacy office is no longer supported. See KB487052 for more information.

Excel

Import grids that use outline mode while preserving formatting.

Platform Analytics

Enhanced metadata handling by using GUIDs for unique identification, ensuring seamless transitions during upgrades for single-environment customers.

If you are using multi-tenant Platform Analytics or multiple environments connected to the same Platform Analytics, you should ensure the GUID is different for each environment's metadata before upgrading to MicroStrategy ONE (December 2024).

For more information to check your metadata GUID, see KB487044. If your metadata GUIDs are not unique across all your environments, contact MicroStrategy Technical Support.

MicroStrategy Visualization SDK

You can add incremental fetch to custom visualizations in the SDK, and enable it in the dashboard.

MicroStrategy Library Mobile SDK

iOS

When you customize MicroStrategy Library Mobile SDK for iOS to develop and compile your application, you must have an Apple Mac with Sonoma 14.7 and above that uses an Intel x86 or Apple M1/M2 chip machine and runs Xcode 16.1 with Apple iOS SDK 18.1.

MicroStrategy Mobile SDK

iOS

When you customize MicroStrategy Library Mobile SDK for iOS to develop and compile your application, you must have an Apple Mac with Sonoma 14.7 and above that uses an Intel x86 or Apple M1/M2 chip machine and runs Xcode 16.1 with Apple iOS SDK 18.1.

MicroStrategy Packages for Python (mstrio-py)

New Features

  • Added list_fences method and Fence class in mstrio.server.fence subpackage to allow management of Fences.

  • Added list_cluster_startup_membership and update_cluster_startup_membership methods to Cluster class in mstrio.server.cluster to allow management of cluster startup membership.

  • Added arguments add_to_cluster_startup and remove_from_cluster_startup to add_node and remove_node methods in Cluster class in mstrio.server.cluster to allow adding and removing nodes from cluster startup.

  • Added port, status, load, projects and default attributes to Node class in mstrio.server.node subpackage.

  • Added get_status_on_node method to Project in mstrio.server.project class to allow checking the status of a project on a specific node.

  • Added lock, unlock methods and lock_status property to the Project class in mstrio.server.project to allow managing project locks.

Minor Changes

  • Added include_subfolders flag to list_folders method of mstrio.object_management.folder package to allow getting all folders in the specified project or configuration-level folders.

  • Added parent_folder argument to list_folders method of mstrio.object_management.folder package to allow getting all folders from a specified parent folder only.

MicroStrategy Cloud Platform

Upgraded to Kubernetes version 1.30.

Intelligence Server

  • Support seamless Intelligence Server session failover to ensure uninterrupted dashboard and Bot consumption and authoring by transparently backing up and restoring user sessions during Intelligence Server scaling or unexpected termination in containerized environments.

  • AES-256 encryption is on by default to ensure your data is protected with the most secure encryption algorithms available.

Data Sources

See Platform Certifications for information about the latest supported and certified configurations.

MicroStrategy ONE (October 2024)

MicroStrategy Cloud Platform

Add support for GCP deployments in Los Angles and Tokyo regions.

MicroStrategy ONE (September 2024)

MicroStrategy Library

MicroStrategy AI

  • Bots, Auto Answers, and Auto Dashboard have been upgraded from GPT-3.5 and GPT-4 usage to GPT-4o. By taking advantage of faster speed of GPT4o together our internal optimization of performance, MicroStrategy's platform is now two times faster than MicroStrategy ONE (June 2024).

  • Deliver natural language summaries of dashboard pages or specific visualizations using auto narratives. Tailor the narrative format, highlight key trends with customizable color-coding, and dynamically update insights based on user interactions and filter conditions.

  • Define custom instructions in the dashboard editor for Auto Answers responses.

  • Bots and Auto Answers recognize and answer open-ended business questions.

  • Bots, Auto Answers, and Auto Dashboard responses provide more descriptive statistics.

  • Leverage advanced mode for more in-depth data preparation, enabling you to review, correct, and manipulate datasets with greater precision.

  • Support for multiple datasets in Bots as well as support for report objects as a valid dataset format.

  • Download learnings created or used inside Bots or Auto Answers in a .csv file format.

  • Manually create AI indexes and view a new Partially indexed status in the dataset.

  • The custom instruction character limit increased to 2500 characters.

Dashboards

MicroStrategy Workstation

MicroStrategy AI

Deliver natural language summaries of dashboard pages or specific visualizations using auto narratives. Tailor the narrative format, highlight key trends with customizable color-coding, and dynamically update insights based on user interactions and filter conditions.

Dashboards

Administration

  • Retrieve database credentials from a secret vault system, such as CyberArk, by creating, editing, and deleting vault connections. Create database logins based on the vault secret.

  • Multiple OIDC and SAML configurations are supported. This support allows different applications to utilize SAML with various identity providers (IDPs) or OIDC with different identity access management systems (IAMs).

  • Manage ACLs for user group child objects.

  • A new Enable Dynamic Working Set Limit server-level setting that allows the Intelligence server to automatically increase or decrease the working set limit based on user settings and available resources in the system.

  • A new Unload cube caches not used for (minutes) server-level setting that allows a user to release the cube cache from memory if it's not accessed by the specified amount of time.

  • New Show delivery address for subscription results for Administrator and Show delivery address for subscription results for Owner project-level settings that allow administrators or subscription owners to view the plain email address. The delivery address is hidden by default for security purposes.

  • Two new object types are supported for migration packages: Scripts for object packages and Runtime for administration packages.

  • Enhanced timezones to consider a user’s preferred timezone when resolving dynamic dates or datetimes in filters or value prompts.

  • History list enhancements:

    • Mark history list messages as read or unread.

    • A new Delete History button that lets users purge all currently filtered messages.

    • New Source and Content ID columns and a reordering of existing columns.

    • Tooltips appear when cell content is too long.

    • Updated differentiation between dashboards, documents, reports, OLAP cubes, and MTDI cubes, along with their respective icons.

  • Create multiple connections to one environment, rename an environment, and create a new project while connecting to an environment.

  • Change the Library Home page display name.

  • Application and content group enhancements:

    • New Location and Version columns.

    • Access create content groups and applications dialog from the Navigation pane.

    • Unified right-click menu.

  • Caches monitor enhancements:

    • Expanded filter options and improved search functionality.

    • Perform a single cube refresh for OLAP and MTDI cubes.

    • A new Send to History List option in datasets.

  • Updated change journal columns and filters.

  • Added change journal to the following properties dialogs:

    • Monitor > Triggers > Schedules > Properties

    • Monitor > Triggers > Events > Properties

    • Environment properties > Subscription properties > Delivery Type

    • Environment properties > Subscription properties > Delivery Device

  • Added change journal to the following right-click menus:

    All Users, Applications, Bots, Cards, Content Groups, Dashboards, Data Sources, Datasets, Documents, Objects, Planned Tasks, Reports, Scripts, Subscriptions, and User Groups.

  • Integrate OIDC support with Google.

MicroStrategy Library Mobile

iOS

  • Support for iOS 18.

  • Dashboards use the default PDF export options set at the dashboard level in Library or Workstation.

  • Create links in visualizations and images or text to a dashboard in a different project while maintaining filter selections.

Android

  • Dashboards use the default PDF export options set at the dashboard level in Library or Workstation.

  • Create links in visualizations and images or text to a dashboard in a different project while maintaining filter selections.

MicroStrategy Mobile

iOS

Support for iOS 18.

Federated Analytics

MicroStrategy for Tableau

Support for Tableau Web Data Connector 3.0.

MicroStrategy for Office

Excel Add-in

PowerPoint Add-in

Teams App

Interact with Bots in private messages, group chats, and Teams channels.

Platform Analytics

  • Gain visibility into the adoption and performance of auto narratives across your dashboards with auto narratives insights. Track usage metrics, execution success rates, and detailed user interactions to ensure optimal narrative performance and uncover opportunities for improvement.

  • Auto learning insights enables administrators to access, review, and download user-generated learnings from across the environment. This powerful tool enables the identification and promotion of valuable insights as knowledge assets, extending their benefits to entire teams or the entire organization.

  • Enable more performant time-series analysis. Evaluate adoption or usage month over month, quarter over quarter, or year over year, without waiting hours for a report to aggregate the transactional data.

  • Enhanced the Status attribute in the Platform Analytics Project.

  • Added a Job Canceler attribute that displays the MicroStrategy User who cancels a job.

MicroStrategy Library Mobile SDK

iOS

Hide the back button on the navigation bar so users can navigate through dashboards using customized links that you place on the screen.

MicroStrategy Packages for Python (mstrio-py)

A new mstrio.object_management.migration subpackage was added as an official release. This subpackage replaces the old module for object migrations introduced in 2021 Update 5 as a Preview Feature and is a breaking change.

  • Added list_migrations method, list_migration_possible_content method, and Migration class to mstrio.object_management.migration.migration subpackage to allow management of migrations

  • Added PackageConfig, PackageContentInfo, PackageType, PackageSettings, PackageStatus, and more classes to mstrio.object_management.migration.package subpackage to allow management of migration packages.

  • Added the list_bots method and Bot class in the mstrio.project_objects.bots subpackage to allow management of Bots

  • Added the list_content_groups method and ContentGroup class in the mstrio.project_objects.content_group subpackage to allow management of content groups.

  • Added the list_applications method and Application class in the mstrio.project_objects.applications subpackage to allow management of applications.

  • Added the StorageService class for the Storage service configuration of an environment.

  • Added the storage_service property, fetch_storage_service, and update_storage_service methods to the Environment class to manage the environment's Storage service configuration.

  • This is the official release of the Migration class and its methods, which introduces some breaking changes compared to the "Preview" state.

  • Added the last_update_time property to Cube based classes.

Intelligence Server

  • Improve server stability and prevent memory outages by swapping the least recently used server messages to disk in low memory scenarios.

  • Improvements in memory management may require additional disk space for situations where the client session timeout is more than two hours. The default client session timeout setting and lower values are not affected.

  • An opt-in enhancement to the ALTER USER Command Manager script is available. See KB486957 for more information.

Data Sources

See Platform Certifications for information about the latest supported and certified configurations.

  • Certified gateway versions

    • IBM Db2 for z/OS 13

  • Out-of-the-box driver updates

    Ensure security and reliability by supporting OpenSSL 3.x and other security updates for the following drivers:

    • Windows Driver Manager Files

    • Hive ODBC driver

    • IBM Db2 ODBC driver

    • Spark JDBC driver

    • Hive JDBC driver

    • Impala JDBC driver

MicroStrategy ONE (June 2024)

MicroStrategy is upgrading to Tomcat 10.1.x and JBoss 8 along with Spring 6. See 2024 Platform Certification Changes for more information.

MicroStrategy Library

MicroStrategy AI

  • Enhanced Auto AI Visualizations: Dynamically select diverse visualization types based on contextual analysis, prioritizing user demand, keywords, and data components for streamlined decision-making.

  • Auto Answers and Bots now support Bubble Charts, Horizontal Bar Charts, Vertical Clustered Bar Charts, and Insights+ Line Charts with Break By. This support enables users to visualize complex data relationships, rankings, comparisons, and trends more effectively.

  • Cognitive Element Search enhances MicroStrategy AI accuracy using advanced index and semantic search capabilities to intelligently interpret user queries that contain element names, or element names with spelling mistakes, abbreviations, or synonyms. Business users can use this support for a wide range of query complexities and benefit from more meaningful and engaging chat-based analytic experiences.

  • Empower Auto to learn and personalize responses. Auto adapts based on user feedback and clarifications, storing what it learns at an individual user level. This personalized learning improves future interactions and ensure that responses align with each user's preferences.

    • Improve Auto responses with feedback. Users can give feedback with thumbs-down and comments, and administrators can monitor performance and user interactions through the Auto Adoption Dashboard.

    • Improve the user experience with Smart Suggestions. When Auto detects an ambiguous query, it provides a default answer and suggests alternative options to help users clarify their queries and get more accurate results.

  • Knowledge assets now require a user privilege.

  • Use annotations in AI Interpretation and Execution for more information on how knowledge assets and user-level learnings were applied to answer a question.

  • Enhance control levels over what information gets to AI and choose attribute forms for analysis and answer display.

Dashboards

  • Parameters can be applied to dataset filters, therefore increasing performance and reducing load on the warehouse. The dataset query is executed after users make choices on the Filter panel or within in-canvas selectors.

  • Users have more control over chapter filters. Users can specify the dataset from which all the attribute elements in the filter are sourced from.

  • Introducing enhanced experiences for viewing wide grids by adding options to pin and freeze columns. Users can now freeze to the left or pin particular column(s) of interest to the left or right for better data analysis and comparison. Authors can define certain columns to be pinned or frozen by default.

  • An enhanced Fit To Container mode now offers improved grid space utilization. Users can set minimum and maximum column widths, specify fixed widths for specific columns (such as the year), and dynamically adjust other columns (such as the address) for optimal width distribution.

  • A lock ratio setting was added to enhance dashboard zoom behavior. Use lock ratio to choose a pre-defined or customized ratio so the dashboard can expand or contract according to zoom changes while maintaining component ratios.

  • Export to Excel and PDF enhancements:

    • Seamlessly choose chapters, pages and visualizations to be included in export.

    • Choose option to export all objects from a page onto a single Excel sheet.

    • Export includes visualizations imported as data and other non-visualization objects such as images and text boxes.

    • Export supports free-form dashboard layout.

    • Select multiple pages or chapters when exporting.

Administration

  • MicroStrategy delivered on its 2024 roadmap and updated MicroStrategy Library and MicroStrategy Web to the Jakarta EE 10 platform. This update removes support for Tomcat 8.x, Tomcat 9.x, and JBoss 7.x and adds support for Tomcat 10.1.x and JBoss 8.x. For more information, see Spring Security SAML Provider 6.2.3 Upgrade. The following authentication and configurations are also affected:

    • Spring Security SAML Customization

    • Logging into Library using Kerberos authentication with Tomcat 10 is affected. See KB486775 for more information.

    • Customizations made to MicroStrategy's bundled Tomcat, specifically to enable HTTPS, require changes to accommodate Tomcat 9, versus Tomcat 10 syntax. See KB486843 for more information.

  • Use Cognitive Search, a centralized search service, that adds support when users search using synonyms, typos, abbreviations, natural language, and multilingual search queries.

MicroStrategy Workstation

MicroStrategy AI

Dashboards

Administration

  • Due to the end of the six-month notice for decommissioning Workstation Mac, Intelligence server will no longer accept connections from Workstation Mac. Users are advised to switch to Workstation on Windows for continued access and support.

  • Create Freeform SQL Intelligent cubes.

  • Create Freeform SQL Incremental Refresh Reports.

  • Increase the scalability of the history list solution and migrate history list data storage to hybrid mode.

  • Perform bulk actions on multiple users within the User and User Groups blades. This allows Administrators to efficiently manage user-related tasks in a streamlined manner. Select multiple users at once and perform actions such as updating permissions and modifying settings, saving time and effort in user management. Additionally, you can configure security access for user groups, view dependent subscriptions for users, and export users.

  • Search recursively by name and ID in the Project blade. You can also filter by name, owner, date created, date modified, ID, location, and description in all Analysis blades.

  • Detailed execution results for subscriptions, enabling Administrators and Power Users to easily identify recipients and the timing of content delivery from subscription results. This enhancement applies to all email, file, and mobile subscriptions.

  • Administrators have the ability to set up password expiration rules for users during creation or editing, in line with customer internal security policies. Additionally, to streamline user maintenance processes, we have introduced the option to delete users along with their corresponding user profile folders.

  • An HTML/JavaScript Content filter was added to the Content Inspector.

  • A lock ratio setting was added to enhance dashboard zoom behavior. Use lock ratio to choose a pre-defined or customized ratio so the dashboard can expand or contract according to zoom changes while maintaining component ratios.

  • The Maximum memory consumption per job (MB) setting applies to subscription job when subscription job level governing is turned on. Memory used by subscription jobs cannot exceed 30% of total memory by default. If the limit is reached, subscription requests will be postponed and subscription delivery may be delayed.

  • The server-level setting, Maximum memory consumption for Intelligent Cubes (%), allows administrators to set the percentage of system RAM that Intelligent Cubes are allowed to consume. This setting is only exposed in the container environment.

  • The server-level setting, Maximum RAM for Working Set Cache %, allows administrators to set the maximum RAM for he working set cache in terms of the percentage of total memory in a container environment.

  • The project-level setting, Maximum memory consumption for Excel files (MB), is exposed to allow administrators to limit the memory consumption for Excel files generated from MicroStrategy Web. The default value is Use inherited value (-1). This means that when you upgrade to the latest build, you won't be affected by this setting and will continue to use the value set at the server level.

  • Use Cognitive Search, a centralized search service, that adds support when users search using synonyms, typos, abbreviations, natural language, and multilingual search queries.

MicroStrategy HyperIntelligence

Enhance your Hyper insights by integrating Bots with selected cards for deeper, multi-layered analysis. Leverage the power of Hyper and AI seamlessly, whether you're working in a browser or on your mobile device.

MicroStrategy Library Mobile

  • Bots include a thumbs-down icon to collect user feedback, smart alternative suggestions, and improved response quality and accuracy through learning from user feedback.

  • Improved capability to view wide grids on mobile devices by freezing a column or set of columns to the left while scrolling through the rest of the grid for better data analysis and comparison.

  • Improved dashboard performance with newly introduced dataset level filters with parameters by reducing the query result set.

  • The Spring Security SAML provider was updated to v6.2.3 and includes the following affected authentication and configuration:

MicroStrategy for Office

Excel Add-in

PowerPoint Add-in

  • Track imported content with an improved side panel that groups objects based on their PowerPoint slide placement.

Teams App

Platform Analytics

MicroStrategy Library SDK

MicroStrategy Library Mobile SDK

The MicroStrategy Library Mobile SDK for Android is certified to work with Android 14 (API level 34). When you customize MicroStrategy Library Mobile SDK for Android, you must have Android SDK 34 to develop and compile your application. Android Studio Iguana and newer is supported.

MicroStrategy Mobile SDK

The MicroStrategy Mobile SDK for Android is certified to work with Android 14 (API level 34). When you customize MicroStrategy Mobile SDK for Android, you must have Android SDK 34 to develop and compile your application. Android Studio Iguana and newer is supported.

Intelligence Server

MicroStrategy REST APIs

The unified Bot API is a streamlined interface designed to seamlessly integrate MicroStrategy AI into virtually any enterprise application. Key features include:

  • Simplified Integration: Users no longer need to maintain individual Bot instances.

  • Automatic Bot Selection: Users no longer need to specify which Bot to send your data questions to. The API leverages advanced semantic search to automatically identify and engage the appropriate Bot.

  • Visualization Export: A new API endpoint allows users to export static visualization images from data answers. This enhances the end-user experience by providing a more visually appealing data representation.

MicroStrategy Packages for Python (mstrio-py)

New Features

  • Automate the refresh (full or incremental) and deletion of OLAP and MTDI cubes. This enhancement is particularly valuable for Administrators, as it streamlines the process of managing cubes. To automate the refresh of these cubes without any interaction and creating a Job, we have added the refresh() method to the OlapCube and SuperCube classes. To assist users, we have provided useful workflows for managing cubes within Python scripts.

  • Added support for providing a folder path, instead of a folder ID, to methods within the Folder class, as well as quick_search, full_search, and all methods inheriting from them that accept a folder ID argument.

  • Added include_subfolders flag to the get_contents method of Folder class to allow getting the contents of the children of the specified folder recursively.

  • Added the sql property to the Report class, allowing the retrieval of the SQL view of a report without executing it.

  • Added the IncrementalRefreshReport class to the mstrio.object_management.incremental_refresh_report package to allow the management of Incremental Refresh Reports.

  • Added the list_incremental_refresh_reports method to allow the listing of Incremental Refresh Reports in a project.

  • Added the quick_search_by_id() function to mstrio.object_management.search_operations to allow searching for objects by object and project ID.

  • Added the send_email() function in mstrio.distribution_services.email to allow the sending of emails.

  • Added the execute_query() method to the DatasourceInstance class to allow the execution of SQL queries.

  • Added the status property to the Subscription class to allow the checking of a subscription status.

  • Added support for answering prompts in the to_datasource() method of the Report class, along with a Prompt class in mstrio.project_objects.prompts to support prompts.

  • Added support for password_auto_expire and password_expiration_frequency fields to the User class.

  • Added support for page-by in the Report class.

  • Added support for VLDB properties in the Report class.

Minor Changes

  • Added a warning message to the OlapCube and SuperCube classes that appears when the provided ID belongs to different type of Cube.

  • Updated PageSize Enum values to allow proper subscription initialization.

  • Added support for both name and display_name in the VLDB settings provided by ModelVldbMixin.

  • Added a vldb_settings property in the VldbMixin class that stores VLDB settings in dict with setting names as keys.

MicroStrategy Cloud Platform

  • MicroStrategy Backup and Restore supports Storage Service

  • Support for PostgreSQL 14 and 16

  • Support for Oracle 21c

  • Support for SQL Server 2022

Data Sources

See Platform Certifications for information about the latest supported and certified configurations.

  • Certified gateway versions

    • Teradata 20.x

    • Greenplum 7.x

    • Informix 14.10

    • Yellowbrick

  • Out-of-the-box driver updates

    Ensure security and reliability by other security updates and fixing bugs for the following drivers:

    • Oracle ODBC driver

    • Spark JDBC driver

    • Exasol ODBC driver

    • Google BigQuery JDBC driver

    • Salesforce ODBC and JDBC drivers

    • Driver Manager files

Privileges

See Privileges by License Type for information about license types and associated privileges.

The following existing privileges were removed from the Server - Reporter license and added to the MicroStrategy AI license:

  • Create and Edit AI Bots

  • Run AI Bots

  • Use Auto Assistant and ML Visualizations

The Create and Configure Knowledge Assets privilege has been added to the MicroStrategy AI license.

MicroStrategy ONE (March 2024)

Dossiers have been renamed to dashboards to simplify the user experience across enterprise systems and follow the best naming convention practices in the BI industry. You may notice that existing folders are named "My Dossiers" and "My Shared Dossiers", while new user profile folders are named "My Dashboards" and "My Shared Dashboards". For more information, see KB486427: Rename "My Dossiers" and "My Shared Dossiers" to "My Dashboards" and "My Shared Dashboards" for Each User Account.

MicroStrategy is transitioning from Java 11 to Java 17 in this release. MicroStrategy ONE cloud hosted environments, or MicroStrategy on-premise environments that use the bundled Tomcat version, will have the necessary changes automatically applied during their upgrade. MicroStrategy on-premise environments with their own web application server must upgrade the JDK to JDK17. MicroStrategy Web ASP environments should not see any impact. Customizations written using Java 11 versions should continue to work with Java 17. See Platform Certifications for more information.

MicroStrategy introduces granular control over HTML and JavaScript execution to enhance security. If HTML and scripts were globally allowed before upgrading, they are now paused by default after upgrading to MicroStrategy ONE (March 2024). The update activates granular settings and requires you to review and authorize HTML and script usage individually. MicroStrategy encourages you to invalidate all caches and use the inspector tool available in Workstation to selectively enable content in each dashboard, document, and report. This proactive measure ensures a safer environment by minimizing unwanted script execution while maintaining functionality, where trusted. If you are upgrading to MicroStrategy ONE from a previous version, see KB486433: HTML Content Settings When Upgrading to MicroStrategy One (March 2024) or Later from Previous Versions. If you are using the Content Inspector tool with certified objects, see KB486729: Use Content Inspector with Certified Objects.

MicroStrategy Library

MicroStrategy AI

  • Auto Answers and Bots can answer compound multi-faceted questions that allow deeper, contextually rich insights drawn from multiple data points within the same query.
  • Auto enables dashboard and Bot owners to boost chat experiences by allowing owners to upload knowledge assets such as business glossaries, acronyms, and synonyms. Knowledge assets ensure business users receive more accurate data answers.
  • Auto Answers adds support for queries across multiple in-memory datasets within a single dashboard, including reports, subset reports, and cubes. This enhancement enables you to seamlessly integrate and interrogate data across different datasets for richer, more informed insights.
  • Use AI Interpretation and Execution for a deeper understanding into how AI interprets and executes its queries, which enhances transparency and insight in data exploration. Using specific information based on user privileges, power users gain access to robust tools for efficient troubleshooting and validation.
  • The snapshot panel adds new options to rename a snapshot title, ask again, and clear all snapshots.
  • When creating a Bot, right-click an object in a dataset to rename it or configure a number format.
  • Format a visualization filter or selector to apply to Auto Answers and Auto Dashboard. Auto Answers responses are based on the selector content and visualizations generated using Auto Dashboard are automatically filtered.
  • When creating a Bot, add up to three topics related to the dataset used in the Bot. Topic summaries that are retrieved during consumption help onboard the Bot consumer and inspire them with insights the Bot can provide. The Ask About panel provides a closer look at dataset objects to support in depth questions.

Dashboards

Administration

MicroStrategy Workstation

Dashboards

Administration

MicroStrategy Library Mobile

iOS

Android

MicroStrategy Web

Restrict multiple sessions from multiple devices.

MicroStrategy for Office

MicroStrategy Library Mobile SDK

The MicroStrategy Library Mobile SDK for Android is certified to work with Android 14 (API level 34). When you customize MicroStrategy Library Mobile SDK for Android, you must have Android SDK 34 to develop and compile your application. Android Studio Giraffe and newer is supported.

MicroStrategy Mobile SDK

The MicroStrategy Mobile SDK for Android is certified to work with Android 14 (API level 34). When you customize MicroStrategy Mobile SDK for Android, you must have Android SDK 34 to develop and compile your application. Android Studio Giraffe and newer is supported.

MicroStrategy REST APIs

MicroStrategy Packages for Python (mstrio-py)

New Features

  • Added delete_object_cache() and delete_element_cache() methods to the Project class to allow the deletion of object and element caches.

  • Added an optional show_description argument to ProjectSettings.list_caching_properties() to show descriptions for each setting.

  • Added delete_server_object_cache() and delete_server_element_cache() methods to the Environment class to allow the deletion of object and element caches from all projects.

  • Added a MobileSubscription class in the mstrio.distribution_services.subscription package to allow management of the new subscription type.

  • Added the following new bulk methods to the Translation class: to_json_from_list, add_translations_from_json, to_database_from_list, add_translations_from_database, to_dataframe_from_list, and add_translations_from_dataframe.

  • Updated the to_csv_from_list and add_translations_from_csv older translation methods with the functionality present in the newer bulk methods for json, databases and dataframes.

  • Added support for the comments field in MicroStrategy objects to view and edit their long descriptions.

  • Added the EmbeddedConnection class to allow access to embedded connection templates in DatasourceInstance.

  • Added support for Python 3.12.

Minor Changes

  • Updated the script template for data source scripts.

  • The enableHtmlContentInDossier server setting is now read-only for environments. This setting cannot be changed using mstrio-py since it is superseded by allowHtmlContent.

Deprecated

The mstrio.project_objects.dossier module is superseded by mstrio.project_objects.dashboard and will be removed in the future, after a one year deprecation period

Removed

The MicroStrategy for Jupyter Extension is no longer developed and supported and has been removed from the mstrio-py package in this release. You can still use the mstrio-py library and all its current and upcoming features.

MicroStrategy for RStudio and mstrio for R are no longer supported and developed and have been archived. You can still use the last available version.

MicroStrategy R Integration Pack

The R Integration Pack is in maintenance. No new features are planned. Only critical security updates will be provided.

Intelligence Server

Restrict users from logging in to MicroStrategy from multiple devices.

MicroStrategy Modeling Service

Set the timeout value for requests sent from the MicroStrategy Modeling service to the Intelligence server using the modelservice.iserver.requestTimeout property in modelservice.conf.

Data Sources

See Platform Certifications for information about the latest supported and certified configurations.

  • Certified gateway versions

    • PostgreSQL 16

    • Oracle 23c

    • Impala 4.x

    • Exasol 8.x

    • MongoDB 7

  • Out-of-the-box driver updates

    Ensure security and reliability by supporting OpenSSL 3.x and other security updates for the following drivers:

    • Impala ODBC driver

    • Hive JDBC driver

    • SparkSQL ODBC driver

    • Teradata ODBC driver

    • Redshift JDBC driver

    • Snowflake ODBC driver

    • Google BigQuery JDBC driver

    • Native PostgreSQL ODBC driver

    • SQL Server ODBC driver

MicroStrategy ONE (February 2024)

MicroStrategy Packages for Python (mstrio-py)

The MicroStrategy for Jupyter extension will no longer be developed and supported and will be removed from the mstrio-py package starting in MicroStrategy ONE (March 2024). You can still use the mstrio-py library and all its current and upcoming features.

MicroStrategy ONE (January 2024)

MicroStrategy Library

Improvements to Auto Answers time-related questions including time level transformations. The update distinguishes between Month and Month of Year and between Quarter and Quarter of Year.

MicroStrategy ONE - Update 12 (December 2023)

MicroStrategy Library

MicroStrategy AI

  • Create and customize a stand-alone Bot for your organization. Customize the bot's appearance, custom instructions, data settings, and other general settings.
  • Use Bots to gather insight on a selected dataset, save your favorite responses using Snapshots, embed a bot to a web page, and share your bot with other users.
  • Auto Answers improvements:
    • Improved response times and accuracy in business intelligence analysis.
    • Enhanced experience for complex queries such as, year-to-date summaries and non-aggregatable value calculations based on MicroStrategy schema objects.
    • Retain chat history per page while the dossier session is running with a new confirmation step to clear history and prevent accidental data loss.
    • Automatically translated suggested questions based on a user's language preference setting.
  • Auto Dashboard evolves and enables an interactive chatbot conversation to create a dashboard page or a visualization and modify generated visualizations on the bot panel, all through natural language commands and questions.

Dossier

MicroStrategy Workstation

This is the last release before the retirement of MicroStrategy Workstation for Mac. Support for security and services updates on Workstation for Mac will remain available until June 2024. See Mac Workstation Client End-of-Life Announcement for more information.

MicroStrategy AI

Expose and manage standalone AI bots.

Dossier

Administration

MicroStrategy for Office

  • Empower users to seamlessly leverage and reuse prompted answers across diverse prompts while importing content through the intuitive MicroStrategy add-in for Excel, streamlining data analysis and enhancing productivity.

MicroStrategy Platform Analytics

  • Expanded Auto Adoption: Platform Analytics now captures object (dossier or bot) information (for example, description, ID, or modification date) linked to every AI-related question submitted by a user
  • Improved out-of-the-box dossier: The newly captured information was added to the Auto Adoption dossier. Authors can measure adoption of owned content based on the number of questions asked.

MicroStrategy Library Mobile SDK

iOS

When you customize MicroStrategy Library Mobile SDK for iOS to develop and compile your application, you must have an Apple Mac with Ventura 13.5.2 and above that uses an Intel x86 or Apple M1/M2 chip machine and runs Xcode 15.0 with Apple iOS SDK 17.0.

Android

Android Push Notifications with Firebase Cloud Messaging (FCM):

  • Upgraded Firebase Cloud Messaging (FCM) API to the new HTTP V1 version, enhancing performance, reliability, and security of push notifications. For Out-of-the-Box (OOTB) Android push notification devices, this migration is seamless, requiring no user action.

  • For custom MicroStrategy Android apps, see Enable Push Notifications in Android to update your configuration.

MicroStrategy Mobile SDK

iOS

When you customize MicroStrategy Mobile SDK for iOS to develop and compile your application, you must have an Apple Mac with Ventura 13.5.2 and above that uses an Intel x86 or Apple M1/M2 chip machine and runs Xcode 15.0 with Apple iOS SDK 17.0.

Android

Android Push Notifications with Firebase Cloud Messaging (FCM):

  • Upgraded Firebase Cloud Messaging (FCM) API to the new HTTP V1 version, enhancing performance, reliability, and security of push notifications. For Out-of-the-Box (OOTB) Android push notification devices, this migration is seamless, requiring no user action.

  • For custom MicroStrategy Android apps, see Enable Push Notifications in Android to update your configuration.

MicroStrategy Packages for Python (mstrio-py)

New Features

  • Changed list_users to allow filtering on the enabled field.

  • Added support for ldapdn, language, owner, and default_timezone for Users.

  • Added support for ldapdn for UserGroups.

  • Added add_datasource() and remove_datasource() methods to the Project class to allow the addition and removal of data sources from the project.

  • Added data_language_settings and metadata_language_settings properties to the Project class to allow interacting with project internalization:

    • Added add_language(), alter_language(), remove_language(), alter_current_mode(), alter_default_language() methods for the data_language_settings property.

    • Added add_language() and remove_language() for the metadata_language_settings property.

  • Added a new optional show_description argument to ProjectSettings.list_properties(), ProjectSettings.to_csv(), ServerSettings.list_properties(), and ServerSettings.to_csv() to show descriptions for each setting.

  • Added Enums in mstrio.server.setting_types to allow altering Enum settings by providing Enum values instead of string.

Minor Changes

  • Updated code snippets for data sources to use the Language class and list_languages function from the mstrio.server.language package instead of the Locale class and list_locales function.

  • Members in user groups are now instances of the User or UserGroup class, instead of dictionaries.

  • Addresses in the User class are now instances of the Address class, instead of dictionaries.

Deprecated

The ability to provide initials as a filter in list_users is deprecated and will be removed in the future.

Removed

  • Removed the Locale class and list_locales function from the mstrio.datasources.datasource_map module.

  • Removed the update() method from the OlapCube class.

  • Removed the mstrio.api.exceptions and mstrio.helpers.exceptions modules.

  • Removed the overwrite, attributes, and metrics parameters from the OlapCube.create() method.

  • Removed the ability to pass an instance of the Locale class as an argument in the mstrio.datasources.datasource_map module.

MicroStrategy Embedding SDK

There is a new API to embed a bot consumption page. Some UI customizations can be made as well.

Federated Analytics

The MicroStrategy for QlikView and MicroStrategy for Qlik Sense connectors deployed from prior versions no longer connect to the Intelligence server. See KB486119 for more information.

Data Sources

See Platform Certifications for information about the latest supported and certified configurations.

  • Gateway changes

    • The following SaaS gateways leverage ODBC instead of JDBC: Square, Shopify, ServiceNow, Paypal, Marketo, Hubspot, Eloqua, and Concur. Upon upgrade, existing connections are automatically modified to the new out-of-the-box ODBC-based connectors.

    • The MapR Drill connector has been deprecated and retired.

  • Out-of-the-box driver updates

    Ensure security and reliability by supporting OpenSSL 3.x and other security updates for the following drivers:

    • SQL Server

    • Postgres SQL

    • Google Big Query

MicroStrategy ONE - Update 11 (November 2023)

MicroStrategy Library Mobile SDK

iOS

Use Intune MAM AppConfig with Intune Integrated iOS Library SDK.

MicroStrategy ONE - Update 11 Patch 1 (October 2023)

This release includes remediations for CVE-2023-4863 and CVE-2023-5217 by upgrading libwebp and libvpx to safe versions.

MicroStrategy ONE - Update 11 (September 2023)

MicroStrategy Library

Auto

Dossier

Administration

Check the Modeling services IP and port using the Library log file.

MicroStrategy Workstation

Auto

Dossier

Administration

MicroStrategy Library Mobile

iOS

  • Supports iOS 17.
  • Discover content via folder browsing.

  • Configure the color theme via applications.

  • Link to a dossier stored in a different project from images or text

  • Passing the selected objects when linking from a visualization can be disabled.

  • Support line breaks in transactional grids.

  • More granular controls in applications.

Android

  • Discover content via folder browsing.

  • Configure the color theme via applications.

  • Link to a dossier stored in a different project from images or text

  • Passing the selected objects when linking from a visualization can be disabled.

  • Support line breaks in transactional grids.

  • More granular controls in applications.

MicroStrategy Mobile

iOS

Supports iOS 17.

MicroStrategy for Office

Import visualizations from MicroStrategy to PowerPoint

MicroStrategy Intelligence Server

  • Reduce cube file size by up to 50% using cache compression. This former preview feature is available out-of-the-box.

MicroStrategy REST APIs

MicroStrategy Packages for Python (mstrio-py)

New Features

  • Added support for metric object VLDB properties by providing list_vldb_settings, reset_vldb_settings, and alter_vldb_settings methods, as well as a vldb_settings attribute.

  • Added a refresh argument to list_datasource_warehouse_tables to allow the refreshing of available warehouse tables in a data source.

  • Enhanced the update_physical_table_structure and update_physical_table_structure_for_all_tables methods of LogicalTable to work after changing WarehouseTable structure.

  • Added a Translation class to the mstrio.object_management.translation package to allow the management of translations for any object with the following methods: add_translation, alter_translation, remove_translation, to_csv_from_list, and add_translations_from_csv.

  • Added list_translations to allow listing translations for objects.

  • Added add_translation, alter_translation, remove_translation, and list_translations methods to all objects inheriting from Entity to allow translation management directly through the objects.

Minor Changes

Moved Rights, AggregatedRights, and Permissions enums to the mstrio.helpers module.

Removed

Removed list_folders, create_folder, and delete_folder from mstrio.utils.helper because they have been superseded by the mstrio.object_management.folder module.

MicroStrategy Embedding SDK

Event handlers have been added to Library for item and menu selection.

Federated Analytics

This is the last release in which the MicroStrategy for QlikView and MicroStrategy for Qlik Sense connectors are available on the download site. See KB486119 for more information.

Data Sources

See Platform Certifications for information about the latest supported and certified configurations.

Privileges

See Privileges by License Type for information about license types and associated privileges.

The Use Auto Assistant and ML Visualizations privilege has been added to the Server - Reporter license.

MicroStrategy ONE - Update 10 (August 2023)

MicroStrategy Workstation

Create IAM objects with a generic OAuth type.

MicroStrategy Packages for Python (mstrio-py)

New Features

  • Added the delete() method to the Project class to allow the deletion of projects.

  • Added the hidden parameter to create methods of Attribute and Metric classes.

Minor Changes

Renamed ObjectTypes.NONE to ObjectTypes.NOT_SUPPORTED in the mstrio.types module.

MicroStrategy Library Mobile

iOS

Supports iOS 17 and iPadOS 17. See MicroStrategy Mobile and MicroStrategy Library Apps crash on iPadOS & iOS 17 for more information.

MicroStrategy Mobile

iOS

Supports iOS 17 and iPadOS 17. See MicroStrategy Mobile and MicroStrategy Library Apps crash on iPadOS & iOS 17 for more information.

MicroStrategy ONE - Update 10 (July 2023)

MicroStrategy Workstation

Enable Analytics Architects to view fact extensions in the fact editor.

MicroStrategy Library

Edit header and footer text when exporting a report to Excel.

MicroStrategy Packages for Python (mstrio-py)

Major changes

  • Added the Language class in the mstrio.server.language package to allow management of Languages
  • Added list_languages and list_interface_languages to allow the listing of languages and interface languages

Deprecated

  • The Locale class in mstrio.datasources is no longer supported and is superseded by the Language class in the mstrio.server.language package
  • The list_locales function in mstrio.datasources is no longer supported and is superseded by the list_languages function in the mstrio.server.language package

MicroStrategy ONE - Update 10 (June 2023)

MicroStrategy Workstation

MicroStrategy Library

MicroStrategy Library Mobile

iOS

Dossier transaction grids have an input control "switch" so users can add and modify data. The switch uses a toggle or checkbox style. Both styles support on/off/unset states in data modification mode and on/off for data insertion mode.

Android

MicroStrategy Packages for Python (mstrio-py)

Major Changes

  • Updated the create method of the OlapCube class to support the following new parameters: template, filter, options, advanced_properties, time_based_settings, show_expression_as, and show_filter_tokens.

  • Updated the alter method of the OlapCube class to allow altering of the following new parameters: template, filter, options, and time_based_settings.

  • Added set_partition_attribute, remove_partition_attribute and list_attribute_forms methods to the OlapCube class to allow management of partition attribute and observing attributes forms.

  • Added list_vldb_settings, alter_vldb_settings and reset_vldb_settings methods to the OlapCube class to allow management of VLDB settings.

Deprecated

  • The update method of the OlapCube class is no longer supported. It is superseded by the alter method and will be removed in the future.

  • The attributes, metrics and overwrite parameters in the create method of the OlapCube class are no longer supported. They are superseded by the template parameter and will be removed in the future.

MicroStrategy REST APIs

MicroStrategy Cloud Platform

  • MicroStrategy Backup and Restore unlocks all projects that were previously locked after the restore process.

  • Support for Amazon Linux 2023 and RHEL 8.6

  • New Spain region for AWS

  • One Click Upgrade includes a Tomcat upgrade.

Intelligence Server

Preview Feature: Reduce cube file size by up to 50% using cache compression.

Data Sources

See Platform Certifications for information about the latest supported and certified configurations.

  • Gateway Certifications

    • Certify Sharepoint Lists as an out-of-the-box gateway in Workstation's new data import experience

    • Support XML format for file uploads in the data import workflow

    • IBM Z/OS v12

  • New Gateway Single Sign-On Certifications:

    • OIDC single sign-on to Snowflake with Okta

    • OIDC single sign-on to Amazon Athena with Okta and Azure AD

  • OOTB Driver Updates

    Ensure security and reliability with the following updated drivers:

    • IBM DB2 ODBC Driver

    • MicroStrategy Driver Manager Files

    • Teradata ODBC Driver

    • Exasol ODBC Driver

Upgrade

The MicroStrategy Repository is an embedded PostgreSQL repository that supports the storage of Collaboration Server, Platform Analytics, and the Storage Service. In MicroStrategy ONE Update 10, the embedded PostgreSQL version is upgraded from v 11.x to 14.7. To learn more, see MicroStrategy Repository Upgrade.

Installation

The Korn Shell (KSH package) is not required to launch setup. Bash shell is used by default.

2021 Update 9 (May 2023)

MicroStrategy Workstation

MicroStrategy Packages for Python (mstrio-py)

Major Changes

  • Added list_vldb_settings, alter_vldb_settings, and reset_vldb_settings methods to the DatasourceInstance and Project classes to allow management of VLDB settings.

  • Added a Driver class and list_drivers function in the mstrio.datasources.driver module to allow driver management.

  • Added a Gateway class and list_gateways function in the mstrio.datasources.gateways module, as well as GatewayType and DBType enums in mstrio.datasources.helpers to allow gateway management.

Minor Changes

  • Updated ipython dependency version to 8.10.0.

  • Added a project_id property for Metric instances.

  • Added a delivery_expiration_timezone argument for the Subscription class and its subclasses. This functionality will be supported in a future release.

  • Added SuperCubeAttribute, SuperCubeAttributeForm, and SuperCubeFormExpression classes in the mstrio.project_objects.datasets.super_cube module to support attribute forms for SuperCube.

MicroStrategy Embedding SDK

Native Embedding SDK

  • You can use the Native Embedding SDK to embed visualizations from separate containers to improve performance.

  • Users can interact with the embedded visualization.

  • Users can use APIs to perform manipulations such as filtering.

2021 Update 9 (April 2023)

MicroStrategy HyperIntelligence

All HyperIntelligence products were updated for consistent refresh data behavior in card properties.

2021 Update 9 (March 2023)

MicroStrategy Workstation

MicroStrategy Library

  • Preview Feature: Enable a Filter panel for report consumption in Library Web.

  • Selections in visualization (in-canvas) filters can be matched between source and target dossier pages with contextual linking. See Use a Visualization to Filter Data in a Different Dossier and Link a Text Field or Image to a Dossier for more information.

  • Filter selectors can be configured to automatically update by either clearing or by resetting to a dynamic first/last N element selection to avoid returning no data due to mutually exclusive selections. See Create a Visualization Filter for more information.

  • Filters configured with a dynamic last/first N element selection can be configured to prevent consumers from clearing (unsetting) them. This enforces a selection and avoids large amounts of data being returned. See Create a Default Dynamic Selection Filter for more information.

  • Dossier transaction grids have an input control "switch" so users can add and modify data. The switch uses a toggle or checkbox style. Both styles support on/off/unset states in data modification mode and on/off for data insertion mode.

  • Administrators can allow business users of an application to create, search for, and view new content in their library when content groups are associated with the application.

MicroStrategy Library Mobile

iOS

  • MicroStrategy Insights are supported. Review insightful data changes on-the-go.

  • Selections in visualization (in-canvas) filters can be matched between source and target dossier pages with contextual linking. See Use a Visualization to Filter Data in a Different Dossier and Link a Text Field or Image to a Dossier for more information

  • Filter selectors can be configured to automatically update by either clearing or by resetting to a dynamic first/last N element selection to avoid returning no data due to mutually exclusive selections. See Create a Visualization Filter for more information.

  • Filters configured with a dynamic last/first N element selection can be configured to prevent consumers from clearing (unsetting) them. This enforces a selection and avoids large amounts of data being returned. See Create a Default Dynamic Selection Filter for more information.

  • Administrators can allow business users of an application to create, search for, and view new content in their library when content groups are associated with the application.

Android

  • MicroStrategy Insights are supported. Review insightful data changes on-the-go.

  • Selections in visualization (in-canvas) filters can be matched between source and target dossier pages with contextual linking. See Use a Visualization to Filter Data in a Different Dossier and Link a Text Field or Image to a Dossier for more information.

  • Filter selectors can be configured to automatically update by either clearing or by resetting to a dynamic first/last N element selection to avoid returning no data due to mutually exclusive selections. See Create a Visualization Filter for more information.

  • Filters configured with a dynamic last/first N element selection can be configured to prevent consumers from clearing (unsetting) them. This enforces a selection and avoids large amounts of data being returned. See Create a Default Dynamic Selection Filter for more information.

  • Administrators can allow business users of an application to create, search for, and view new content in their library when content groups are associated with the application.

MicroStrategy Platform Analytics

Client telemetry offers a realm of insightful data. This former preview feature is available out-of-the-box.

  • Developers/BI Architects can discover consumption patterns of a dossier such as page clicks, time elapsed, and so on.

  • Administrators can monitor end-to-end performance of the platform, including client-side rendering times.

  • Starting in MicroStrategy 2021 Update 9, a new out-of-the-box dossier showcases this feature's new capabilities.

MicroStrategy Packages for Python (mstrio-py)

Major Changes

  • Added HistoryListSubscription, FTPSubscription, and FileSubscription classes in the mstrio.distribution_services.subscription package to allow management of history list, FTP, and file subscriptions.

  • Added a DynamicRecipientList class in the mstrio_distribution_services.subscription package to allow management of dynamic recipient lists.

  • Added list_dynamic_recipient_lists to allow the listing of dynamic recipient lists.

Minor Changes

  • Added verification when initializing the Report object, if the object is supported. Currently, objects with the following subtypes are supported: 768 - grid, 769 - graph 769, 770 - engine, 774 - grid and graph, 778 - transaction, and 781 - hyper card.

  • Changed the list_reports function to return objects only supported by the Report class.

  • Added methods to convert connections from DSN to DSN-less format in the DatasourceInstance and DatasourceConnection classes.

  • Improved error messages when calling list_dependents and list_dependencies on unsupported objects.

  • Added support for the Time type to SuperCube class.

  • Added with statement compatibility for Connection object.

  • Added a find_objects_with_id function in mstrio.object_management.search_operations to allow searching for an object when knowing only its ID.

  • Added checking during creation to see if a SuperCube with given name already exists in a folder and displays an error if it does.

  • Added support for Python 3.11

  • Altered the attributes.py code snippet to use the list_table_columns and list_logical_tables methods from the table module.

  • Updated dependencies in requirements.txt.

  • Combined the _update_acl and _modify_rights methods. Added a modify_rights method.

  • Added Service and ServiceWithNode classes in the mstrio.server.node module.

MicroStrategy Library Mobile SDK

iOS

  • Supports Intune native EMM SDK for iOS 16.

  • Supports native integrated Intune SDK for Xcode 14.

MicroStrategy REST APIs

Data Sources

See Platform Certifications for information about the latest supported and certified configurations.

  • Gateway Certifications
    Create connections and run analytics with optimized SQL against the following new gateways:

    • SQL Server 2022

    • PostgreSQL 15

    • Teradata VantageCloud Lake

    • Unity Catalog for Databricks

    • Palantir Foundry

    • Dremio

  • OOTB Driver Updates
    Ensure security and reliability with the following updated drivers:

    • Denodo JDBC driver is out-of-the-box

    • Palantir Foundry driver is out-of-the-box

    • Snowflake ODBC driver upgraded to 2.25.7

    • Drill JDBC driver upgraded to 1.6.12.1009

    • SQL Server ODBC driver upgraded to 08.02.1081

  • Improved enterprise security with extended data source single-sign-on authentication support using Open ID Connect and oAuth:

  • Improved data source management in Workstation:

    • Convert DSN-based data sources to DSN-less through Workstation and Python for self-service data source definition in on-prem or cloud environments.

    • A new tab under Data Sources for gateway and driver management. Here you can disable or enable drivers and gateways to limit users' access to them based on enterprise policy.

    • Create and edit data sources for PayPal, Shopify, Marketo, HubSpot, ServiceNow, and Square SaaS gateways.

    • Create and edit data sources against the new Dremio and Palantir Foundry gateways.

Upgrades

During upgrades, the platform installer automatically backs up integral configuration files that can be manually updated by a user; therefore, automating a key manual pre-upgrade step.

2021 Update 8 (February 2023)

MicroStrategy Workstation

Create dynamic address lists to dynamically source the recipients list for subscription delivery.

MicroStrategy Embedding SDK

Embed MicroStrategy Report page.

  • Users can embed MicroStrategy Report consumption page.

  • Users can control the visibility of the navigation bar of the Report consumption page.

2021 Update 8 (January 2023)

The January 2023 release includes defect fixes for stability and user experience.

2021 Update 8 (December 2022)

MicroStrategy Workstation

MicroStrategy Web

All Flash entry points in documents have been removed. See KB485844 for more information.

MicroStrategy Library

  • MicroStrategy Insights allow users to select key business KPIs from their dossiers and track them all from a single page in Library. Based on the KPIs users track, MicroStrategy helps bring trends and outliers to the surface, as well as alert users with in-app and email notifications.

  • Time zone reporting. This former preview feature is available out-of-the-box.

    • Dynamically switch between time zones for your data.

    • Select a preferred time zone for users.

    • Select preferred formatting for smart attributes with a language object. This setting allows you to switch the Library user interface languages as well, if it is one supported out of the box.

  • The Report Editor comes to Library. Create and edit reports with your favorite features including the Advanced Properties panel, View Filters, SQL View, and many more. This former preview feature is available out-of-the-box.

  • Set default authentication for Library Web using the Library server config file.

  • Define templates for creation of new dossiers.

  • In dossiers, the same information window can be targeted by two or more visualizations in the page for reusability.

MicroStrategy Library Mobile

iOS

  • Undo or redo dossier manipulations such as filtering, drilling, and sorting.

  • Supports Intune native EMM SDK for iOS 16.

MicroStrategy Platform Analytics

Preview Feature: Client telemetry offers a realm of insightful data:

  • Developers/BI Architects can discover consumption patterns of a dossier such as page clicks, time elapsed, and so on.

  • Administrators can monitor end-to-end performance of the platform, including client-side rendering times.

MicroStrategy Library Mobile SDK

iOS

  • Supports MobileIron, AirWatch, and BlackBerry Dynamics SDKs with Xcode 14.

  • When you customize MicroStrategy Library Mobile SDK for iOS, you must have an Apple Mac with Monterey 12.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 14.1 with the Apple iOS SDK 16.1, to develop and compile your application.

MicroStrategy Mobile SDK

iOS

  • Supports MobileIron, AirWatch, and BlackBerry Dynamics SDKs with Xcode 14.

  • When you customize MicroStrategy Mobile SDK for iOS, you must have an Apple Mac with Monterey 12.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 14.1 with the Apple iOS SDK 16.1, to develop and compile your application.

MicroStrategy Web SDK

Several APIs have been removed.

MicroStrategy Embedding SDK

MicroStrategy REST APIs

Data Sources

  • Create and manage data sources in Workstation for the following SaaS sources:

    • Dropbox

    • Google Analytics

    • Google Drive

    • SAP oData Gateways

    • Salesforce Reports

    • Twitter

  • Create and manage data sources in Workstation through DSN-less and guided connection definitions to the following additional sources:

    • Azure SQL Database

    • IBM DB2

    • MariaDB

    • MySQL

    • SingleStore

    • Sybase

    • Tibco Data Virtualization

    • Vertica

2021 Update 7 (November 2022)

MicroStrategy Library

Export Report Services documents to Excel.

MicroStrategy Packages for Python (mstrio-py)

There are two new Python modules for documents and dossiers. Check out this video to learn more.

2021 Update 7 (October 2022)

MicroStrategy Workstation

MicroStrategy Library

Embedded surveys have been removed.

MicroStrategy Web

Embedded surveys have been removed.

MicroStrategy REST APIs

2021 Update 7 (September 2022)

MicroStrategy Workstation

MicroStrategy Library

  • Preview Feature: The Report Editor comes to Library. Create and edit reports with your favorite features including the Advanced Properties panel, View Filters, SQL View, and many more.

  • Preview Feature: Support OAuth authentication against OAuth-enabled gateways for live connected dossier and report executions.

  • Improved color contrast with a more accessible primary blue and overall color palette.

MicroStrategy Library Mobile

iOS

  • Preview Feature: Supports OAuth authentication against OAuth-enabled gateways for live connected dossier executions.

  • Enhanced iOS 16 and iPadOS 16 compatibility to provide more stable upgrades.

  • Improved color contrast with a more accessible primary blue and overall color palette.

Android

Enhanced dossier viewing experience with the ability to undo and redo basic operations such as filtering, drilling, sorting, and so on.

MicroStrategy Mobile

iOS

Enhanced iOS 16 and iPadOS 16 compatibility to provide more stable upgrades.

MicroStrategy Library Mobile SDK

Android

The MicroStrategy Library Mobile SDK for Android is certified to work with Android 13 (API level 33). When you customize MicroStrategy Library Mobile SDK for Android, you must have Android SDK 33 to develop and compile your application. Android Studio Chipmunk and newer is supported.

MicroStrategy Mobile SDK

Android

The MicroStrategy Mobile SDK for Android is certified to work with Android 13 (API level 33). When you customize MicroStrategy Mobile SDK for Android, you must have Android SDK 33 to develop and compile your application. Android Studio Chipmunk and newer is supported.

MicroStrategy Embedding SDK

  • The MicroStrategy Embedding SDK help has been moved to GitHub Pages. This allows easier collaboration from the developer community. The new help site has improved page navigation, cleaner design, instant search, and also supports dark mode.

  • Embed the MicroStrategy Library home page.

    • Users can also embed any child page accessed from the sidebar, including subscriptions, etc.

    • Control the visibility of the navigation bar and sidebar of the MicroStrategy Library home page.

MicroStrategy REST APIs

The MicroStrategy REST API help has been moved to GitHub Pages This allows easier collaboration from the developer community. The new help site has improved page navigation, cleaner design, instant search, and also supports dark mode.

The MicroStrategy REST API Explorer still remains on the demo site. In addition, we have also released a new REST API Playground.

Data Sources

  • Preview Feature: Library supports OAuth authentication against OAuth-enabled gateways for live connected dossiers and reports.

  • Support for OAuth authentication to Exasol in MicroStrategy Library and data import.

  • Support DSN-less data source creation for the following additional gateways: Spanner, AlloyDB, IBM Netezza, IBM NPS, Yellowbrick, and Denodo.

  • Case and CaseV Functions are pushed down to the gateway for SingleStore, Vertica, and mongoDB.

  • Edit data sources created during data import in Workstation Data Sources management.

  • Create connections and run analytics with optimized SQL against Starburst.

  • Convert old manual oAuth configurations in data import to new IAM objects for Snowflake and Azure Synapse. See KB485668 for more information.

  • Create connections and run analytics with optimized SQL against upcoming Google AlloyDB for PostgreSQL.

2021 Update 6 (August 2022)

MicroStrategy Workstation

  • The Intelligent Cube Editor offers control over advanced properties. Configure metric aggregations, null handling, indexing, and more.

  • Burst your content for personalized data distribution to multiple recipients dynamically.

MicroStrategy Packages for Python (mstrio-py)

Major Changes

  • Added the Transformation, TransformationAttribute, and TransformationAttributeForm classes in the mstrio.modeling.schema.transformation subpackage to allow transformation management.

  • Added list_transformations to allow listing for transformations.

  • Added the DefaultSubtotals, Dimensionality, DimensionalityUnit, FormatProperty, Metric, MetricFormat, and Threshold classes in the mstrio.modeling.metric subpackage to allow metric management.

  • Added list_metrics to allow listing for metrics.

Minor Changes

  • Added list_locales to the mstrio.datasource.datasource_map module to allow the listing of locales.

  • Added the DatasourceMap.alter() method to allow the altering of user-defined connection mapping.

  • Added the list_warehouse_tables() method to the mstrio.modeling.schema.table.warehouse_table module to allow listing of all warehouse tables from all available data sources.

Deprecated

  • The mstrio.distribution_services.contact module is deprecated and moved to the mstrio.users_and_groups subpackage.

  • The mstrio.distribution_services.contact_group module is deprecated and moved to the mstrio.users_and_groups subpackage.

  • The mstrio.access_and_security.security_filter subpackage is deprecated and replaced by the mstrio.modeling.security_filter and mstrio.modeling.expression subpackages.

2021 Update 6 (July 2022)

MicroStrategy Workstation

MicroStrategy Packages for Python (mstrio-py)

Major Changes

Added a Filter class in the mstrio.modeling.filter subpackage to allow filter management.

Added list_filters to allow listing of filters.

Turned off certificate verification when using get_connection.

Minor Changes

Added the ability to pass project_name, instead of project_id, in functions that allowed only project_id in the past.

2021 Update 6 (June 2022)

MicroStrategy Library

MicroStrategy Library Mobile

iOS

  • Dossier transaction grids are supported.

  • Administrators can define a set of color palettes available per application, including defining the application’s default palette to apply it automatically during consumption.

Android

  • Dossier transaction grids are supported.

  • Administrators can define a set of color palettes available per application, including defining the application’s default palette to apply it automatically during consumption.

MicroStrategy Workstation

MicroStrategy Web

  • New authoring features are not implemented in MicroStrategy Web. Please note that users must be on MicroStrategy Library or MicroStrategy Workstation to access all new features starting with this release. Moving forward, new features will no longer be available in MicroStrategy Web. This is to ensure an optimized analytics experience with high performance.

  • Renamed right-click menu options to clarify the viewing and hiding of containers. Show/Hide on Mobile is renamed to Show/Hide on Responsive View. Show/Hide on Canvas is renamed to Show/Hide on Default View.

  • Configure SameSite cookies for MicroStrategy Web and MicroStrategy Mobile via a user interface, instead of manually editing files.

  • The graph engine was upgraded as part of our MicroStrategy Security Assurance Program.  While all efforts are made to minimize impact to graph rendering, there are some noticeable changes to documents as part of this release.  KB485520 describes the specific examples where changes may be seen as part of this upgrade.

MicroStrategy Platform Analytics

Improved monitoring and troubleshooting after the Intelligence server crashes by capturing job telemetry during initial job creation.

MicroStrategy Packages for Python (mstrio-py)

Major Changes

  • New LogicalTable, PhysicalTable, and WarehouseTable classes in the mstrio.modeling.schema.table module to allow table management.

  • New list_logical_tables(), list_physical_tables(), list_datasource_warehouse_tables(), and list_namespaces() functions to allow the listing and searching of specific tables in the project.

Minor Changes

  • New search_pattern and project_id parameters in the object listing functions.

  • New move method added to Folder, Object, SecurityFilter, Attribute, Fact, UserHierarchy, Report, Shortcut, SearchObject, Document, and Dossier to allow the moving of objects between folders

  • Added create_copy method in SecurityFilter, Attribute, Fact, UserHierarchy, Report, Shortcut, SearchObject, Document, and Dossier.

Deprecated

The name_begins parameter is deprecated in functions listing cubes and reports in favor of the name parameter.

See the mstrio-py help for more information.

MicroStrategy Library Mobile SDK

iOS

  • When you customize MicroStrategy Library Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

Android

  • The Library Mobile SDK for Android is certified to work with Android 12 (API level 31). When you customize MicroStrategy Mobile for Android, you must have Android SDK 31 to develop and compile your application. Android Studio Bumblebee and newer is supported.

  • Configure a specific application URL as an entry point.

MicroStrategy Mobile SDK

iOS

When you customize MicroStrategy Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

Android

The MicroStrategy Mobile SDK for Android is certified to work with Android 12 (API level 31). When you customize MicroStrategy Mobile for Android, you must have Android SDK 31 to develop and compile your application. Android Studio Bumblebee and newer is supported.

MicroStrategy Web SDK

Several APIs have been modified.

MicroStrategy REST APIs

Authentication

Support for SAML single logout.

Data Sources

  • Gateway Certifications:

    • Yellowbrick 5.x

  • OOTB Driver Updates:

    • Big Query ODBC: 2.4.6.1015

    • Big Query JDBC: 1.2.23.1027

    • Spark ODBC driver 2.6.23.1039

    • Spark JDBC 2.6.26.1045

    • Impala ODBC 2.6.16.1022

  • Functionality Enhancements:

  • Security and Performance Enhancements

    • Case and CaseV Functions have been pushed down to the database side for Azure Synapse and Db2.

    • Secure transaction certification for Snowflake and SingleStore

2021 Update 5.2 (May 2022)

Released on May 20, 2022

MicroStrategy HyperIntelligence

This version of HyperIntelligence is based on Google's new manifest version, Manifest V3. New browser requirements apply. The browser must be Chrome v99 or later.

MicroStrategy Workstation

MicroStrategy Packages for Python (mstrio-py)

  • A Fact class in the mstrio.modeling.schema.fact subpackage allows fact management.

  • A list_facts function allows the listing of facts.

See the mstrio-py help for more information.

Data Sources

See Platform Certifications for information on the latest supported and certified configurations.

  1. OOTB Driver Updates:

    • Oracle ODBC Driver

    • Sybase ASE ODBC driver

    • Drill ODBC Driver

  2. Functionality Enhancements

  • Support for Kerberos and LDAP authentication modes in Modern Data Source Management in Workstation

  • TLS Support for ODBC connectivity in Modern Data Source Management

Released on May 12, 2022

This release provides remediation for a group of security vulnerabilities found within Java by upgrading the Java version to 11.0.15+10 across products. Learn more.

2021 Update 5.1 (April 2022)

Released on April 22, 2022

MicroStrategy Workstation

Android

  • Subscribe to the entire dossier content in PDF or Excel format to send updates directly to your email inbox.

  • Export entire dossiers to Excel.

MicroStrategy Packages for Python (mstrio-py)

  • New Attribute class in the mstrio.modeling.schema.attribute subpackage allows attribute management.

  • New AttributeForm class in the mstrio.modeling.schema.attribute_form subpackage allows attribute form management.

  • New list_attributes allows listing of attributes.

  • New list_functions in the mstrio.modeling.expression subpackage allows listing of functions.

  • New act_expression, expression, expression_nodes, parameters, and dynamic_date_time modules in the mstrio.modeling.expression subpackage allow management of fact expressions.

  • ExecutionMode elements have been changed from ASYNCH_CONNECTION to ASYNC_CONNECTION and from ASYNCH_STATEMENT to ASYNC_STATEMENT.

  • Refactored examples in the code_snippets folder, with modifications to make them easier to use in MicroStrategy Workstation.

  • Renamed the workstation_demos folder to workflows.

MicroStrategy Cloud Platform

  • Increased default sizes for EBS and disk for all MicroStrategy Cloud environments to better support smart memory, increasing data scalability.

  • Increased throughput for shared storage from 25 MB to 40 MB for all MicroStrategy Cloud environments. This optimizes deployment and overall performance.

Released on April 7, 2022

This release includes remediations for CVE-2022-22965 by upgrading Spring Framework libraries version to 5.3.18.

2021 Update 5 (March 2022)

MicroStrategy Workstation MicroStrategy Mobile SDK
MicroStrategy Web MicroStrategy Packages for Python (mstrio-py)
MicroStrategy Library MicroStrategy Visualization SDK
MicroStrategy Library Mobile MicroStrategy REST APIs
Intelligence Server MicroStrategy Cloud Platform
MicroStrategy Platform Analytics Data Sources
MicroStrategy Library Mobile SDK  

MicroStrategy Workstation

MicroStrategy Web

  • Easily display and compare one or more key metrics on a scale using thresholds with a Gauge visualization.

  • Waterfall chart setting to dynamically color the start point according to increase or decrease for enhanced precision.

  • A new KPI section houses multi-metric, comparison, and classic KPIs.

  • Sankey and Time Series visualizations appear in the More section.

  • Setting to control how users dismiss information windows with the option to enable a close button.

  • Lock specific filter selections to disable interactions in the Filter panel.

  • Options for vertical scrolling have been extended to allow authors to expand the canvas while retaining the existing content dimensions.

  • Request and configure a new ESRI key. This is required for ESRI maps to continue to display starting in this release. ESRI map styles have been updated for enhanced readability.

MicroStrategy Library

  • Easily display and compare one or more key metrics on a scale using thresholds with a Gauge visualization.

  • Waterfall chart setting to dynamically color the start point according to increase or decrease for enhanced precision.

  • A new KPI section houses multi-metric, comparison, and classic KPIs.

  • Sankey and Time Series visualizations appear in the More section.

  • Setting to control how users dismiss information windows with the option to enable a close button.

  • Lock specific filter selections to disable interactions in the Filter panel.

  • Options for vertical scrolling have been extended to allow authors to expand the canvas while retaining the existing content dimensions.

  • Open and edit a dossier without loading the data.

  • Rename a dossier from the File menu.

  • An updated, modern Save and Save As dialog.

  • View default content groups in the Sidebar menu pushed automatically to your Library application by administrators.

  • Request and configure a new ESRI key. This is required for ESRI maps to continue to display starting in this release. ESRI map styles have been updated for enhanced readability.

MicroStrategy Library Mobile

iOS

  • View default content groups in the Sidebar menu pushed automatically to your Library application by administrators.

  • Lock specific filter selections to disable interactions in the Filter panel.

Android

Lock specific filter selections to disable interactions in the Filter panel.

Intelligence Server

MicroStrategy Platform Analytics

Client Telemetry data can be purged in Platform Analytics. This completes full parity with Enterprise Manager for Client Telemetry.

MicroStrategy Library Mobile SDK

iOS

When you customize MicroStrategy Library Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

MicroStrategy Mobile SDK

iOS

  • BlackBerry certification to support iOS 15 with Xcode 13.1.

  • MobileIron certification to support iOS 15 with Xcode 13.1.

  • When you customize MicroStrategy Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

MicroStrategy Packages for Python (mstrio-py)

You can use the mstrio-py Python library and its dependencies when using Python within Workstation. Download the mstrio-py Python library through PyPi or GitHub. See the mstrio-py help help for a complete guide of the available modules for MicroStrategy data science and system administration tasks. New features include:

  • Preview Feature: A Python module for object migrations. Use Python to create a migration package on the source and deploy it on a target environment. You do not have to enable preview features in Workstation to use this functionality.

  • A SchemaManagement class in the mstrio.modeling subpackage that allows schema management.

  • A UserHierarchy class in the mstrio.modeling subpackage that allows user hierarchy management.

  • A list_user_hierarchies function that allows the listing of objects in the newly created UserHierarchy class.

MicroStrategy Visualization SDK

  • Tag custom visualizations to appear in relevant sections of the Visualization Gallery.

    • MicroStrategy REST APIs

    MicroStrategy Cloud Platform

    • Deploy Azure Enterprise Environments in the UAE North Region

    • Support for Azure environments in the Switzerland North Region. Now customers in this region can select from Team, Department, or Enterprise environments.

    Data Sources

    See Platform Certifications for information about the latest supported and certified configurations.

    1. Gateway Certifications

      • Vertica 11.0.2

      • Denodo 8.0

    2. OOTB Driver Updates

      • Snowflake ODBC and JDBC Driver

      • Google BigQuery ODBC and JDBC Driver

      • Cloudera Hive and Impala JDBC Driver

      • Driver Manager files on Linux Platform

      • SQL Server JDBC Driver

      • MongoDB JDBC Driver

      • SAP HANA ODBC Driver

      • Salesforce ODBC Driver

      • Drill JDBC Driver

      • Spark SQL JDBC Driver

      • Concur JDBC Driver

      • Eloqua JDBC Driver

      • HubSpot JDBC Driver

      • Marketo JDBC Driver

      • ServiceNow JDBC Driver

      • Shopify JDBC Driver

      • Square JDBC Driver

    3. Security and Performance Enhancements

      • Case and CaseV functions have been pushed to the gateway side for PostgreSQL, SQL Server, Redshift, MySQL, Google BigQuery, Impala, Spark SQL, Hive, and Oracle 21c.

      • Enable secure transaction in a live metadata update for SQL Server

    4. Functionality Enhancements

      • Simple mode data source management for major Diamond and Platinum gateways with support of JDBC TLS configuration.

    2021 Update 4.1 (February 2022)

    The February release includes security, performance, and user experience updates to:

    • HyperMobile for Android and iOS

    • Library Mobile for Android and iOS

    • Workstation for macOS and Windows

    2021 Update 4.1 (January 2022)

    Released on January 28, 2022

    MicroStrategy Library Mobile

    iOS

    Support for native integrated Intune SDK with Xcode 13.1.

    Android

    Optimized data encryption and security. See KB485325 for more information.

    MicroStrategy Mobile

    iOS

    Support of native integrated AirWatch SWIFT SDK with Xcode 13.

    MicroStrategy Packages for Python (mstrio-py)

    • The following have been added:

      • Contact class in the mstrio.distribution_services.contact subpackage to allow contact management

      • ContactGroup class in the mstrio.distribution_services.contact_group subpackage to allow contact group management

      • Device class in the mstrio.distribution_services.device subpackage to allow device management

      • Transmitter class in the mstrio.distribution_services.transmitter subpackage to allow transmitter management

      • list_contact, list_contact_groups, list_devices, list_transmitters functions to allow listing of objects of newly created classes

      • PackageConfig class in the mstrio.server.migration subpackage with support for PackageSettings and PackageContentInfo, used for configuration migration

      • Delete functionality to the Document, Dossier, and Report classes

    • The Event class has been extended in the mstrio.distribution_services.event subpackage with functionalities to create, update, and delete events.

    • The Connection object attribute, session, has been renamed to _session.

    • The get, head, post, put, delete, and patch HTTP request methods can be added to the Connection object.

    • Change the Connection object to automatically renew the connection or reconnect when the session becomes inactive if authenticated with login and password.

    • Connect to your MicroStrategy environment using the Connection class.

      The UseLibrary privilege is required to log into Library

    • Import and filter data from OlapClub, SuperCube, or Report into a Pandas DataFrame.
    • Export data into MicroStrategy by creating or updating SuperCube.
    • The following administration modules are included:
      • Project management module
      • Server management module
      • User and Usergroup management modules
      • Schedules management module
      • Subscription management modules, including email subscription and cache update subscription
      • Document and Dossiers in User Library modules
      • User Connections management module
      • Privilege and Security Role management modules
      • Cube Cache management module
      • Intelligent cube management module
      • Security Filter module
      • Datasources subpackage for database management
      • Job Monitor module
      • Object Management module
      • Contact module
      • Contact Group module
      • Device module
      • Transmitter module
      • Event module

    See the mstrio-py help for more information.

    Released on January 10, 2022

    This release includes remediations for CVE-2021-45105 and CVE-2021-44832 by upgrading to Apache Log4j 2 version to 2.17.1.

    MicroStrategy 2021 Update 4.1 includes the following three remediated vendor drivers, which have been upgraded to Log4j 2.17:

    • Magnitude SparkSQL

    • Hive

    • ImpalaJDBC

    2021 Update 4 (December 2021)

    This release includes remediations for CVE-2021-44228 and CVE-2021-45046 by upgrading to Apache Log4j 2 versions to 2.16.0.

    MicroStrategy 2021 Update 4 includes three third-party, vendor-provided drivers with embedded Log4j libraries. MicroStrategy has determined these libraries are vulnerable. We are working with the vendors to make remediated drivers available. In the interim, we recommend mitigation steps to be taken on the following systems where these drivers are present: MicroStrategy Intelligence Server and MicroStrategy Workstation. Environments deployed in the MicroStrategy Cloud have these supplemental mitigation steps already applied.

    Mitigation steps are detailed in MicroStrategy’s response to the Log4j Vulnerability (CVE-2021-44228) and (CVE-2021-45046).

    Platform Certifications

    Changes to the support matrix for third-party software will come into effect after June 2022. See KB485274 and Platform Certifications for more information.

    MicroStrategy Workstation

    • Show or hide objects.

    • Design and create custom applications for unique Library viewing experiences based on user or user group requirements.

    • Provide in-context data without taking up permanent screen real estate with information windows in dossier. Trigger information windows from an image, text box, or visualization.

    • After searching for a location on a Geospatial Service visualization, a pin automatically drops so you can easily interact with the selectors to discover what points of interest are within range.

    • Preview Feature: Create Intelligent cubes using the Intelligent Cube Editor.

    • Preview Feature: Move objects between environments using migration packages.

    • Preview Feature: Easily manage and distribute content groups to users or user groups for viewing across Library applications.

    • Preview Feature: MicroStrategy Storage Service adds a local or remote repository for Library server.

    MicroStrategy Web

    • Provide in-context data without taking up permanent screen real estate with information windows in dossier. Trigger information windows from an image, text box, or visualization.

    • After searching for a location on a Geospatial Service visualization, a pin automatically drops so you can easily interact with the selectors to discover what points of interest are within range.

    • By default, the Convert to Document button is no longer available from the File menu in dossier authoring. Dossier’s latest, modern workflows are not compatible with document features. If you need to enable this setting, go to /webapps/MicroStrategy/WEB-INF/xml/sys_defaults.xml on the Web server. Then change the value in Allow Dossier to RSD conversion from 0 to 1 and restart the Web server.

    MicroStrategy Library

    • Connect to multiple app workspaces to view customized Library experiences.

    • Edit or create new dossiers all within the Library interface.

    • View the My Content section in the Sidebar menu to filter by all content that you own.

    • Subscribe to dossier content in PDF or Excel format to send updates directly to your email inbox.

    • Undo or redo dossier manipulations such as filtering, drilling, and sorting.

    • Provide in-context data without taking up permanent screen real estate with information windows in a dossier. Trigger information windows from an image, text box, or visualization.

    • After searching for a location on a Geospatial Service visualization, a pin automatically drops so you can easily interact with the selectors to discover what points of interest are within range.

    • Preview Feature: View default content groups in the Sidebar menu pushed automatically to your Library application by administrators.

    MicroStrategy Library iOS

    • Connect to and switch between multiple app workspaces to view customized Library experiences.

    • View the My Content section in the Sidebar menu to filter by all content that you own.

    • Subscribe to dossier content in PDF or Excel format to send updates directly to your email inbox.

    • Provide in-context data without taking up permanent screen real estate with information windows in a dossier. Trigger information windows from an image, text box, or visualization.

    • Preview Feature: View default content groups in the Sidebar menu pushed automatically to your Library application by administrators.

    MicroStrategy Library Android

    • Connect to and switch between multiple app workspaces to view customized Library experiences.

    • View the My Content section in the Sidebar menu to filter by all content that you own.

    • Provide in-context data without taking up permanent screen real estate with information windows in a dossier. Trigger information windows from an image, text box, or visualization.

    • Preview Feature: View default content groups in the Sidebar menu pushed automatically to your Library application by administrators.

    MicroStrategy Library Mobile SDK

    iOS

    When you customize Library Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

    Android

    The Library Mobile SDK for Android is certified to work with Android 12 (API level 31). When you customize Library Mobile for Android, you must have Android SDK 31 to develop and compile your application. Android Studio 4.2 and up is supported.

    MicroStrategy Mobile SDK

    iOS

    When you customize MicroStrategy Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

    Android

    The MicroStrategy Mobile SDK for Android is certified to work with Android 12 (API level 31). When you customize MicroStrategy Mobile for Android, you must have Android SDK 31 to develop and compile your application. Android Studio 4.2 and up is supported.

    MicroStrategy Web SDK

    Several APIs have been deprecated.

    MicroStrategy Embedding SDK

    Installation

    Install updates using a full platform installer on Windows and Linux. See KB485278 for more information.

    Data Sources

    • Microsoft SQL Server 2019 Analysis Services is certified.

    • Cloudera Data Platform (CDP) Private Cloud Base 7.1 is certified.

    • Secure text input through parameterized queries has been extended to transaction inputs in transaction services reports and documents. See KB485174 for more information and a list of certified gateways that are automatically enabled with each MicroStrategy 2021 Update release.

    2021 Update 3 (November 2021)

    MicroStrategy Mobile SDK

    iOS

    Support for MobileIron with iOS 15.

    2021 Update 3 (October 2021)

    MicroStrategy Library

    Export to PDF filter summaries include the full attribute and metric names.

    MicroStrategy Library Mobile

    iOS

    Export entire dossiers to Excel.

    MicroStrategy Mobile SDK

    iOS

    Supports BlackBerry Dynamics native EMM SDK with iOS 15.

    MicroStrategy Library Mobile SDK

    iOS

    Supports Intune native EMM SDK with iOS 15.

    MicroStrategy Packages for Python (mstrio-py)

    • A new CacheUpdateSubscription class in the subscription module.

    • Return a specific type of subscription object using list_subscriptions.

    • The inner structure of mstrio.distribution_services.subscription was changed. Make sure to import from mstrio.distribution_services or mstrio.distribution_services.subscription at most. Anything deeper is considered internal implementation detail and not guaranteed to remain stable.

    • New user and user_group arguments added to the list_security_filters function to allow filtering results by user or user group.

    • New list_security_filter method and security_filters property for the UserGroup class.

    • New list_security_filter method security_filters property for the User class.

    2021 Update 3 (September 2021)

    MicroStrategy HyperIntelligenceMicroStrategy Mobile
    MicroStrategy WorkstationMicroStrategy Web SDK
    MicroStrategy WebMicroStrategy Embedding SDK
    MicroStrategy LibraryMicroStrategy REST APIs
    Federated AnalyticsData Sources
    MicroStrategy Command ManagerPrivileges

    MicroStrategy HyperIntelligence

    Add contextual dosser links to HyperIntelligence cards.

    MicroStrategy Workstation

    • Create and edit user hierarchies.
    • View the system hierarchy of a project.
    • Manage and monitor jobs.
    • Create and edit cache update subscriptions.
    • Compare environment configurations.
    • Use a Multi-Metric KPI to provide a quick performance indication for two or more metrics.
    • Use a Comparison KPI to indicate the progress towards an objective, like sales and goal.
    • For every dossier object, experience an intuitive Format panel with visual cues, organized into three consistent tabs for visualization or object specific options, text and form, and container. Collapsible folders and toggles make it easy to find what you're looking for.
    • From the Layers panel, drag and drop existing visualizations and objects from the canvas into panels in dossier panel stacks.
    • Support a new MDX/OLAP data source of Kyligence for hierarchy reporting.
    • Applications have been renamed to projects.

    • Better control of how attributes are related in data import Intelligent cubes (also known as Super Cubes) with a single Attribute Relationship Model setting. This feature requires a data engine version of 2021 or above.

    • Preview Feature: Add information windows in dossiers. Information windows are dynamic popups that enhance the visual interactivity for the end-user.

    MicroStrategy Web

    • Use a Multi-Metric KPI to provide a quick performance indication for two or more metrics.
    • Use a Comparison KPI to indicate the progress towards an objective, like sales and goal.
    • For every dossier object, experience an intuitive Format panel with visual cues, organized into three consistent tabs for visualization or object specific options, text and form, and container. Collapsible folders and toggles make it easy to find what you're looking for.
    • From the Layers panel, drag and drop existing visualizations and objects from the canvas into panels in dossier panel stacks.
    • Support a new MDX/OLAP data source of Kyligence for hierarchy reporting.
    • Manage SAML configuration files in a Web browser.

    MicroStrategy Library

    Export entire dossiers to Excel.

    Federated Analytics

    MicroStrategy for Power BI

    Support for OIDC authentication.

    MicroStrategy Command Manager

    Enable, disable, and list mobile telemetry settings of Platform Analytics statistics properties through Command Manager.

    MicroStrategy Mobile

    Manage SAML configuration files in a Web browser.

    MicroStrategy Web SDK 

    Several APIs have been deprecated.

    MicroStrategy Visualization SDK

    Create a Format panel using a React-based framework.

    MicroStrategy Embedding SDK

    MicroStrategy REST APIs

    Data Sources

    See Platform Certifications for information about the latest supported and certified configurations.

    1. Gateway Certifications

      • Azure PostgreSQL is certified. See KB485177 for more information.
      • Azure SQL Managed Instance is certified. See KB485172 for more information.

    2. OOTB Driver Updates

      • The latest ODBC trace file, drivers for SQL Server, IBM Db2, Redshift, Oracle, and SAP HANA gateways are out-of-the-box, optimizing security and performance.

    3. Security and Performance Enhancements

      • OAuth authentication is supported via ADFS authentication for Snowflake.
      • OAuth authentication is supported via Cognito for Amazon S3.

      • Azure SQL Database single sign-on (SSO) support extends to JDBC driver.

      • SSL is enabled by default for PostgreSQL in MicroStrategy Web and Workstation.
      • SSL is enabled by default for SQL Server in MicroStrategy Web and Workstation.
      • The following functions have been pushed to the gateway side for PostgreSQL:
        • RunningStdevPFunction
        • MovingStdevPFunction
        • MovingStdevFunction
        • RunningStdevFunction
        • LagFunction
        • LeadFunction
        • ToNumberFunction
        • StrLastPositionFunction
        • StrBeginsWithFunction
        • StrEndsWithFunction
        • StrCharFunction
        • StrReplaceFunction
        • StrRepeatFunction

    4. Functionality Enhancements

    Privileges

    See Privileges by License Type for information about license types and associated privileges.

    The Manage Application privilege has been added to the Server - Intelligence license.

    2021 Update 2 (August 2021)

    The August release includes defect fixes for stability and user experience.

    2021 Update 2 (July 2021)

    MicroStrategy Workstation

    2021 Update 2 (June 2021)

    MicroStrategy HyperIntelligenceMicroStrategy Packages for Python
    MicroStrategy WorkstationMicroStrategy for Office
    MicroStrategy WebMicroStrategy Embedding SDK
    MicroStrategy LibraryMicroStrategy REST APIs
    MicroStrategy Library MobileData Sources
    MicroStrategy MobilePrivileges

    MicroStrategy HyperIntelligence

    MicroStrategy Workstation

    • Create and certify Python scripts.
    • Dedicated Python Script Gallery section with Python mstrio modules, sample Python scripts, Python code snippets, and built-in search for easy navigation.
    • Python Script Gallery tooltip with insight on how to use classes and functions, with usage examples.
    • A time series visualization that enables common financial and market analysis workflows.
    • A modern grid visualization that allows you to include microcharts within cells and support one-click contextual linking.
    • Add rich formatting to text boxes to create compelling infographic dossiers.
    • Intuitive Format panel with visual cues, organized into three consistent tabs for visualization or object specific options, text and form, and container. Collapsible folders and toggles make it easy to find what you're looking for.
    • Edit panel stacks with an intuitive tree structure in the Layers panel, use filters outside panel stacks to target dynamic text boxes, and copy and move panel stacks across chapters and pages.
    • Panels in dossier panel stacks are executed on demand to improve performance.
    • Create and edit schedules.
    • Manage and monitor jobs.
    • Change ownership of subscriptions.
    • Create, edit, and manage security filters.
    • View component and dependent objects.
    • Create multiple types of objects such as filters, metrics, prompts, security filters, attributes, and facts in one place. To access this functionality, open the main Workstation window and click next to Objects.
    • View and edit Library Administration settings in Workstation.

    MicroStrategy Web

    • A time series visualization that enables common financial and market analysis workflows.
    • A modern grid visualization that allows you to include microcharts within cells and support one-click contextual linking.
    • Add rich formatting to text boxes to create compelling infographic dossiers.

    • Intuitive Format panel with visual cues, organized into three consistent tabs for visualization or object specific options, text and form, and container. Collapsible folders and toggles make it easy to find what you're looking for.

    • Edit panel stacks with an intuitive tree structure in the Layers panel, use filters outside panel stacks to target dynamic text boxes, and copy and move panel stacks across chapters and pages.

    • Panels in dossier panel stacks are executed on demand to improve performance.

    • Basic OIDC authentication support.
    • The Admin pages support basic authentication when SAML authentication is enabled for Web.

    MicroStrategy Library

    • Enhanced OIDC authentication workflows for automatic and seamless login.
    • A time series visualization that enables common financial and market analysis workflows.
    • A modern grid visualization that allows you to include microcharts within cells and support one-click contextual linking.
    • Add rich formatting to text boxes to create compelling infographic dossiers.
    • Panels in dossier panel stacks are executed on demand to improve performance.
    • Enhanced accessibility with a new F6 keyboard shortcut allowing for quick navigation between regions.
    • Improved ability to navigate throughout Dossier containers in a logical order using screen readers and keyboard controls.

    MicroStrategy Library Mobile

    iOS

  • Improved graph readability with y-axis word-wrap, nested labels, and bar chart label positioning.

    • Android

    Panels in dossier panel stacks are executed on demand to improve performance.

    iOS and Android

    • Enhanced OIDC authentication workflows for automatic and seamless login.
    • A time series visualization that enables common financial and market analysis workflows.
    • A modern grid visualization that allows you to include microcharts within cells and support one-click contextual linking.
    • Add rich formatting to text boxes to create compelling infographic dossiers.

    MicroStrategy Mobile

    iOS and Android

    Basic OIDC authentication support.

    MicroStrategy Packages for Python (mstrio-py)

    • A new Schedule class in the mstrio.distribution_services.schedule subpackage.
    • A new ScheduleTime class in the mstrio.distribution_services.schedule subpackage, which is a local object used for specifying time related properties of schedule.
    • A new Event class in the mstrio.distribution_services.event subpackage.
    • The Subscription class has been modified to use Schedule objects.
    • A new datasources subpackage with Dbms, DatabaseConnections, DatasourceInstance, DatasourceLogin, DatasourceMap classes covering database management functionality.
    • New list_available_dbms, list_datasource_connections, list_datasource_instances, list_datasource_logins, and list_datasource_mappings functions that list all data source related objects.
    • A database_connections module that allows you to browse and manage database connections to the environment.
    • New ACL management functionality for all supporting objects by adding list_acl, acl_add, acl_remove, and acl_alter methods.
    • A SecurityFilter class and list_security_filters function in the mstrio.access_and_security.security_filter subpackage
    • A new Qualification class in the mstrio.access_and_security.security_filter subpackage, which is an object used to represent a security filter qualification.
    • New PredicateBase, PredicateForm, PredicateElementList, PredicateFilter, PredicateJointElementList, and LogicOperator classes in the mstrio.access_and_security.security_filter subpackage to represent predicates that can be used when creating a security filter qualification.
    • New ParameterBase, ConstantParameter, ObjectReferenceParameter, ExpressionParameter, PromptParameter, DynamicDateTimeParameter, and ConstantArrayParameter classes in the mstrio.access_and_security.security_filter subpackage to represent the parameters used in AttributeForm.
    • mstrio.admin.schedule has been replaced with the mstrio.distribution_services.schedule subpackage.
    • The schedules_id argument has been replaced by schedules in the create and alter methods of the Schedule class.
    • mstrio.distribution_services.schedule.ScheduleManager has been replaced with mstrio.distribution_services.schedule.list_schedules().

    See the mstrio-py help for more information.

    MicroStrategy for Office

    Generate the manifest file for the MicroStrategy for Office add-in from MicroStrategy Web.

    MicroStrategy Embedding SDK

    MicroStrategy REST APIs

    Data Sources

    See Platform Certifications for information about the latest supported and certified configurations.

    1. New Gateways
    2. OOTB Driver Updates

      • Exasol ODBC and JDBC drivers are shipped out-of-the-box.

    3. Security and Performance Enhancements

      • Oracle Cloud Wallet authentication files are supported end-to-end for Oracle Cloud environments.

      • Azure Active Directory is supported via SAML authentication tokens for Snowflake, Azure SQL Database (ODBC Driver), and Azure Synapse Analytics (ODBC Driver).

      • Azure Active Directory is supported via OIDC tokens for Snowflake, Google BigQuery, Azure SQL Database (ODBC Driver), and Azure Synapse Analytics (ODBC Driver).

      • Google Cloud Storage supports authentication via OAuth and Service Account workflows.

    4. Functionality Enhancements

      • Financial Force, Veeva CRM, and ServiceMax have been integrated through the Salesforce Connector.

    Privileges

    See Privileges by License Type for information about license types and associated privileges.

    The following privileges have been added to the Server - Intelligence license:

    • Create and edit content bundles

    • Certify Python Script

    The following privileges have been added to the Architect license:

    • Create package

    • Apply package

    2021 Update 1 (May 2021)

    Workstation

    Federated Analytics

    MicroStrategy Packages for Python (mstrio-py)

    • Modified file structure to organize modules in clean and readable way.
    • New and improved type hints across the code base.
    • New PrivilegeMode, IdleMode, GroupBy, ServiceAction, Rights, and Permissions enums.
    • A new Node class to be used for node management in place of a raw dict.
    • A new CubeCache class added to the mstrio.application_objects.datasets subpackage.
    • The load_cube method can load cubes by name.
    • New list_cube_caches, delete_cube_caches, and delete_cube_cache functions.
    • New create, update, get_sql_view, and publish methods for the OlapCube class.
    • A new unpublish method for the OlapCube and SuperCube classes.
    • A new list_reports function for the Report module.
    • New alter and list_properties methods for the Report class.
    • The id parameter replaces the report_id parameter in the Report class.

    See the mstrio-py help for more information.

    2021 Update 1 (April 2021)

    MicroStrategy Workstation

    Create and edit value prompts.

    Federated Analytics

    MicroStrategy Packages for Python (mstrio-py)

    • The following have been added:

      • SuperCube and OlapCube in the mstrio.application_objects.datasets subpackage
      • list_all_cubes, load_cube, list_super_cubes, and list_olap_cubes functions that allow you to search for cubes by name and construct precise objects
      • user_id, user_full_name, user_initials to the Connection class
      • trust_id and database_auth_login parameters in the user.alter() method
      • More Cube object attributes similar to other MicroStrategy objects
    • Alter the name, description, and abbreviation properties of cubes.

    See the mstrio-py help for more information.

    2021 Update 1 (March 2021)

    MicroStrategy HyperIntelligenceMicroStrategy Mobile
    MicroStrategy WorkstationMicroStrategy Library Mobile SDK
    MicroStrategy WebMicroStrategy REST APIs
    MicroStrategy LibraryMicroStrategy Cloud Platform
    MicroStrategy Library MobileData Sources
    MicroStrategy Intelligence ServerPrivileges

    MicroStrategy HyperIntelligence

    • Performance and stability are optimized for HyperIntelligence cards that are enabled with pattern matching:
      • Improved pattern detection and card rendering performance on HyperWeb and HyperOffice for 8-10 million rows of data.
      • Decreased loading time when authoring a card based on a large dataset in MicroStrategy Workstation.
      • Improved speed when enabling a card on the HyperWeb extension.
    • Control text alignment when formatting card widgets.

    MicroStrategy Workstation

    MicroStrategy Web

    • New Sankey Diagram visualization to compare data flow is available in the Custom area of the Visualization Gallery.
    • Add panel stacks from the top toolbar to enable additional flexibility on analytics workflows, while optimizing the use of screen real estate.
    • Improved graph readability with y-axis word-wrap, nested labels, and bar chart label positioning.
    • Drop-down selectors in documents support multi-selection.
    • New dossier and document property that allows the author to choose the default open state of the content in Library as Last Viewed or Last Saved.
    • Enhanced sharing workflow that enables search to return all users and user groups that contain the key term.

    MicroStrategy Library

    • Select the default open state of dossiers and documents in Library as Last Viewed by the end user or Last Saved by the author (reset to original view).
    • Drop-down selectors in documents support multi-selection.
    • SAML Admin Groups govern the Library admin pages when SAML authentication is enabled.

    MicroStrategy Library Mobile

    iOS

    • Download and view Excel and CSV files with native in-app support.
    • Select the default open state of dossiers and documents in Library as Last Viewed by the end user or Last Saved by the author (reset to original view).
    • Select and copy individual grid cells contents and URLs to the clipboard.
    • New Waterfall chart supports Show Difference and Show Sum modes to display data intuitively, as well as an option to hide or show the connection line.
    • Enhanced Pie and Ring charts with optimized use of container blank space, improved data labels with leader lines, and option to show percentage.
    • Sort Pie and Ring charts in ascending and descending order.
    • Hide or show the Metrics header text in a grid visualization.
    • Use compound grid visualizations to filter data in other visualizations.
    • Certification of native integration with Intune and AppConfig compliance.
    • Drop-down selectors in documents support multi-selection.

    Android

    • Use a document or dossier as the home screen to build powerful mobile experiences.
    • Select the default open state of dossiers and documents in Library as Last Viewed by the end user or Last Saved by the author (reset to original view).
    • Select and copy individual grid cells contents and URLs to the clipboard.
    • New Waterfall chart supports Show Difference and Show Sum modes to display data intuitively, as well as an option to hide or show the connection line.
    • Enhanced Pie and Ring charts with optimized use of container blank space, improved data labels with leader lines, and option to show percentage.
    • Sort Pie and Ring charts in ascending and descending order.
    • Hide or show the Metrics header text in a grid visualization.
    • Use compound grid visualizations to filter data in other visualizations.
    • Drop-down selectors in documents support multi-selection.

    MicroStrategy Intelligence Server

    • Memory usage breakdown information is logged in the DSSErrors.log to help troubleshoot Memory Contract Manager denial state or shut down due to an extended timeout limit of the denial state.

    • Improved cube loading time by up to 50% through persisting and loading attribute indexes from disk. See KB48489 for more information.

    MicroStrategy Mobile

    iOS

    Support for native integrations with AirWatch, MobileIron, BlackBerry Dynamics, and AppConfig compliance.

    Android

    Support for native integrations with AirWatch and AppConfig compliance.

    MicroStrategy Library Mobile SDK

    Preconfigure Library Mobile for Android.

    MicroStrategy REST APIs

    MicroStrategy Cloud Platform

    Improvements to MicroStrategy Backup and Restore (MSTRBak) to aid in the process of migrating customers into MicroStrategy Cloud, including:

    Data Sources

    See Platform Certifications for information about the latest supported and certified configurations.

    1. Gateway Certifications
      • Oracle Cloud 21c
      • Exasol 6.2
      • Exasol 7.0
    2. OOTB Driver Updates
      • The latest drivers for SQL Server, IBM Db2, MongoDB, and Salesforce gateways are out-of-the-box, optimizing security and performance.
    3. Functionality Enhancements
      • Set the Max Metric Alias Size VLDB property for the following gateways:
        GatewayMax Metric Alias Size

        SQL Server 2012

        SQL Server 2014

        SQL Server 2016

        SQL Server 2017

        SQL Server 2019

        		128

        Azure Synapse

        		128

        Db2

        		128

        PostgreSQL

        63

        Oracle 12c30

        Oracle 12cR2

        Oracle 18c

        Oracle 19c

        Oracle 21c

        128

        Redshift

        127

        Teradata 15.x

        Teradata 16.x

        Teradata 17

        128

        Google BigQuery128

        Snowflake

        256

    Privileges

    See Privileges by License Type for information about license types and associated privileges.

    The Use Hyper SDK privilege is required to use Hyper SDK. See KB484951 for more information.

    The Use Freeform SQL Editor privilege has been migrated from the Client - Architect license to the Server - Intelligence license. You can grant this privilege to the user and it won't occupy a Client - Architect license. Although it is listed under Client-Architect in the User Editor, it is mapped to the Intelligence license when the Intelligence server does a compliance check.

    The Enable on-premise data access via gateway agent privilege has been added to the Server - Intelligence license.

    2021 Platform (February 2021)

    MicroStrategy HyperIntelligence

    Ability to support and enforce mobile security policies through any EMM platform that supports the AppConfig standards on HyperMobile for Android.

    MicroStrategy Workstation

    Data Sources

    See Platform Certifications for information about the latest supported and certified configurations.

    New SAP ECC Data Gateway.

    MicroStrategy Library Mobile SDK

    Preconfigure Library Mobile for Android.

    2021 Platform

    MicroStrategy DesktopMicroStrategy Integrity Manager
    MicroStrategy HyperIntelligenceMicroStrategy Mobile
    MicroStrategy WorkstationMicroStrategy Library Mobile SDK
    MicroStrategy WebMicroStrategy Mobile SDK
    MicroStrategy LibraryMicroStrategy Visualization SDK
    MicroStrategy Library MobileMicroStrategy Embedding SDK
    MDXMicroStrategy REST APIs
    Federated AnalyticsMicroStrategy Cloud Platform
    MicroStrategy for OfficeInstallation
    MicroStrategy Intelligence ServerData Sources
    MicroStrategy Platform AnalyticsPrivileges

    MicroStrategy Desktop

    MicroStrategy 2021 does not include a separate Desktop application. Soon, Workstation will be available to use for free, offline workflows, just as Desktop previously worked. Advanced functionality in Workstation will only be enabled when you connect to a MicroStrategy environment.

    MicroStrategy HyperIntelligence

    • Create and apply thresholds to the card header.
    • Support for derived metrics on the card editor.
    • Ability to replace datasets without sacrificing card design on the card editor.
    • Embed HyperIntelligence on web-based applications using Hyper SDK.

    • Ability to support and enforce mobile security policies through any EMM platform that supports the AppConfig standards on HyperMobile for iOS.

    MicroStrategy Workstation

    • Improved performance when using percentile functions. See KB484742 for more information.
    • Enhanced formatting properties when creating documents.

    • Dossier enhancements, including:

      • Create dossier-level filters to filter data across multiple chapters or an entire dossier.
      • Visualization Gallery moved to top toolbar to showcase nine new one-click Bar charts, three new one-click Line/Area charts, and provide more authoring space.
      • Compare two or more metric values in a Bar chart using a common scale with the new Synchronized Axis Bar chart or right-mouse-clicking on a dual-axis chart.
      • Enhanced Pie and, new out-of-the-box, Ring chart with optimized use of container blank space, improved data labels with leader lines, and option to show as a percentage.

      • Allow multiple selections for data labels in pie, circle, and bar charts.

      • Sort pie and ring charts in ascending or descending order.
      • New Waterfall chart supports Show Difference and Show Sum modes to display data intuitively, as well as an option to hide or show the connection line.

      • Build Geospatial Service visualizations with the following new styles:

        • Border: Display only geographic borders and no terrain details. Use a background color or image to make the data pop.
        • Focused: Focus only on the geographic area where you have data, without surrounding areas distracting the view.
      • New Format panel option to disable panning, zooming, tilting, and rotating of Geospatial Service visualizations.
      • New Format panel option to disable the Geospatial Service visualization toolbar.
      • Sort and filter the attributes/metrics in the Dataset panel with new one-click filtering options for derived metrics, geo-attributes, unused objects, objects used on selected visualization, and more.
      • Create dynamic default filters based on the First N / Last N element(s).
      • Support passing filter selections and answer prompts while linking from text boxes and images.
      • Change the fill color opacity for text boxes, grids, and containers to customize transparency.
      • Add shapes to the canvas from the top toolbar to visually group elements, help frame a visualization, or create a layered effect.
      • Smarter labels for most visualizations to improve readability and design.
      • Additional visualization formatting flexibility through x-axis label rotation and word wrap.
      • Enhanced grid sorting to support working with totals, as well as allowing users to specify nested, absolute, and level grid sorting on metrics.
      • Hide or show the Metrics header text in a grid visualization.
      • Select and copy individual grid cells contents and URLs to the clipboard.
      • Customize the position of hierarchical attribute parent elements above or below child elements in grids. This feature only applies to MDX/OLAP sources for hierarchy reporting.
      • Import measures as regular dimensions when using Oracle Essbase MDX/OLAP sources for hierarchy reporting.

      • Support a new MDX/OLAP data source of Kyvos 2020.2.4 for hierarchy reporting.

      • Add metrics to rows in compound grids.
      • Use compound grid visualizations to filter data in other visualizations.
      • Enable vertical scrolling in free-form layout dossiers.
      • Hide or show visualization containers for mobile views in free-form layout.
      • Use the keyboard to move and delete, disable auto-snapping, and select all layers under free-form layout dossiers.
      • Export dossiers to PDF while in presentation mode.

    MicroStrategy Web

    • Export hierarchy reports to Excel with the hierarchy structure and levels preserved.
    • A new feature flag called Customize the Position of Parent Elements appears on the General Preferences page. Administrators can turn on this feature flag to allows users to customize the position of hierarchical attribute parent elements above or below child elements in dossier grids. The default setting is Off.
    • Improved performance when using percentile functions. See KB484742 for more information.

    • Dossier enhancements, including:

      • Create dossier-level filters to filter data across multiple chapters or an entire dossier.
      • Visualization Gallery moved to top toolbar to showcase nine new one-click Bar charts, three new one-click Line/Area charts, and provide more authoring space.
      • Compare two or more metric values in a Bar chart using a common scale with the new Synchronized Axis Bar chart or right-mouse-clicking on a dual-axis chart.
      • Enhanced Pie and, new out-of-the-box, Ring chart with optimized use of container blank space, improved data labels with leader lines, and option to show as a percentage.

      • Allow multiple selections for data labels in pie, circle, and bar charts.

      • Sort pie and ring charts in ascending or descending order.
      • New Waterfall chart supports Show Difference and Show Sum modes to display data intuitively, as well as an option to hide or show the connection line.

      • Build Geospatial Service visualizations with the following new styles:

        • Border: Display only geographic borders and no terrain details. Use a background color or image to make the data pop.
        • Focused: Focus only on the geographic area where you have data, without surrounding areas distracting the view.
      • New Format panel option to disable panning, zooming, tilting, and rotating of Geospatial Service visualizations.
      • New Format panel option to disable the Geospatial Service visualization toolbar.
      • Sort and filter the attributes/metrics in the Dataset panel with new one-click filtering options for derived metrics, geo-attributes, unused objects, objects used on selected visualization, and more.
      • Create dynamic default filters based on the First N / Last N element(s).
      • Support passing filter selections and answer prompts while linking from text boxes and images.
      • Change the fill color opacity for text boxes, grids, and containers to customize transparency.
      • Add shapes to the canvas from the top toolbar to visually group elements, help frame a visualization, or create a layered effect.
      • Smarter labels for most visualizations to improve readability and design.
      • Additional visualization formatting flexibility through x-axis label rotation and word wrap.
      • Enhanced grid sorting to support working with totals, as well as allowing users to specify nested, absolute, and level grid sorting on metrics.
      • Hide or show the metric header text in a grid visualization.
      • Select and copy individual grid cells contents and URLs to the clipboard.
      • Customize the position of hierarchical attribute parent elements above or below child elements in grids. This feature only applies to MDX/OLAP sources for hierarchy reporting.
      • Import measures as regular dimensions when using Oracle Essbase MDX/OLAP sources for hierarchy reporting.

      • Support a new MDX/OLAP data source of Kyvos 2020.2.4 for hierarchy reporting.

      • Add metrics to rows in compound grids.
      • Use compound grid visualizations to filter data in other visualizations.
      • Enable vertical scrolling in free-form layout dossiers.
      • Hide or show visualization containers for mobile views in free-form layout.
      • Use the keyboard to move and delete, disable auto-snapping, and select all layers under free-form layout dossiers.
      • Export dossiers to PDF while in presentation mode.
    • Enhanced security when using the MicroStrategy Connector. To take advantage of the improved MicroStrategy Connector, enable CORS settings on your Library Server.

    MicroStrategy Library

    • Share bookmarks to keep your team updated with more in-depth insights.
    • Collaborate with direct messages that allow users to start discussions with individuals or groups.
    • Search for objects both inside and outside of Library with global search.
    • Add dossiers or documents to the Favorites section for quick navigation.
    • Create uniquely named and personalized groups to organize content.
    • Enable or disable the view of the Comments and Discussion panel across environments.
    • Improved PDF generation response time when exporting from a dossier.
    • Select and copy individual grid cells contents and URLs to the clipboard.
    • Export dossiers with table of contents and grid pagination.
    • Enable auto-fit for column width when exporting a document or dossier grid to Excel.
    • Enhanced grid sorting to support working with totals, as well as allowing users to specify nested, absolute, and level grid sorting on metrics.
    • Customize the position of hierarchical attribute parent elements above or below child elements in grids. This feature only applies to MDX/OLAP sources for hierarchy reporting.
    • Export hierarchy reports to Excel with the hierarchy structure and levels preserved.
    • Improved color contrast with a more accessible primary blue and overall color palette
    • Seamlessly re-direct Library sessions to a healthy node when the current Intelligence server node is hanging or crashing.
    • Allow the Library server to communicate with the MicroStrategy Modeling service when auto-configuration has failed.

    MicroStrategy Library Mobile

    iOS

    Android

    • Support for tap, tap and hold, and double tap touch gestures.
    • Support for swiping gestures between dossiers pages.
    • Support for multi-select touch gestures to select multiple objects.
    • Share bookmarks to keep your team updated with more in-depth insights.
    • Collaborate with direct messages that allow users to start discussions with individuals or groups.
    • Search for objects both inside and outside of Library with global search.
    • Supports Android OS 11.
    • Deep link to Library from other applications.
    • Export dossiers with table of contents and grid pagination.
    • Customize the position of hierarchical attribute parent elements above or below child elements in grids. This feature only applies to MDX/OLAP sources for hierarchy reporting.

    MDX

    Federated Analytics

    MicroStrategy for Power BI

    • Improved import performance.
    • Import data in your defined locale.

    MicroStrategy for Tableau

    • Improved import performance.
    • Use the suggested default MicroStrategy Library URL.

    MicroStrategy for RStudio

    RStudio Server Open Source Edition 1.2 is certified.

    MicroStrategy Packages for Python (mstrio-py)

    • Support for standard and LDAP authentication using a proxy server.
    • Manage server, server configuration, and cluster details.
    • Use Python modules to manage schedules and subscriptions.
    • Manage Library content, including dossiers and documents.
    • Use sample scripts to manage applications and create users, user groups, and user security.

    See the mstrio-py help for more information.

    MicroStrategy for Office

    • Import data from compound grid visualizations to Excel.
    • View imported object and source information such as prompt answers, filters, attributes, metrics, owner, certification status, last modified date, etc., of imported data in the add-in side panel.
    • Select a new import destination if the original selected range is unavailable.
    • Support for OIDC authentication for Azure.

    MicroStrategy Intelligence Server

    MicroStrategy Platform Analytics

    Configure Platform Analytics to use a custom respository database name.

    MicroStrategy Integrity Manager

    New modern, user-friendly page for SQL comparison in dossiers, documents, and reports.

    MicroStrategy Mobile

    iOS

    • Supports iOS 14.
    • Supports AppConfig with iOS 14.

    MicroStrategy Library Mobile SDK

    iOS

    Android

    • The Library Mobile SDK for Android is certified to work with Android 11 (API level 30). When you customize Library Mobile for Android, you must have Android SDK 30 to develop and compile your application. Android Studio 3.6 and up is supported.

    • Deep link to Library from other applications.

    MicroStrategy Mobile SDK

    iOS

    When you customize MicroStrategy Mobile SDK for iOS, you must have an Apple Mac, running Xcode® 12.0 with the Apple iOS SDK 14, to develop and compile your application.

    Android

    The MicroStrategy Mobile SDK for Android is certified to work with Android 11 (API level 30). When you customize MicroStrategy Mobile for Android, you must have Android SDK 30 to develop and compile your application. Android Studio 3.6 and up is supported.

    MicroStrategy Visualization SDK

    Configure the display of the Change Visualization context menu.

    MicroStrategy Embedding SDK

    MicroStrategy REST APIs

    • Identify applications to load on server startup.
    • Manage filter objects.
    • Create and edit email subscriptions.
    • List available recipients for a given user, including Shared List and Personal Addresses.
    • Execute a single subscription on demand.
    • Create, update, and delete schedules.
    • Manage data sources with a complete set of REST APIs.
    • Ability to request DateTime data to be returned from reports, cubes, and dossiers in the ISO 8601 format.
    • Ability to update page-by selections for reports.
    • Enhancement to APIs returning data from reports and cubes to allow the modification of attribute and metric template positioning.
    • Enhancement to APIs that execute reports, cubes, and dossiers to allow the request for asynchronous executions.
    • Monitor and manage cubes. This includes viewing and changing the status of a cube.
    • Additional server and application level settings from MicroStrategy Developer are available in MicroStrategy Workstation.
    • Ability to request object lineage information.
    • Create, list, and delete multi-content subscriptions.

    MicroStrategy Cloud Platform

    Improved scalability of deployments across AWS and Azure, including:

    • A new One-Node Enterprise deployment type for production-quality single node deployments that leverage scalable file storage and high availability MD instances
    • The availability of one-click hotfix upgrades to M2019 Update 7 and M2020 Update 3
    • The ability to stop/start/resize individual nodes within a cluster for improved vertical scalability

    Amazon Web Services (AWS)

    Security enhancements, including:

    • Option to deploy environments with only Private IPs
    • Automatic, default SSL encryption between I-server and Web server in MCP deployments for 11.3 and beyond
    • Improved load balancer encryption to TLS 1.2 protocol

    Enhanced global availability of MCP deployments recently expanding into the following regions:

    • Middle East (Bahrain)
    • Canada Central
    • Sao Paulo
    • EU (Stockholm)

    Azure

    Security enhancements, including:

    • Option to deploy environments with only Private IPs
    • Automatic, default SSL encryption between I-server and Web server in MCP deployments for 11.3 and beyond
    • Improved load balancer encryption to TLS 1.2 protocol

    Enhanced global availability of MCP deployments recently expanding into the following regions:

    • South Central US (Texas)
    • Canada Central
    • Asia Southeast
    • Japan East
    • South Africa (North)

    Installation

    • The Windows and Linux debug installation log file MSTRInstall.log has been renamed to MSTRDebugInstall.log to help distinguish it from the high-level install.log. Additionally, the file has been moved to the Log directory to centralize all log collection.
    • The MicroStrategy Repository is an independent component that can selected for use during installation for Platform Analytics and Collaboration server. If you want to use your own certified Postgres database, or if you have already installed the MicroStrategy Repository on another machine, a new screen allows you to connect to a remote repository instead.
    • Administrators can use the Recheck button for Windows and Linux installations when missing requirements are identified. Now, the requirements can be installed, and without leaving the same installer screen, administrators can recheck these requirements and proceed when they have all been satisfied.
    • MicroStrategy supports and bundles Adopt OpenJDK11 with the Linux and Windows platform installers. Fresh installations or upgrades to 2021 are automatically upgraded, with no further action needed. For your hosted J2EE web application servers, you must upgrade to JDK11 before deploying the new 2021 WAR files. You may also use Oracle JDK11, which is supported.

    Data Sources

    See Platform Certifications for information about the latest supported and certified configurations.

    1. Gateway Certifications

    2. New Gateways

      • New Cloud Object Storage Connector supporting AWS S3, Azure Data Lake Storage Gen2 and Google Cloud Storage for files in Parquet, Avro, and ORC formats.
      • New Gateway Connectors for Kyvos, Yellowbrick, IBM Integrated Analytics System (IAS).
      • New OData Connectors for SAP S/4 HANA, SAP BW/4 HANA.
      • Azure SQL Data Warehouse is Azure Synapse Analytics and is certified with MicroStrategy. See the Microsoft documentation for more information.

    3. OOTB Driver Updates

      • Teradata drivers are bundled out-of-the-box with MicroStrategy installation (Teradata Driver 17).
      • Snowflake drivers are bundled out-of-the-box with MicroStrategy installation (Snowflake Driver 3.12.11 (JDBC) and 2.21.2 (ODBC)).
      • SAP Hana Drivers are bundled out-of-the-box with MicroStrategy installation (SAP Hana Driver 2.6).
      • MicroStrategy 2021 ships the latest drivers for all gateways MicroStrategy shipped out-of-the-box optimizing security and performance.

    4. Gateway Deprecation

    5. Security and Performance Enhancements

      • Support Kerberos, certificate-based authentication, and scram-sha-256 for password encryption of PostgreSQL. See KB484539, KB484540, and KB484541 for more details.
      • TLS configuration is supported in GUI and command line mode for all gateways that MicroStrategy ships out-of-the-box in the Connectivity Wizard. (SAP HANA excluded) See KB42495 for more information.
      • Secure SQL Execution using parameterized queries has been enabled by default for the following data sources: Amazon Redshift, IBM Db2, Oracle, Teradata, PostgreSQL, SAP HANA, Snowflake, Google BigQuery, MySQL, Yellowbrick, MemSQL, IBM IAS, IBM IPS, IBM Netezza, and Amazon Aurora PostgreSQL Compatible. See KB484512 for more information.
      • Implement unified quoting with Diamond and Platinum gateways as well as select gold gateways - PostgreSQL, Amazon Aurora PostgreSQL, Yellowbrick, IBM Integrated Analytics System, IBM Netezza, and IBM Performance Server for PostgreSQL.
      • The calculation of the DateDiff function has been pushed to the gateway side for SQL Server, Azure Synapse Analytics, and Amazon Redshift. To incorporate this change, you must update your metadata and schema. This change increases performance when executing reports and live dossiers or when publishing cubes against SQL Server or Amazon WH when DateDiff calculations are used.
      • The calculation of the Percentile function has been pushed to the gateway side for all Diamond and Platinum data sources. To incorporate this change, you must update your metadata and schema. This change increases performance when executing reports and live dossiers or when publishing cubes when Percentile calculations are used.
      • Snowflake - Improved live connections (report/cube) throughput performance by up to three times by updating the default Intermediate Table Type to Derived Table.

    6. Functionality Enhancements

      • Extended Connectivity Wizard DSN creation for Google BigQuery, Apache Spark SQL, Hive, Impala, Teradata, and Snowflake.
      • Google BigQuery gateway supports billing project and catalog browsing by namespace.
      • Seamless Authentication for JDBC and ODBC drivers leveraging OAuth workflow. For example, Snowflake and Google BigQuery.
      • New report searching functionality for Salesforce Report gateway connector. See KB484556 for more information.
      • Network proxy support for MicroStrategy Community Connectors.
      • Support HTTP connection (proxy connection) for relational gateways.

    Privileges

    See Privileges by License Type for information about license types and associated privileges.

    A few privileges have been migrated between license groups.

    • The following privileges have been moved from Client-Web to Client-Reporter:
      • Web add to History List
      • Web execute datamart report
    • The following privileges have been moved from Server-Intelligence to Server-Reporter:
      • View History List
      • Save personal prompt answers
    • The following privilege has been moved from Client-Web to Server-Distribution:
      • Web subscribe to History List