MicroStrategy ONE

List Report Properties statement

Lists all properties of a report in a project.

Copy 
LIST [ALL] PROPERTIES FOR REPORTreport_nameIN FOLDERlocation_pathFOR PROJECTproject_name;

where:

  • report_name is the name of the report, of type string, between double quotes (" ").

  • location_path is the folder where the report resides, of type string, between double quotes (" ").

  • project_name is the name of the project, of type string, between double quotes (" ").

This statement can only be executed in a Windows environment.

Example

Copy 
LIST ALL PROPERTIES FOR REPORT "Profit Forecast" IN FOLDER "\Public Objects\Reports" FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

CREATION_TIME: The date and time the report was created, returned as a date/string.

DESCRIPTION: The description of the report, returned as a string.

HIDDEN: Whether or not the report is hidden, returned as a boolean value.

ID: The object ID of the report, returned as a string.

LONG_DESCRIPTION: The long description of the report, returned as a string.

MODIFICATION_TIME: The date and time the report was created, returned as a date/string.

NAME: The name of the report, returned as a string.

OWNER: The owner of the report, returned as a string.

REPORT_AXIS_RESULT_SET: A ResultSet containing a list of axes contained within the report and related details.

  • AXIS_NAME: The name of the axis, such as "Rows" or "Columns". Returned as a string.

  • TEMPLATE_UNITS_RESULT_SET: A ResultSet containing the properties of each template object on the axis.

    • ID: The object ID of the template object, returned as a string.

    • PATH: The path to the template object, returned as a string.

    • TEMPLATE_UNIT: The name of the template object, returned as a string.

    • TYPE: The type of the template object, such as "Attribute". Returned as a string.

REPORT_FILTER: The filter associated with the report, returned as a string.

VIEW_FILTER_EXPRESSION: The view filter associated with the report, returned as a string.