Import Settings

MicroStrategy ONE (September 2024) enhances the Excel Add-in import experience with more detailed page and chapter settings.

Starting in MicroStrategy ONE (June 2024), you can define import settings such as preferred import type, attribute import form, and rules for column merges to improve your import experience.

When you import new data with a defined setting, that setting will apply if you use Refresh or Duplicate. Use a new Import, Edit, or Re-prompt option to import data with new settings.

1. Click More Itemsin the Excel add-in side panel and click Settings.

   

2. Expand the Import section and apply the following settings, as needed:

   • Default import format: Choose an import option from the drop-down.

     If the selected option is not valid for the object you want to import, the option will revert to Data.

     The chosen import type will be displayed by default but you can manually change the import type for every import

   • Chapter Name: Toggle on this setting to import the chapter name and in the Chapter name position drop-down, choose an option:

     • Before page name: Add the chapter name to the sheet name before the imported page name.

     • On top of sheet: Import the chapter name into cell A1 of the Excel sheet.

   • Import data as text: Toggle on this setting to import all attribute values as text.

   • Merge columns: Toggle on this setting to merge columns for all repeated values in cross-tab grids.

   • Positioning: Choose a positioning option from the drop-down:

     • Stacked: Adds visualizations under each other vertically.

     • Side by Side: Adds visualizations next to each other horizontally.

3. Close the Excel add-in.