MicroStrategy ONE

Alter Project Configuration statement

Modifies the project configuration properties for a registered/loaded project in a MicroStrategy Intelligence Server.

Copy 
ALTER PROJECT CONFIGURATION [DESCRIPTION project_description] [WAREHOUSE warehouse_name] [STATUS html_input_file] [SHOWSTATUS (TRUE | FALSE)] [STATUSONTOP (TRUE | FALSE)] [DOCDIRECTORY folder_path] [MAXNOATTRELEMS number_of_attribute_elements] [USEWHLOGINEXEC (TRUE | FALSE)] [ENABLEOBJECTDELETION (TRUE | FALSE)] [MAXREPORTEXECTIME number_of_seconds] [MAXNOINTELLIGENTCUBERESULTROWS number_of_cube_rows] [MAXNODATAMARTRESULTROWS number_of_datamart_rows] [MAXNOREPORTRESULTROWS number_of_report_result_rows] [MAXNOELEMROWS number_of_element_rows] [MAXNOINTRESULTROWS number_of_intermediate_result_rows] [MAXJOBSUSERACCT number_of_jobs_per_user_acct] [MAXJOBSUSERSESSION number_of_jobs_per_user_session] [MAXEXECJOBSUSER number_of_executing_jobs_per_user] [MAXJOBSPROJECT number_of_jobs_per_project] [MAXUSERSESSIONSPROJECT number_of_user_sessions_per_project] [MAXHISTLISTSUBSCRIPTIONS number_of_histlist_subscriptions] [MAXCACHEUPDATESUBSCRIPTIONS number_of_cacheupdate_subscriptions] [MAXEMAILSUBSCRIPTIONS number_of_email_subscriptions] [MAXFILESUBSCRIPTIONS number_of_file_subscriptions] [MAXEMAILSUBSCRIPTIONS number_of_email_subscriptions] [MAXFILESUBSCRIPTIONS number_of_file_subscriptions] [MAXPRINTSUBSCRIPTIONS number_of_print_subscriptions]  [MAXMOBILESUBSCRIPTIONS number_of_mobile_subscriptions] [PROJDRILLMAP drill_map [IN FOLDER drill_map_location]] [REPORTTPL report_template] [REPORTSHOWEMPTYTPL (TRUE | FALSE)] [TEMPLATETPL template_template] [TEMPLATESHOWEMPTYTPL (TRUE | FALSE)] [METRICTPL metric_template] [METRICSHOWEMPTYTPL (TRUE | FALSE)] [DOCTPL document_template] [DOCSHOWEMPTYTPL (TRUE | FALSE)] [USEDOCWIZARD (TRUE | FALSE)] [INTELLIGENTCUBEFILEDIR "folder_path"] [INTELLIGENTCUBEMAXRAM number_of_MB] [INTELLIGENTCUBEMAXNO number_of_cubes] [MAXFILESIZEIMPORT max_file_import_size] [MAXQUOTAIMPORT max_import_quota] [DRILLIMMEDIATE (TRUE | FALSE)] [SORTDRILLPATHS (TRUE | FALSE)] [PDFHEADERLEFT left_header_text]  [PDFHEADERCENTER center_header_text]  [PDFHEADERRIGHT right_header_text] [PDFFOOTERLEFT left_footer_text] [PDFFOOTERCENTER center_footer_text] [PDFFOOTERRIGHT right_footer_text] [EXPORTHEADER export_header]  [EXPORTFOOTER export_footer] [EXPORTCOMPATIBILILITYMODE (TRUE | FALSE)] [MERGEHEADERS (TRUE | FALSE)] [EXPORTFLASHFORMAT (PDF | MHT)] [CREATEUSERPROFILEATLOGIN (TRUE | FALSE)] [REPORTDESCRIPTION (TRUE | FALSE)] [PROMPTDETAILS (TRUE | FALSE)] [FILTERDETAILS (TRUE | FALSE)] [TEMPLATEDETAILS (TRUE | FALSE)] [INCLUDEPROMPTTITLE  (TRUE | FALSE)] [REPLACEUNANSWEREDPROMPT (DEFAULT | BLANK | PROMPTNOTANSWERED | NOSELECTION|ALLNONE)] [SHOWATTRIBUTENAMEINPROMPT (NO | YES | REPEATED)] [INCLUDEUNUSEDPROMPTS (TRUE | FALSE)] [USEDELIMITERSINREPORTOBJECTS (NO | YES | AUTOMATIC)] [USEALIASESINFILTERSDETAILS (TRUE | FALSE)] [REPORTFILTER (TRUE | FALSE)] [REPORTFILTERNAME (NO | YES | AUTOMATIC)] [REPORTFILTERDESC (TRUE | FALSE)] [REPORTLIMITS (TRUE | FALSE)] [VIEWFILTER (TRUE | FALSE)] [METRICQUALIFICATIONVIEWFILTER (TRUE | FALSE)] [DRILLFILTER (TRUE | FALSE)] [SECURITYFILTER (TRUE | FALSE)] [INCLUDEFILTERTYPE (TRUE | FALSE)] [SHOWEMPTYEXPRESSION (TRUE | FALSE)] [NEWLINEAFTERTYPENAME (TRUE | FALSE)] [NEWLINEBETWEENFILTER (TRUE | FALSE)] [SHOWREPORTLIMITS (BEFOREVIEWFILTER | AFTERVIEWFILTER)] [EXPANDSHORCUTFILTERS (SHOWDEFINITION | SHOWNAME  | SHOWNAMEANDDEFINITION)] [SHOWATTRIBUTEINLISTCONDITIONS (NO | YES | REPEATED)] [SEPARATORAFTERATTRNAME separator] [NEWLINEAFTERATTRNAME (TRUE | FALSE)] [SEPARATORBETWEENLASTTWOELEMENTS (OR | AND | COMMA | CUSTOM last_two_separator)] [NEWLINEBETWEENELEMENTS (TRUE | FALSE)] [TRIMELEMENTS (TRUE | FALSE)] [DISPLAYOPERATORS (SYMBOLS | NAMES)] [INCLUDEATTRFORMINCONDITION (TRUE | FALSE)] [DYNAMICDATE (DEFAULT | SHOWDATE | SHOWEXPRESSIONS)] [NEWLINEBETWEENCONDITIONS (NO | YES | AUTOMATIC)] [LINESPACING (SINGLESPACE | DOUBLESPACE)] [PARENTHESESAROUNDCONDITIONS (NO | YES | AUTOMATIC)] [LOGICALOPBETWEENCONDITIONS (NO | YES | AND | OR)] [UNITSFROM (VIEW | BASE)] [BASETEMPLATE (NO | YES | AUTOMATIC)] [TEMPLATEDESCRIPTION (TRUE | FALSE)] [NONMETRICTEMPLATEUNITS (TRUE | FALSE)] [METRICS (TRUE | FALSE)] [ONLYCONDITIONAL (TRUE | FALSE)] [FORMULA (TRUE | FALSE)] [DIMENSIONALITY (TRUE | FALSE)] [CONDITIONALITY (TRUE | FALSE)] [TRANSFORMATION (TRUE | FALSE)] [(NOWATERMARK | TEXTWATERMARK TEXT text SIZEAUTOMATICALLY (TRUE | FALSE) WASHOUT (TRUE | FALSE) ORIENTATION (DIAGONAL|HORIZONTAL) | IMAGEWATERMARK SOURCE image_source SCALE scale_percentage)] [ALLOWDOCUMENTOVERWRITEWATERMARK (TRUE | FALSE)] [WEBSERVERMACRO webserver_address] [ENABLELINKSINMHT (TRUE | FALSE)] [CUSTOMPROMPSTYLES (VALUEPROMPT | OBJECTPROMPT | ATTRIBUTEPROMPT | HIERARCHYPROMPT | ATTRIBUTEQUALPROMPT | METRICQUALIFICATION) NAME prompt_name1 DESCRIPTION prompt_description1 BASESTYLE base_style1 [, (VALUEPROMPT | OBJECTPROMPT | ATTRIBUTEPROMPT | HIERARCHYPROMPT | ATTRIBUTEQUALPROMPT | METRICQUALIFICATION) NAME prompt_name2 DESCRIPTION prompt_description2 BASESTYLE base_style2 [, .. , (VALUEPROMPT | OBJECTPROMPT | ATTRIBUTEPROMPT | HIERARCHYPROMPT | ATTRIBUTEQUALPROMPT | METRICQUALIFICATION) NAME prompt_namen DESCRIPTION prompt_descriptionn BASESTYLE base_stylen]]] [DISPLAYATTRINALPHABETICALORDER (TRUE | FALSE)] [ENABLEPERSONALANSWERS (TRUE | FALSE)] [EXPORTPDFINHEBREW (TRUE | FALSE)] [DEFAULTDATAMART db_instance_name] [WAITTIMEFORPROMPTANSWERS wait_time] [WAREHOUSEEXECUTIONTIME max_execution_time] [SQLGENERATIONMEMORY MB_for_SQL_generation] [INTERACTIVEJOBPERPROJECT no_interactive_jobs] [CACHEENCRYPTION (NONE | LOW | HIGH)] [DISABLEAUTOMATICEXPIRATIONDYNAMICDATES (TRUE | FALSE)] [RERUNMOBILESUBSCRIPTIONS (TRUE | FALSE)] [RERUNEMAILSUBSCRIPTIONS (TRUE | FALSE)] [DISABLECREATINGMATCHINGCACHES (TRUE | FALSE)] [KEEPDOCUMENTFORMANIPULATION (TRUE | FALSE)] [CREATECUBESBYDATABASECONNECTION (TRUE | FALSE)] [LOADCUBESONSTARTUP (TRUE | FALSE)] [LOADCUBESONPUBLICATION (TRUE | FALSE)] [SECURITYFILTERMERGER (INTERSECTALL | UNIONRELATEDINTERSECTUNRELATED)] [ATTRSHOWNUMERIC (TRUE | FALSE)] [ATTRSHOWCHARACTER (TRUE | FALSE)] [ATTRSHOWBINARY (TRUE | FALSE)] [ATTRSHOWDATE (TRUE | FALSE)] [ATTRSHOWBIGDECIMAL (TRUE | FALSE)] [ATTRREPLACEUNDERSCORE (TRUE | FALSE)] [ATTRREMOVEID (TRUE | FALSE)] [ATTRFIRSTLETTERUPPERCASE (TRUE | FALSE)] [ATTRIDSTRING id_prefix] [ATTRDESCSTRING desc_prefix] [ATTRLOOKUPSTRING lookup_prefix] [FACTSHOWNUMERIC (TRUE | FALSE)] [FACTSHOWCHARACTER (TRUE | FALSE)] [FACTSHOWBINARY (TRUE | FALSE)] [FACTSHOWDATE (TRUE | FALSE)] [FACTSHOWBIGDECIMAL (TRUE | FALSE)] [FACTREPLACEUNDERSCORE (TRUE | FALSE)] [FACTFIRSTLETTERUPPPERCASE (TRUE | FALSE)] [VERIFYCUSTOMCOLUMNNAME (TRUE | FALSE)] [NULLDISPLAYWAREHOUSE wh_string_to_display] [NULLDISPLAYCROSSTABULATOR xtab_string_to_display] [REPLACENULLWHENSORTED (TRUE | FALSE)] [REPLACENULLWHENSORTEDVALUE replace_value] [NOTCALCULATEDDISPLAY not_calc_string_to_display] [MISSINGDISPLAY missing_string_to_display] [OVERRIDEGRAPHTEMPLATEFONT  CHARACTERSET character_set FONT font_name] [USEZEROFORGRAPHNULL (TRUE | FALSE)] [GRAPHROUNDEDEFFECT (NONE | STANDARD | OPTIMIZE)] [EMPTYREPORTMESSAGE empty_message] [DISPLAYEMPTYMESSAGEINDOCUMENT (TRUE | FALSE)] [KEEPPAGEBYWHENSAVING (TRUE | FALSE)] [OVERWRITEWITHOLAPREPORTS (ALLOW | ALLOWWITHWARNING | PREVENT)] [MOVESORTKEYSWITHPIVOT (TRUE | FALSE)] [APPENDEMAILFOOTER (TRUE | FALSE)] [EMAILFOOTERTEXT email_footer_text] [ENABLEPRINTINGRANGE (TRUE | FALSE)] [DELIVERSUBSCRIPTIONWITHNODATA (TRUE | FALSE)] [DELIVERSUBSCRIPTIONWITHPARTIALRESULTS (TRUE | FALSE)] [(ALLSCHEDULES | SCHEDULES schedule1 [, .. scheduleN])] IN PROJECT project_name;

where:

  • project_description is the description of the project, of type string, between double quotes (" ").

  • html_input_file is the name of the Windows file that contains the HTML or plain text to be used as input for the project status, of type string, between double quotes (" ").

  • warehouse_name is the warehouse for the project, of type string, between double quotes (" ").

  • folder_path is the location of the HTML document directory, of type string, between double quotes (" ").

  • number_of_attribute_elements is the maximum number of elements to display when browsing attributes, of type integer.

  • number_of_seconds is the maximum report execution time in seconds, of type integer.

  • number_of_cube_rows is the maximum number of result rows in an Intelligent Cube, of type integer.

  • number_of_datamart_rows is the maximum number of result rows in a datamart, of type integer.

  • number_of_report_result_rows is the maximum number of result rows in a report, of type integer.

  • number_of_element_rows is the maximum number of element rows, of type integer.

  • number_of_intermediate_result_rows is the maximum number of intermediate result rows, of type integer.

  • number_of_jobs_per_user_acct is the maximum number of jobs per user account, of type integer.

  • number_of_jobs_per_user_session is the maximum number of jobs per user session, of type integer.

  • number_of_executing_jobs_per_user is the maximum number of executing jobs per user, of type integer.

  • number_of_jobs_per_project is the maximum number of jobs per project, of type integer.

  • number_of_user_sessions_per_project is the maximum number of user sessions per project, of type integer.

  • number_of_histlist_subscriptions is the maximum number of history list subscriptions per user, of type integer.

  • number_of_cacheupdate_subscriptions is the maximum number of cache update subscriptions per user, of type integer.

  • number_of_email_subscriptions is the maximum number of email subscriptions per user, of type integer.

  • number_of_file_subscriptions is the maximum number of file subscriptions per user, of type integer.

  • number_of_print_subscriptions is the maximum number of print subscriptions per user, of type integer.

  • number_of_mobile_subscriptions is the maximum number of mobile subscriptions per user, of type integer.

  • drill_map is the default project drill map to be assigned to the configuration, of type string, between double quotes (" ").

  • drill_map_location is the location of the drill map, of type string, between double quotes (" ").

  • report_template is the default template for the report object, of type string, between double quotes (" ").

  • template_template is the default template for the template object, of type string, between double quotes (" ").

  • metric_template is the default template for the metric object, of type string, between double quotes (" ").

  • doc_template is the default template for the document object, of type string, between double quotes (" ").

  • folder_path is the path to the disk storage of unloaded Intelligent Cubes, of type string, between double quotes (" ").

  • number_of_mb is the maximum size in memory of all Intelligent Cubes allowed in the project, of type integer.

  • number_of_cubes is the maximum number of Intelligent Cubes allowed in the project, of type integer.

    Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. It will remain available, but the setting will not be enforced if set below the default value of 1000.

  • max_file_import_size is the maximum size, in kilobytes, of a data import, of type integer.

  • max_import_quota is the maximum size, in kilobytes, of all data imports per user, of type integer.

  • left_header_text is the text of the left header for the PDF export, of type string, between double quotes (" ").

  • center_header_text is the text of the center header for the PDF export, of type string, between double quotes (" ").

  • right_header_text is the text of the right header for the PDF export, of type string, between double quotes (" ").

  • left_footer_text is the text of the left footer for the PDF export, of type string, between double quotes (" ").

  • center_footer_text is the text of the center footer for the PDF export, of type string, between double quotes (" ").

  • right_footer_text is the text of the right footer for the PDF export, of type string, between double quotes (" ").

  • export_header is the header used when exporting the document, of type string, between double quotes (" ").

  • export_footer is the footer used when exporting the document, of type string, between double quotes (" ").

  • separator is the separator between two attribute elements, of type string, between double quotes (" ").

  • last_two_separator is the custom separator used between the last two elements, of type string, between double quotes (" ").

  • text is the text of a custom watermark, of type string, between double quotes (" ").

  • image_source is the source image for a custom watermark, of type string, between double quotes (" ").

  • scale_percentage is thepercentage to scale the watermark image, of type integer.

  • webserver_address is the address of the MicroStrategy Web server that is used in the WEBSERVER macro, of type string, between double quotes (" ").

  • prompt_name1..n are the names of prompts used for custom prompt styles, of type string, between double quotes (" ").

  • prompt_description1..n are the descriptions of prompts used for custom prompt styles, of type string, between double quotes (" ").

  • base_style1..n are the base styles for prompts used for custom prompt styles, of type string, between double quotes (" ").

  • db_instance_name is the database instance used as the default datamart database instance, of type string, between double quotes (" ").

  • wait_time is the amount of time in seconds to wait for prompt answers, of type integer.

  • max_execution_time is the amount of time in seconds to wait for the data warehouse, of type integer.

  • MB_for_SQL_generation is the maximum number of megabytes of memory to use for SQL generation, of type integer.

  • no_interactive_jobs is the maximum number of interactive jobs for this project, of type integer.

  • id_prefix is the prefix used in attribute ID forms, of type string, between double quotes (" ").

  • desc_prefix is the prefix used in attribute description forms, of type string, between double quotes (" ").

  • lookup_prefix is the prefix used in attribute lookup tables, of type string, between double quotes (" ").

  • wh_string_to_display is the string displayed in place of data warehouse nulls, of type string, between double quotes (" ").

  • xtab_string_to_display is the string displayed in place of crosstab nulls, of type string, between double quotes (" ").

  • replace_null is the value used to replace database nulls in sorting, of type integer.

  • not_calc_string_to_display is the string displayed in place of uncalculated nulls, of type string, between double quotes (" ").

  • missing_string_to_display is the string displayed in place of missing data, of type string, between double quotes (" ").

  • character_set is the character set used when overriding the graph template font, of type string, between double quotes (" ").

  • font_name is the font used when overriding the graph template font, of type string, between double quotes (" ").

  • empty_message is the message to display when a report contains no data, of type string, between double quotes (" ").

  • email_footer_text is the text of the footer when emailing a report, of type string, between double quotes (" ").

  • schedule1..N are the schedules that are enabled for the project, of type string, between double quotes (" ").

  • project_name is the project for which the configuration will be modified, of type string, between double quotes (" ").

Examples

Copy 
ALTER 
 PROJECT CONFIGURATION DESCRIPTION "MicroStrategy Tutorial Project 
 (version 7.2)" WAREHOUSE "Tutorial Data" DOCDIRECTORY C:\Program 
 Files\MicroStrategy\Tutorial 
 MAXNOATTRELEMS 1000 USEWHLOGINEXEC FALSE MAXREPORTEXECTIME 600 MAXNOREPORTRESULTROWS 
 32000 MAXNOELEMROWS 32000 MAXNOINTRESULTROWS 32000 MAXJOBSUSERACCT 100 
 MAXJOBSUSERSESSION 100 MAXEXECJOBSUSER 100 MAXJOBSPROJECT 1000 MAXUSERSESSIONSPROJECT 
 500 IN PROJECT MicroStrategy Tutorial;
Copy 
ALTER PROJECT CONFIGURATION PROJDRILLMAP "\Public 
 Objects\Drill
Copy 
ALTER PROJECT CONFIGURATION STATUS "\\Production_Machine\StatusFiles\Status.txt 
 SHOWSTATUS TRUE STATUSONTOP TRUE IN PROJECT MicroStrategy Tutorial;
Copy 
ALTER PROJECT CONFIGURATION SHOWSTATUS TRUE IN PROJECT 
 "MicroStrategy Tutorial";
Copy 
ALTER PROJECT CONFIGURATION STATUSONTOP FALSE IN 
 PROJECT "MicroStrategy Tutorial";