MicroStrategy ONE

Authoring Best Practices

  • Do not include an excessive number of objects and long names in datasets.

  • Ensure each dataset, attribute, and metric has a unique name to avoid confusing the AI analysis and for clarity when users select an auto-complete option.

  • Avoid including object names such as "This week" or "Last week". If this name is essential, ensure that you use auto-complete when posing questions to Auto Answers. This helps Auto Answers determine the object name rather than using the current week timeframe.

  • Custom Groups, Consolidations, and Derived Elements are not supported.

  • Avoid using special characters in datasets such as '%', '*', ':', etc. For more information on data transformations, see Data Wrangling Dialog or Replace function. Similarly, accommodate your dataset metric convention in the same manner.

  • Avoid using Time-series attributes in a DateTime format for a Time related attribute. If necessary, you can convert the column into separate Date and Time attributes.

  • Avoid multiple Attribute objects from datasets that represent the same business entity. For example, avoid a dataset with an attribute named Week with a MM/DD/YYYY format and a integer datatype named "Week".

  • Compound grid authors may apply identical aliases to multiple objects. However, if the dashboard is intended to be accompanied by Auto Answers, refrain from applying identical aliases and ensure that each object has a unique alias.