Version 2021

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 for Jupyter

MicroStrategy for Jupyter enables the data scientist to import MicroStrategy data into Jupyter Notebook and export dataframes to MicroStrategy as an in-memory dataset.

 

MicroStrategy for Jupyter requires MicroStrategy 2019 Update 4 or later.

You must enable CORS (Cross-Origin Resource Sharing) settings on the Library server to use the connector.

The following must be installed to use MicroStrategy for Jupyter:

  • Python 3.10 for Mac or Windows
  • Jupyter Notebook

MicroStrategy for Jupyter is not supported on Jupyter version 7 and newer.

It is recommended that you install Jupyter and mstrio-py within a Python virtual environment.

mstrio-py requires urllib3 in version 1.26.0 or higher. If an older version is installed on your machine, upgrade it manually using pip install --upgrade urllib3 inside your virtual environment.

Install mstrio and the MicroStrategy for Jupyter Extension

  1. To install mstrio, open a command prompt and run the following command:

    pip install mstrio-py

  2. Install and enable the Jupyter Notebook extension:

    jupyter nbextension install connector-jupyter --py --sys-prefix

    jupyter nbextension enable connector-jupyter --py --sys-prefix

  3. Launch Jupyter Extension by entering the following command in the command prompt:

    jupyter notebook

Connect to MicroStrategy

  1. From the toolbar, select the MicroStrategy for Jupyter extension.

  2. Log in to MicroStrategy for Jupyter:

Import MicroStrategy Data

  1. Select the MicroStrategy projects to display the datasets and reports available for import.
  2. Click OK.
  3. In the Import Data tab, select the data to import.
  4. Click Prepare Data.
  5. Select the attributes, metrics, and filters you want applied to your data for import.
  6. Click Import.

Export Data to MicroStrategy

  1. In the Export Data tab, click Create
  2. In the Available Dataframes panel, select the dataframes to export.
  3. Select the attributes and metrics to include for export.
  4. Click Next.
  5. In the Save as field, enter a name for the dataset.
  6. Browse to the destination folder or click New folder to create a destination for the export.
  7. To certify the dataset, select the Certify checkbox.
  8. Click Save.

Update Previously Created Datasets

Your modeled data structure must correspond to the structure of the cube you are updating.

  1. In the Export Data tab, select the dataset to update.
  2. Click Update.
  3. In the Available Dataframes panel, select dataframes to update your dataset with.
  4. Click Next.
  5. From the Update Policy drop-down, choose ADD, UPDATE, UPSERT, or REPLACE for each dataframe.
  6. Click Publish.

Jupyter and the Jupyter logos are trademarks or registered trademarks of NumFOCUS