KB36103: How can facts be altered to add/remove source tables using Manual mapping through MicroStrategy Command Manager 9.4.x-10.x?

Strategy Command Manager 9.4.x-10.x outline to alter existing facts cannot directly change their mapping to add/remove some source tables from the fact expressions. This can be achieved in two steps as:

1. Remove the expression from the fact using the 'REMOVE EXPRESSION' outline.
2. Add the expression back to the fact with only the required source tables using the 'ADD EXPRESSION' outline.

As an example, consider the fact 'Copy of Units Sold' defined as shown:

Consider that this fact needs to be modified using Strategy Command Manager 9.4.x-10.x to use Manual mapping and remove the 'ORDER_DETAIL' fact table from the 'QTY_SOLD' expression. This can be achieved as:

• Use the 'REMOVE EXPRESSION' outline to completely remove the 'QTY_SOLD' expression from the fact, as shown:
   
  

•  
  
  

  
  REMOVE EXPRESSION "QTY_SOLD" FROM FACT "Copy of Units Sold" IN FOLDER "\Schema Objects\Facts" FROM PROJECT "Strategy Tutorial";
  

  
  
  
• Add the expression back to the fact, and specify only the 'ORDER_FACT' source table as shown:
  

• 
  ADD EXPRESSION "QTY_SOLD" EXPSOURCETABLES "ORDER_FACT" OVERWRITE TO FACT "Copy of Units Sold" IN FOLDER "\Schema Objects\Facts" FOR PROJECT "Strategy Tutorial";  

  
  
  

This will change the mapping of the fact expression to Manual, and remove 'ORDER_DETAIL' as its source table, as shown:

Note: This approach cannot be used for facts which have only one expression whose source tables need to be changed. Removing the expression through Strategy Command Manager 9.4.x-10.x throws the following error:

You cannot remove the only expression from the fact 'xxx'. Please delete the fact if you want to remove the expression.