Processing Measure Groups by changes in Fact Sources

Once a solution is up and running the need to reduce processing time soon emerges in many projects.

Profitbase Studio 6 has several builtin mechanisms in place to allow for reducing the amount of data being processed during an update of the solution data.

We will describe the use of one of these in the following.

 

Process changed partitions only

Go to the Solution management part of the application and select the Solution Partitions section of the navigation tree. 

Create a new partition definition. 

PS6_Change_Part0_SalesEx.PNG

Once "Save" is clicked a dialog allows you to specify a range of values.

PS6_Change_Part1_SalesEx.PNG

In this example I choose a monthly split interval.

PS6_Change_Part2_SalesEx.PNG

I then go to the measure group where the partition is to be used and specify the monthly partition I just created.

PS6_Change_Part3_SalesEx.PNG

Next I go the Fact Source Tables used by the measure group and specify the partition there.

PS6_Change_Part4_SalesEx.PNG

The Fact Source Tables are often reloaded incrementally.

PS6_Change_Part6_SalesEx.PNG

Statistics indicating when data changed is available for each individual partition boundary.

PS6_Change_Part5_SalesEx.PNG

I add a data flow activitiy for loading the fact source table incrementally.

PS6_Change_Part7_SalesEx.PNG

I add a data flow activity for processing the measure group when fact source table(s) data changed.

PS6_Change_Part8_SalesEx.PNG

PS6_Change_Part9_SalesEx.PNG

Lastly I add the data flow to a schedule.

PS6_Change_Part10_SalesEx.PNG