MicroStrategy ONE

AI Interpretation and Execution

Bots and Auto Answers is supported in MicroStrategy Cloud environments and starting in MicroStrategy ONE (March 2024), Bots and Auto Answers is supported on the MicroStrategy Cloud for Government platform. You can only use Bots in MicroStrategy Library and Library Mobile apps.

Starting in MicroStrategy ONE (March 2024), AI interpretation and execution is available in Auto Answers and Bots. You can use AI interpretation and execution to make the AI decision-making process clear and offer users a view into the logic behind responses to empower casual and advanced users to understand and trust the AI responses.

Business users are consumers of analytics and dashboards, these users apply insights to drive critical business decisions. Their roles include positions such as CXOs, sales and planning managers, and marketing teams. For business users, AI execution and interpretation offers a clear explanation of how their queries are interpreted by the AI, using a rephrased version of the question to remove any ambiguities. It reassures users that the AI's log aligns with their expectations by consistently delivering similar results for repeated queries.

Power users are MicroStrategy experts who craft complex analytic dashboards and reports. Their roles include analysts and IT professionals. For power users, AI execution and interpretation provides an in-depth look into the answer construction process. They gain access to detailed insights into MicroStrategy components such as attributes, metrics, derived objects, filtering conditions, sort operations, and SQL logic that is used by the AI to create an answer. This level of transparency is instrumental for users who need to validate the AI process or troubleshoot AI results.

Check out the following topics to get started:

Enable AI Interpretation

Auto Answers

  1. Go to a dashboard.

  2. Click Edit.

  3. Choose File > Dashboard Properties.

  4. Click Auto in the left pane.
  5. In Enable Interpretation, select the checkbox next to Allow users to see how Auto Answers interpreted their question.

  6. After selecting the checkbox, interpretation is only available in dashboards where Auto Answers is enabled. For more information on enabling Auto Answers, see Use Auto Answers to Self Serve Insights

  7. Click OK.

Bots

  1. Go to a Bot.

  2. Click Edit.

  3. Click General.

  4. Toggle on Enable Interpretation.

  5. Click Save.

Access Requirements for AI Interpretation

Business users need the Web Run Dashboard privilege.

Power Users need the following privileges:

  • Web Edit Dashboard

  • Web Create Dashboard

  • Web Save Dashboard

Use Interpretation

  1. Open a Bot or open Auto Answers in a dashboard.

  2. Ask your Bot or Auto Answers a question.

  3. Hover over a response and click the Interpretation icon.

  4. The interpretation window expands and provides clear details on how your question was understood and processed by the Bot or Auto Answers.

Understand AI Interpretation

The insights included in the Interpretation window are dependent on your privileges.

For business users, the AI Interpretation window provides a clarified version of the original query. The Interpretation window rephrases the query to explain how the AI understands and addresses the question. For example, if you ask to identify the top three performing employees, the AI selects a specific metric. for example, Performance score, from possible options like Customer Satisfaction Score or New customers acquired. The AI then sorts the results in descending order for ease of analysis.

The following section and icon display in the Interpretation window for business users:

  • Interpreted as: This section displays a clarified version of the query to explain how the AI intends to address the question.
  • Ask Again: Click this icon to copy the query to the message field to ask it again or edit and ask it again.

In addition to the simplified interpretation, power users gain deeper insights into the query's execution. Using the same example above to identify top performing employees, power users are provided with a detailed view of the logic behind constructing the response.

The following sections appear in the Interpretation window for power users:

  • Interpreted as: This section displays a clarified version of the query to explain how the AI intends to address the question.
  • Components: This section displays a detailed view of the logic behind constructing the response. The detailed view encompasses MicroStrategy components such as attributes, metrics, chapter filters, and view filters, which illustrates the steps that lead to the response. For complex inquiries that require multi-step calculations, such as, "In each of the top 3 selling Categories, which Subcategory had the highest Revenue?", the components section outlines each calculation step and how they combine into the final answer table. This explanation enhances the power users' ability to validate AI functionality before broader release to their users.

The following icons appear in the Interpretation window for power users:

  • Ask Again: Click this icon to copy the query to the message field to ask it again or edit and ask it again.
  • Copy LLM Instructions: Click this icon to copy the detailed SQL generated by the AI to your clipboard. You can use the SQL to understand the analysis process and aid in data validation or troubleshooting.

  • The SQL is formulated considering the MicroStrategy dataset as a consolidated table and is designed for insight not direct database execution.

  • Hover your mouse over an icon in the Components section for a definition of the MicroStrategy object type used to generate the response.

Track AI Interactions in the Auto Adoption Dashboard

Use the Auto Adoption dashboard in Platform Analytics to review and troubleshoot queries that generate inconsistent or incomplete responses. Use the Last 30 Days page for a log of queries asked in Auto Answers and Bots including details such as date, user, feature used, the Bot or dashboard queried, the query, and it's execution time.

You can view details on a specific question or query for a comprehensive review if a response did not meet expectations. You can then use these details to make improvements and ensure the responses are continuously refined and accurate. You can review these details to determine whether changes to the query will enhance the outcome or if you need to contact MicroStrategy support

To view details on a specific question or query:

  1. Open the Auto Adoption Dashboard.
  2. In the Last 30 Days page, click an Auto Question.
  3. Click Review Question.

  4. An analysis appears with the interpretation of the question, LLM Response (SQL), and the MicroStrategy components used to generate the answer.

Related Topics

Create and Edit a Bot

Use Auto Answers to Self Serve Insights