Remove InVision object from Cache

This action removes an InVision object from the Flow cache.

For performance reasons, Flow will cache data and metadata for InVision objects when used in Calculation Flows. Specifically, the objects that are cached are Lookup tables, Auto transactions, Distribution keys and Dimensions.

Note

You only need to use this action when you modify an object used in Calculation Flows programmatically, or when using a View as a Lookup table source and the underlying data of the View changes.

You DO need to use this action

• When you programmatically modify an object used in a Calculation Flow by adding, removing or updating rows using a SQL Script, Stored Procedure or any type of custom code that execute SQL commands that updates an object. If you use custom code to modify data stored in an object, InVision is not able to track this, so it cannot automatically notify Flow to invalidate its cache.
• When using a View as a Lookup table, and one of the underlying tables has changed.

You DO NOT need to use this action

• When an object is modified from the InVision Designer or Workbooks through built-in UI components
• When an object is modified through an InVision API