MicroStrategy ONE

List Attributes statement

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

Copy
LIST 
 [ALL] ATTRIBUTES [IN [FOLDER]location_path] FOR PROJECTproject_name;
        

where:

  • location_path is the folder from which the attributes 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 ATTRIBUTES FOR PROJECT "MicroStrategy Tutorial";

 

Copy
LIST ALL ATTRIBUTES IN FOLDER "\Schema Objects\Attributes\Customers" 
 FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

HIDDEN: Whether the attribute is hidden, returned as a boolean value.

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

PATH: The folder path that contains the attribute, returned as a string.