MicroStrategy ONE

Answer Prompts

Starting in MicroStrategy 2021 Update 12, you can reuse prompt answers across multiple objects while importing content via the MicroStrategy add-in for Excel. Users can reprompt single or multiple imported objects and allow for the memorization and reuse of prompt answers when importing new objects.

Starting in MicroStrategy ONE (September 2024), if you reprompt multiple objects that have reuse prompt answers turned on, all objects that use the same prompt (based on object ID) will be automatically reprompted. You will not have to answer a prompt for each object.

Enable the Reuse of Prompt Answers

Starting in MicroStrategy ONE Update 12, the MicroStrategy for Excel Add-in provides an enhanced import experience with support for re-usable prompt answers. Settings controlling the display of object information can be configured in Prompt Settings.

Starting in MicroStrategy ONE (June 2024) you can customize your import experience with Import Settings, Object Information Settings and Page-by Settings.

Limitations

  • Users cannot reuse prompt answers for nested prompts.

  • The add-in only supports reused answers with the same prompt (same object ID). Ensure the same prompt object is used so the answer can be reused.

  • Users cannot reuse the same answer across multiple workbooks.

  • When reprompting multiple objects, the reprompt process stops once an error occurs. This can happen if an object returns no data or a cube is not published.