MicroStrategy ONE

List Platform Analytics Statistics Properties Statement

Lists the platform analytics statistics properties for a registered/loaded project in a MicroStrategy Intelligence Server.

LIST [ALL] PROPERTIES FOR PASTATISTICS IN PROJECT "project_name";

Where:

PROJECT project_name is the project for which the platform analytics statistics properties will be listed, of type string.

Example

LIST ALL PROPERTIES FOR PASTATISTICS IN PROJECT "MicroStrategy Tutorial";

ResultSet Columns

PROJECT: The name of the project, returned as a string.

BASIC STATISTICS: Whether the basic level of statistics logging, including report, document, and cube executions, user sessions, project sessions, prompt answers, subscription deliveries, and history list message executions and modifications, in enabled. Returned as a boolean value.

DETAIL REPORT JOBS: Whether the SQL Pass information that is executed on the warehouse during a report job executions is recorded. Returned as a boolean value.

DETAIL DOCUMENT JOBS: Whether the telemetry for each processing step of a document or dashboard execution is recorded. Returned as a boolean value.

JOB SQL: Whether the telemetry for each processing step of a report execution is recorded. Returned as a boolean value.

COLUMNS TABLES: Whether the columns and tables combinations used in the SQL during report executions is recorded. Returned as a boolean value.

MOBILE CLIENTS: Detailed statistics on reports and documents that are executed on a mobile device.

MOBILE CLIENTS MANIPULATIONS: Statistics on reports and document users executed on mobile clients as a result of a manipulation of the report or document. This setting is available only if the Mobile clients setting is also selected.

MOBILE CLIENTS LOCATION: Location information logged from a mobile client. This setting is available only if the Mobile clients setting is also selected.