MicroStrategy ONE

Alter VLDB Settings statement

Modifies the VLDB property settings for an object.

Avoid any leading or trailing spaces in the PROPERTYVALUE parameters. This causes an SQL error and prevents the command from executing.

Copy 
ALTER VLDBSETTING (DEFAULT | PROPERTYNAME "propertyname1" (PROPERTYVALUE "propertyvalue1" | DEFAULTVALUE) [, ... PROPERTYNAME "propertynameN" (PROPERTYVALUE "propertyvalueN" | DEFAULTVALUE)]) FOR ((REPORT | METRIC | ATTRIBUTE 
 | TEMPLATE) "objectname" IN FOLDER "folder" IN PROJECT "project_for_object" | DBINSTANCE "dbinstance" | PROJECT "project");

where:

  • DEFAULT resets all VLDB properties for the object to their default value.

  • PROPERTYNAME "propertyname1..N" are the names of the VLDB properties that are to be modified, of type string.

  • PROPERTYVALUE "propertyvalue1..N" are the new values of the VLDB properties, of type string.

  • DEFAULTVALUE resets the property to its default value.

  • REPORT "objectname" is the report whose VLDB properties are to be modified, of type string.

  • METRIC "objectname" is the metric whose VLDB properties are to be modified, of type string.

  • ATTRIBUTE "objectname" is the attribute whose VLDB properties are to be modified, of type string.

  • TEMPLATE "objectname" is the template whose VLDB properties are to be modified, of type string.

  • FOLDER "folder" is the location of the object to be modified, of type string.

  • PROJECT "project_for_object" is the project where the object is located, of type string.

  • DBINSTANCE "dbinstance" is the name of the database instance whose VLDB properties are to be modified, of type string.

  • PROJECT "project" is the name of the project whose VLDB properties are to be modified, of type string.