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;