MicroStrategy - Command Manager - Web Preferences

mstr
Command Manager

How can we list values for web preferences?

LIST WEBPREFERENCES 
    [(GROUPS "<groupname1>" [, "<groupname2>" ...] | NAMES "<name1>" [, "<name2>" ...])] 
    [FOR (USER "<user_name>" | CURRENTUSER)] 
    IN (ALLPROJECTS | PROJECT "<project>");

How can I list the web preferences that belong to a particular preference group for a particular user and a particular project?

LIST WEBPREFERENCES GROUPS "general" FOR USER "baoter" IN PROJECT "microstrategy tutorial";
LIST WEBPREFERENCES GROUPS "general" FOR CURRENTUSER IN ALLPROJECTS;

How can I list all web preferences?

LIST WEBPREFERENCES FOR CURRENTUSER IN ALLPROJECTS; 
LIST WEBPREFERENCES FOR CURRENTUSER IN PROJECT "microstrategy tutorial";

How can we list a specific web preference?

LIST WEBPREFERENCES NAMES 
    "Graph size:[Width:]",
    "Save and Copy Options:[Display advanced options]",
    "Font style:[Font size used throughout the application]",
    "Language:[Metadata]"
FOR CURRENTUSER IN ALLPROJECTS;

How can we apply value for a particular web preference?

APPLY WEBPREFERENCES 
    (NAME "<name1>" (VALUE "<value1>" | DEFAULTVALUE)[,NAME "<name2>" (VALUE "<value2>" | DEFAULTVALUE)...]) | DEFAULTVALUES 
    [FOR (USER "<user_name>" | CURRENTUSER)] 
    TO (ALLPROJECTS | PROJECT "<project_name>");

APPLY WEBPREFERENCES 
    NAME "Graph size:[Width:]" VALUE "555", 
    NAME  "Save and Copy Options:[Display advanced options]"  VALUE "1",  
    NAME  "Font style:[Font size used throughout the application]" VALUE "7" ,  
    NAME  "Language:[Metadata]"  DEFAULTVALUE 
    FOR USER "baoter" 
    TO PROJECT   "microstrategy tutorial";

APPLY WEBPREFERENCES 
    NAME "Graph size:[Width:]" VALUE "666", 
    NAME "Save and Copy Options:[Display advanced options]"  VALUE "1", 
    NAME "Font style:[Font size used throughout the application]" VALUE "6" ,  
    NAME "Language:[Metadata]"  DEFAULTVALUE 
    FOR CURRENTUSER 
    TO ALLPROJECTS;

How can we reset all web preferences back to default values?

APPLY WEBPREFERENCES DEFAULTVALUES FOR USER "baoter" TO PROJECT "microstrategy tutorial";
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License