MicroStrategy ONE

Import Page-by Reports

Starting in MicroStrategy ONE (June 2024), you can import page-by reports.

You can customize the import experience with Import Settings, Prompt Settings, and Page-by Settings.

  1. Connect to the MicroStrategy for Office add-in. MicroStrategy for Office opens in a side panel.
  2. Select a starting cell.
  3. Click Import Data.
  4. The import window appears which allows you to browse content in the Library Web view, where you can select source objects from the smart view or Content Discovery.
  5. Choose a report with defined page-by objects.
  6. Click Import or Prepare Data, if you want to refine the data.

  7. Use the drop-down to choose which metrics and attributes you want to import.

  8. Click Add to add the selected object or Add All to add all the available variations for page-by objects in your report.
  9. In the right pane, you can perform additional actions before importing:

    1. Drag and drop objects in the table to change the order of import.

    2. To delete objects from the import, select the check box next to an object and click Remove.

    3. Click Reset to clear the selection table.

  10. Click Import. Each selection imports into a separate Excel sheet.

  11. Imported objects display on the add-in side panel.

    Starting in MicroStrategy ONE (June 2024), imported content displays on the side panel based on the Excel sheet placement to support simplified content tracking.

  12. If you click an imported object, it becomes highlighted in the worksheet.

    You can also view your data's imported object and source details by expanding the Show Details drop-down.

See All Page-by Elements in Overview

You can view all page-by sections of your report in the Overview dialog.

  1. Connect to the MicroStrategy for Office add-in. MicroStrategy for Office opens in a side panel.
  2. Locate any of the imports for your page-by report.

  3. Open the object menu and click Show in Overview.

  4. The Overview dialog displays all page-by objects imported into Excel for your report.

Refresh and Delete Pages

You can refresh or delete all page-by sections in your report.

  1. Connect to the MicroStrategy for Office add-in. MicroStrategy for Office opens in a side panel.
  2. Locate any of the imports for your page-by report.

  3. Open the object menu:

    1. Click Refresh All Pages to refresh all page-by objects imported into Excel for your report.
    2. Click Delete All Pages to remove all page-by objects imported into Excel for your report.
    4.