MicroStrategy ONE

Accessing History Lists

History Lists can be accessed from both MicroStrategy Web and Developer. You cannot see the History Lists for all users unless you have access to the History List Messages Monitor. For more information about the History List Messages Monitor, see Managing History Lists.

Accessing the History List Folder in MicroStrategy Web

In MicroStrategy Web, log in to the desired project and click the History List link in the top navigation bar. This displays all history list messages for the user that is currently logged in. The following information is available:

  • Name: Name (or alias) of the report.
  • Status: Status of a report job, for example, executing, processing on another node, ready, and so on.

    If you are working in a clustered environment, only Ready and Error statuses are synchronized across nodes. While a job on one node is reported as Executing, it is reported as Processing On Another Node on all the other nodes.

  • Message Creation Time: The time the message was created, in the currently selected time zone.
  • Details: More information about the report, including total number of rows, total number of columns, server name, report path, message ID, report ID, status, message created, message last updated, start time, finish time, owner, report description, template, report filter, view filter, template details, prompt details, and SQL statements.

Each time a user submits a report that contains a prompt, the dialog requires that they answer the prompt. As a result, multiple listings of the same report may occur. The differences among these reports can be found by checking the timestamp and the data contents.

Accessing the History List Folder in Developer

In Developer, History List messages are located in the History folder under the project name. The number next to the History List folder indicates how many unread History List messages are contained in the folder. Click the History folder to view all the messages. Each message is listed with the following information:

  • Name: Name of the report
  • Finish Time: The time the report execution is finished
  • Folder name: Name of the folder where the original report is saved
  • Last update time: The time when the original report was last updated
  • Message text: The status message for the History List message
  • Start time: The time the report execution was started
  • Status: Status of a report job, for example, has been executed successfully and is ready, is not executed successfully, is currently executing, or is waiting to execute

You can see more details of any message by right-clicking it and selecting Quick View. This opens a new window with the following information:

  • Report definition: Expand this category to see information about the report definition, including the description, owner, time and date it was last modified, the project it resides in, the report ID, the path to the report's location, and report details.
  • Job execution statistics: Expand this category to see information about the report execution, including the start and end time, the total number of rows and columns in the report, the total number of rows and columns that contain raw data, whether a cache was used, the job ID, and the SQL produced.
  • Message status: Expand this category to see information about the message itself, including the language, user creation time, last update time, read status, format, request type, application, message ID, and message text.