MicroStrategy ONE

Create Fact statement

Creates a fact within a project.

Copy 
CREATE 
 FACTfact_name[DESCRIPTIONdesc][LONGDESCRIPTIONlong_description]IN FOLDERlocation_path[HIDDEN (TRUE 
 | FALSE)] EXPRESSIONfact_expression[EXPSOURCETABLESsourcetable1[,sourcetable2[,...sourcetableN]]] FOR PROJECTproject_name;

where:

  • fact_name is the name of the fact, of type string, between double quotes (" ").

  • desc is the description of the fact, of type string, between double quotes (" ").

  • long_description is the long description of the fact, of type string, between double quotes (").

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

  • fact_expression is the first fact expression, of type string, between double quotes (" ").

  • sourcetableN is the name of the source table to be used in the fact expression, of type string, between double quotes (" "). The tables will be automatically determined if no source tables are given.

  • 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 
CREATE FACT "Revenue" 
 DESCRIPTION "A copy of Revenue" IN FOLDER "\Public Objects" 
 EXPRESSION "TOT_DOLLAR_SALES" FOR PROJECT "MicroStrategy 
 Tutorial";