MicroStrategy ONE

Add Custom Group Element statement

Add a custom group element into an existing custom group in a project.

Copy
ADD ELEMENTelement_name[(SHOWELEMENTNAME  | SHOWITEMSINELEMENT | SHOWITEMSINELEMENTANDEXPAND 
 | SHOWALLANDEXPAND)] EXPRESSIONexpression[BANDNAMESname1,name2, 
 ...nameN] [OUTPUTLEVELattribute_name1,attribute_name2, ...attribute_nameN] 
 IN FOLDERSoutputlevel_location_path1,output_location_path2,output_location_pathN] 
 TO CUSTOMGROUPcustomgroup_nameIN FOLDERlocation_pathFOR PROJECTproject_name;

where:

  • element_name is the name of the custom group element, of type string, between double quotes (" ").

  • expression is the expression of the custom group element, of type string, between double quotes (" "). For the syntax of custom group element expressions in Command Manager, see Custom Group management: Custom Group element expression syntax.

  • name1, name2, ... nameN are the names of the custom group bands, which are only applicable to custom group banding element, of type string, between double quotes (" ")

  • attribute_name1, attribute_name2, ... attribute_nameN are the attributes that specify the levels upon this custom group is calculated, of type string, in between double quotes (" ").

  • outputlevel_location_path1, outputlevel_location_path2, ... output_location_pathN are the folders where the attribute resides, of type string, in between double quotes.

  • customgroup_name is the name of the custom group, of type string, between double quotes (").

  • location_path is the folder where the custom group resides, of type string, between double quotes (" ").

  • project_name is the name of the project where the custom group resides, of type string, between double quotes (" ").

Example

Copy
ADD ELEMENT "25-35" EXPRESSION "([Customer 
 Age]@ID Between 25.0 And 35.0)" TO CUSTOMGROUP "Copy of Age 
 Groups" IN FOLDER "\Public Objects\Custom Groups" FOR PROJECT 
 "MicroStrategy Tutorial";