MicroStrategy ONE

Get Child Candidates statement

Gets all the attributes that are child candidates for a given attribute within a project.

Copy 
GET CHILD CANDIDATES FOR ATTRIBUTE 
 attribute_name IN [FOLDER] location_path FOR PROJECT project_name;

where:

  • attribute_name is the name of the attribute for which the child candidates are to be retrieved, of type string, between double quotes (").

  • location_path is the folder where the attribute 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 
GET CHILD CANDIDATES FOR ATTRIBUTE "Month" 
 IN FOLDER "\Schema Objects\Attributes 
 FOR PROJECT MicroStrategy Tutorial;

ResultSet Columns

ATTRIBUTE_CHILD_CANDIDATES: The name of the child candidate, returned as a string.

PATH: The folder path of the child candidate, returned as a string.