MicroStrategy ONE

List Facts statement

Lists all facts from a given location path within a project.

Copy
LIST [ALL] FACTS [IN FOLDERlocation_path] FOR PROJECTproject_name;

where:

  • location_path is the folder path from which the facts are to be listed, 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 FACTS 
 IN FOLDER "\Schema Objects\Facts" FOR PROJECT "MicroStrategy 
 Tutorial";

ResultSet Columns

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

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

PATH: The path to the fact, returned as a string.