Auto Telemetry

Starting in MicroStrategy ONE (June 2024), the schema objects were updated to include feedback objects.

See the following schema objects that were updated MicroStrategy ONE Update 12 for the semantic graph of the Platform Analytics project:

Besides the schema objects listed below, you can use existing Account and Metadata attributes for custom reporting.

If you are using a version of MicroStrategy ONE previous to the most recent release, the following values may vary.

Object

Type

Description

lu_ai_assistant_category

table

This table stores all dedicated features of Auto (For example, Auto Dashboard).

fact_ai_chatbot_interactions

table

This table captures Auto questions submitted by users at the transactional level.

agg_fact_ai_chatbot_interactions table This table contains Auto questions at the daily level, which offers superior query performance.

Attributes/A13. Auto

folder

This folder contains all attributes related to Auto.

Auto Question attribute A call made to the Auto AI service to access its capabilities which typically involves sending input data to the service and receiving a corresponding output or result.

Feature

attribute

A dedicated feature of Auto that is designed to augment the MicroStrategy workflow.

Metrics/M10. Auto folder This folder contains all metrics related to Auto.
Facts/Auto folder

This folder contains all facts related to Auto.

Auto Question Timestamp

fact

A timestamp that indicates when an Auto Question was submitted to the Auto AI service.
Auto Question Processing Time (ms) fact

The time elapsed between when an Auto Question was submitted to the Auto AI service and when a response was received from the Auto AI service.

Number of Auto Questions

fact

The number of Auto Questions submitted to the Auto AI service.

Auto Active Users

metric

The count of users that used Auto.

Auto Question Processing Time (sec) metric The time elapsed between when an Auto Question was submitted to the Auto AI service and when a response was received from the Auto AI service.

Auto Questions Sent

metric

The count of Auto Questions that were submitted to the Auto AI service.

Auto Question Timestamp (UTC) metric A timestamp that indicates when an Auto Question was submitted to the Auto AI service in the UTC timezone.

Auto User Adoption Rate

metric

The percentage of users who used Auto to all active users.

Average Processing Time (sec) per Question metric The average time elapsed between when an Auto Question was submitted to the Auto AI service and when the response was received from the Auto AI service.

Average Questions per Day

metric

The average daily number of Auto Questions submitted by users.

Active Users

metric

The count of users who executed an object.

Auto Enabled Users metric Count of metadata users that have the "Auto Assistant and ML Visualizations" privilege enabled, as per the most recent license compliance check.

Overall Active Auto Users

metric (hidden)

The count of all users that used Auto, regardless of account filter.

Days of Using Auto metric (hidden) The number of days the Auto AI service has been used.
Auto Adoption dashboard A dashboard that contains telemetry, reflects on usage, and Question submission history for Auto.

See the following feedback objects that were added in MicroStrategy ONE (June 2024):

Object

Type

Description

fact_ai_questions_view

table

This view left joins fact_ai_chatbot_interactions, fact_ai_interpretation_details, and fact_ai_feedback_details to gather all relevant information about questions asked to Auto.

fact_ai_definitions_view

table

This view left joins fact_ai_chatbot_interactions with fact_ai_nugget_details to show which definitions were used to answer a question to Auto.

lu_ai_feedback_type table This lookup table maps feedback_type_ids with descriptions for types of feedback given (I.E. Thumbs Down) on Auto questions by users.

lu_ai_feedback_category

table

This lookup table maps feedback_category_ids with descriptions for categories of feedback (I.E. Incorrect Data or Irrelevant Answer) given to questions asked to Auto.

Feedback attribute This attribute indicates what feedback was given on a question asked to Auto by a user.

Thumb Down Reason

attribute

This attribute indicates why a user gave a thumbs-down to the question asked to Auto.

Number of Auto Questions using Definitions

fact

The count of questions that utilized definitions from Knowledge Assets to calculate the answer.
Number of Auto Questions Interpreted fact

The count of questions that had their interpretation requested by users.

Number of Auto Questions with Feedback

fact

The count of questions that received feedback from users.
Feedback Details fact The text feedback given by users about a question asked to Auto.

Questions (Definition Referred)

metric

The count of questions that utilized definitions from Knowledge Assets to calculate the answer

Questions (Interpreted) metric The count of questions that had their interpretation requested by users.

Questions (Thumb Down)

metric

The count of questions that received feedback from users.

Definition Referred Rate metric The proportion of questions that used definitions.

Interpretation Request Rate

metric

The proportion of questions that users requested interpretation.

Thumb Down Rate metric The proportion of questions that users submitted feedback.

Effectiveness Rate

metric

The ratio of negative feedback to positive or neutral feedback.

User Feedback

metric

The text feedback given from the user about an answer from an Auto question.

Knowledge Asset and Defining Learning Objects

Object

Type

Description

lu_knowledge_nugget

table

Backing table for the Definition/learning attributes. Columns include knowledge_nugget_id, knowledge_nugget_desc, nugget_collection_id, file_name, learned_from_application_id, learned_from_object_id, forgotten_ts, metadata_guid, tenant_id.

lu_nugget_collection

table

Backing table for the Knowledge Asset attribute. Columns include nugget_collection_id, nugget_collection_guid, nugget_collection_name, nugget_collection_desc, nugget_collection_owner_id, nugget_collection_status, nugget_collection_type, creation_date, creation_timestamp, modification_timestamp, metadata_id, metadata_guid, tenant_id.

fact_ai_interpretation_details table Backing table for Question Interpretation, Interpretation Components, and LLM Response. Columns: ai_question_id, question_interpretation, interpretation_components, llm_response, metadata_guid, tenant_id.

fact_ai_nugget_details

table

Backing table for Definition usage tracking. Columns: ai_question_id, knowledge_nugget_id, nugget_collection_id, knowledge_nugget_usage_scope_id, metadata_guid, tenant_id.

lu_ai_question_status table Lookup table for Question Status. Columns: ai_question_status_id, ai_question_status_desc.

lu_ai_question_view

table

 

rel_ai_question_definition_view

table

 
Knowledge Asset attribute

Knowledge Assets represent a collection of Definitions indexed by Strategy AI to supply additional business context to user questions.

Knowledge Asset Owner

attribute

The user who owns a Knowledge Asset.
Definition attribute Definitions supply additional business context to increase answer accuracy from Auto.

Definition Created On

attribute

The timestamp a learning was generated.

Definition Forgotten attribute Represents whether learning is forgotten or not.

Learned From Object

attribute

Identifies the specific bot or dashboard from which the learning originated, through user interactions and feedback.

Learned From Object Certified attribute Represents whether learned from object is certified or not.

Source Application

attribute

Identifies the Strategy application accessed by the user during their interaction with the chatbot, which led to the generation of the learning. Useful for filtering and understanding learnings that originate from applications.

Question Interpretation attribute This represents how Strategy AI interpreted the user's natural language question.

Question Status

attribute

This represents the Strategy components generated to answer your question, including: Filters, Attributes, Metrics, and Limits.

LLM Response

attribute

This represents the response from the LLM to answer the user's question.

Visualization attribute Represents a visualization in a dashboard (currently limited to Auto Narrative visualizations).

Definition Last Used Timestamp

fact / metric

The timestamp a definition was last used to respond to an Auto question.

Definition Times Used fact / metric The number of times a definition was used to respond to an Auto question.

Failed Auto Questions

metric

The count of Auto Questions that did not successfully receive a response.

Auto Active Users (agg) metric The count of users that used Auto (sourced from aggregate tables).

Auto Question Sent (agg)

metric

The count of Auto Questions that were submitted to the Auto AI service (sourced from aggregate tables).

Average Processing Time (sec) per Question (agg) metric The average time elapsed between when the Auto Question was submitted to Auto AI service and when response was received from the Auto service (sourced from aggregate tables).

Auto Question Timestamp (UTC) (L30)

metric

A timestamp that indicates when an Auto Question was submitted to the Auto AI service in the UTC timezone, during the last 30 days.