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.