FallBack Table Type

All reports can be resolved using permanent or temporary intermediate tables. Reports can also be resolved by generating derived tables, common table expressions, and views, but these means cannot cover all possible scenarios. For example, they cannot be used when the report contains Analytical Engine SQL, partitioning, or certain outer joins. In such a situation, the MicroStrategy SQL Engine needs another solution, which is provided by the Fallback Table Type property. If the Intermediate Table Type property is set to Derived table, Common table expression, or Temporary view and the SQL Engine concludes that the report cannot be resolved using the setting, it uses the Fallback Table Type property to resolve the report.

The options for this property are

• Permanent table
• True temporary table
• Use default inherited value