Skip to Content
0
Dec 11, 2006 at 03:23 PM

Exception Aggregation

21 Views

Hi, I'm having trouble with exception aggregation and hope someone can help. both my key figures are Global CKF and I have the 1st key figure working by setting Exception Aggregation to Minimum based on Log Date (seems to work for that key figure). No other settings are made on this key figure.

The 2nd key figure keeps showing up as a "3" and I want it to show up as a "1". Just a note: The expected value is always the same for a Process Chain.

Can anyone help? I'm on BI 7.

[Source Data]
Chain  		Log Date	Log Time	Last Run	Expected
Transaction	12/05/2006	16:01:30	7		0
Transaction	12/05/2006	16:03:18	7		0
Transaction	12/05/2006	16:04:18	7		0
 
Master Data	12/05/2006	16:01:30	7		1
Master Data	12/05/2006	16:03:18	7		1
Master Data	12/05/2006	16:04:18	7		1
Master Data	12/06/2006	16:01:30	6		1
Master Data	12/06/2006	16:03:18	6		1
Master Data	12/06/2006	16:04:18	6		1

[Desired Results]
Chain  		Last Run	Expected
Transaction	7		0
Master Data	6		1