Auto Update

Auto update makes data warehouse processing more efficient by executing only the operations deemed necessary based on what data has changed.

Using auto update functionality

- Data flow

In the Navigator Pane; right click 'Data Flows' and then click 'New Auto Update Data Flow'. 

PS6_AutoUpdate_Part0_SalesEx.PNG

Select fact source tables to reload.

PS6_AutoUpdate_Part2_SalesEx.PNG

Select module and an SSAS auto update operation.

PS6_AutoUpdate_Part3_SalesEx.PNG

Specify SSAS Auto Process details.

PS6_AutoUpdate_Part4_SalesEx.PNG

Name the data flow.

PS6_AutoUpdate_Part5_SalesEx.PNG

The generated auto update data flow will reload source tables in parallel and then auto update data warehouse module including dimensions. Lastly it will run the auto process SSAS operation specified (i.e. "Auto Process SSAS by changes in Data Warehouse data").

PS6_AutoUpdate_Part6_SalesEx.PNG

 

 

- "Tasks and data" dialog box

In the "Tasks and data" dialog box; click 'Auto Update Data Warehouse'.

PS6_AutoUpdate_Part7_SalesEx.PNG

Then click Yes or No to indicate whether to include dimensions in the operation. 

PS6_AutoUpdate_Part8_SalesEx.PNG

Next, the user can modify which items to process along with settings for recalculation of items to be processed and stopping once an error occur. 

PS6_AutoUpdate_Part9_SalesEx.PNG

Note!
"Recalculate while Processing" will not check module dimension automatically if the only wide dimension tree source table is a single data source view; in effect leaving two levels of views between the module dimension and the source table(s) up for auto reload.
This issue might be fixed in a coming update. Until then users for server execution need to add an extra "Auto process DW" data flow activity or from the client click the Auto Update Data Warehouse again. This will correctly select the module dimensions in need of re-processing.

Note 2!
To enable auto update of fact tables; check "Auto update of fact tables" (PS 6.5).

PS6_AutoUpdate_Fact.PNG