MicroStrategy ONE
Add Fact Expression statement
Adds an expression to a fact within a project.
Copy
ADD EXPRESSIONexpression[EXPSOURCETABLESsourcetable1, [,sourcetable2[,.
. .sourcetableN]]]
[OVERWRITE] TO FACTfact_nameIN FOLDERlocation_pathFOR PROJECTproject_name;
where:
-
expression is the expression to be added to the fact, of type string, between double quotes (" ").
-
sourcetableN is the name of the source table to be used in the fact's expression, of type string, between double quotes (" ").
-
fact_name is the name of the fact for which the expression is to be added, 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
ADD EXPRESSION
"QTY_SOLD*(UNIT_PRICE
- DISCOUNT) TO FACT Revenue IN FOLDER \Public
Objects FOR PROJECT MicroStrategy Tutorial;