MicroStrategy ONE

Remove Fact Expression statement

Removes an expression from a fact within a project.

Copy
REMOVE 
 EXPRESSIONexpressionFROM FACTfact_nameIN FOLDERlocation_pathFROM PROJECTproject_name;

where:

  • expression is the expression to be removed from the fact, of type string, between double quotes (" ").

  • fact_name is the name of the fact from which the expression is to be removed, of type string, between double quotes (" ").

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

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

This statement can only be executed in a Windows environment.

Example

Copy
REMOVE EXPRESSION 
 "QTY_SOLD*(UNIT_PRICE 
 - DISCOUNT) FROM FACT Revenue IN FOLDER \Public 
 Objects FROM PROJECT MicroStrategy Tutorial;