MicroStrategy ONE

Create Custom Group statement

Creates a custom group in a project.

Copy 
CREATE CUSTOMGROUPcustomgroup_name[DESCRIPTIONdescription] [LONGDESCRIPTIONlong_description][ENABLEHIERARCHICALDISPLAY (TRUE| FALSE)] [ENABLESUBTOTALDISPLAY 
 (TRUE | FALSE)] [ELEMENTHEADERPOSITION (ABOVE | BELOW)] [HIDDEN (TRUE 
 | FALSE)] 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] 
 IN FOLDERlocation_pathFOR PROJECTproject_name;

where:

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

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

  • long_description is the long description of the custom group, of type string, between double quotes (").

  • 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 element expression syntax.

  • attribute_name1, attribute_name2, ... attribute_nameN are the attributes that specify the levels upon this custom group element 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 (").

  • 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 (").

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

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

Examples

Copy 
CREATE CUSTOMGROUP "Copy of Age Groups" 
 DESCRIPTION "Clone of Age Groups" ENABLEHIERARCHICALDISPLAY 
 TRUE ENABLESUBTOTALDISPLAY TRUE ELEMENTHEADERPOSITION ABOVE ELEMENT "<25" 
 SHOWELEMENTNAME EXPRESSION "([Customer Age]@ID < 25.0)" IN 
 FOLDER "\Public Objects\Custom Groups" FOR PROJECT "MicroStrategy 
 Tutorial";
Copy 
CREATE CUSTOMGROUP "Copy of Customers Deciling DESCRIPTION Clone of Customer