MicroStrategy ONE

List Fact Properties statement

Lists all properties for a given fact within a project.

Copy 
LIST [ALL] PROPERTIES FOR FACTfact_nameIN FOLDERlocation_pathFOR PROJECTproject_name;

where:

  • fact_name is the name of the fact for which its properties are to be listed, of type string, between double quotes (" ").

  • location_path is the folder where the fact 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 FACT "Revenue" IN FOLDER "\Public Objects" FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

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

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

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

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

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

MODIFICATION_TIME:  The date and time the fact was last modified, returned as a date/string.

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

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

SCHEMA_EXPRESSION_LIST: A ResultSet containing the names and other related details of schema expressions associated with the fact.

  • MAPPING_METHOD: Mapping method for the expression, either automatic or manual. Returned as a string.

  • SCHEMA_CANDIDATE_TABLE_LIST: A list of source tables for the expression.

    • MAPPING_FLAG: Whether or not the source table below is mapped, returned as a boolean value.

    • SCHEMA_CANDIDATE_TABLE: The table from which the fact can return data, returned as a string.

  • SCHEMA_EXPRESSION: The name of the schema expression, returned as a string.