Incremental Table

A fact table can consist of a main table containing historic data plus an incremental table temporarily containing the most recent data.

This allows for very efficient SSAS processing. 

Add a new incremental table by clicking the "Add Incremental Table" link button.

PS6_IncrementalTable_Part1_SalesEx.PNG

A dialog box suggesting you add a reload filter appears.

PS6_IncrementalTable_Part2_SalesEx.PNG

In the SQL Expression Builder; specify a reload filter (usually utilizing the RELOADVALUE tag value), then click "Save and Close".

PS6_IncrementalTable_Part3_SalesEx.PNG

A dialog appears prompting you to optionally add script extensions maintaining the RELOADVALUE tag value (plus move data if table and not view).

PS6_IncrementalTable_Part4_SalesEx.PNG

If you choose to add script extensions, separate script extensions folder(s) will be added containing the scripts. The incremental table is placed below the main table.

PS6_IncrementalTable_Part5_SalesEx.PNG

The incremental table will typically be used in the same measure group(s) as the main table with the "Use Direct in Target" setting checked.

PS6_IncrementalTable_Part6_SalesEx.PNG

Lastly this can all be glued together via the "Incremental Table Data Flow".

PS6_IncrementalTable_Part7_SalesEx.PNG

Select the incremental table.

PS6_IncrementalTable_Part8_SalesEx.PNG

Give the data flow a name and click "Create".

PS6_IncrementalTable_Part9_SalesEx.PNG

Usually the incremental table reload involves three data flow steps. (Four if dimensions are to be taken into account)

PS6_IncrementalTable_Part10_SalesEx.PNG

The Process Add part is a Process Measure Group operation.

PS6_IncrementalTable_Part11_SalesEx.PNG

The Incremental Table direct partition is the partition to select for Process Add if data flow is created manually.

PS6_IncrementalTable_Part12_SalesEx.PNG