MicroStrategy ONE

End of Support for R Integration Pack

Starting in December 2024, all current versions of MicroStrategy will no longer support the R Integration Pack and it will move to Unsupported status from Maintenance Development status. The R Integration Pack installer downloads the latest version of R, which is incompatible with the MicroStrategy ONE platform. R does not support fetching older R versions due to a security vulnerability and therefore, MicroStrategy can no longer support the R Integration Pack.

MicroStrategy supports Python for many of the same data analysis, statistical computing, and integration workflows that were previously supported by the R Integration Pack. MicroStrategy continues to invest in integrating Python with the MicroStrategy platform.

Functionality of Python Scripts in MicroStrategy

Statistical Analysis:

Users can perform statistical analysis using Python libraries such as Pandas, NumPy, and SciPy. These libraries provide extensive functionalities for data manipulation, statistical modeling, and analysis.

Machine Learning:

Users can implement machine learning algorithms using libraries like Scikit-learn or TensorFlow. This allows for predictive analytics and advanced data modeling directly within the MicroStrategy environment.

Integration with mstrio Library:

The mstrio-py library can be used to interact with MicroStrategy's REST API, allowing users to automate tasks, retrieve data, and manage objects within MicroStrategy using Python scripts.

Script Management:

MicroStrategy ONE provides a dedicated Scripts section in Workstation where users can create, manage, and execute Python scripts. This includes features like auto-completion, tooltips, and a gallery of sample scripts to assist users.

Python Data Source:

Users can use Python as a data source in MicroStrategy. To set up a Python data source, users follow the same process as other data sources but write a python script instead of a SQL query. Python data sources in MicroStrategy enable users to handle complex data integration and processing tasks.

Actions:

Dashboard creators can use a standard Python or transaction Python script to configure action buttons in modern grids. Users can then add these buttons to a column and trigger actions defined in the associated Python script for the corresponding row.

To learn more about the capabilities of Python in MicroStrategy, and for more information on transitioning from the unsupported R Integration Pack, contact your account team or MicroStrategy Support.