Version 2021

MicroStrategy for RStudio

MicroStrategy for RStudio enables data scientists to import MicroStrategy data into RStudio and export dataframes to MicroStrategy as an in-memory dataset.

MicroStrategy for RStudio 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 RStudio:

  • R 3.4 or later for Mac or Windows from CRAN.
  • RStudio Desktop version 1.2 or later for Mac or Windows.

Install mstrio and the MicroStrategy for RStudio Addin

To install mstrio, run the following command in the RStudio console:

install.packages("mstrio")

Connect to MicroStrategy

  1. From the Addins drop-down, select MicroStrategy for RStudio.

  2. MicroStrategy for RStudio is displayed in the Viewer tab.

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 and OK.

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 and Save.

RStudio and Shiny are trademarks of RStudio, Inc.