Version 2021

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.6 or later for Mac or Windows.
  • Jupyter Notebook

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

mstrio-py requires urllib3 in version 1.25.2 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 applications 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, UPDATEUPSERT, or REPLACE for each dataframe.
  6. Click Publish.

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