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 PROJECT project_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.