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;