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.

It is recommended that you install Jupyter and mstrio-py within a Python 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

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, UPDATE, UPSERT, or REPLACE for each dataframe.
6. Click Publish.

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