cancel
Showing results for 
Search instead for 
Did you mean: 

Exception Aggregation - Performance

Former Member
0 Kudos

Guys,

We have a query with ten calculated key figures and all of these have exception aggregation of summation at material level. Currently for just one plant the query is taking 8 minutes of time which is too bad.

These 10 CKF's caluculate different types of stock values..all these have summation as exception aggregation. The price is calculated on the fly by using replacement path attribute value. Any suggestions on how to increase the performance of the query or any other approach to handle this scenario.

stock value 1 = quantiy1 * price1.

.

.

stock value 10 = quantiy10 * price10.

Please let me know if you need more info.

Thanks,

Varma.

Accepted Solutions (1)

Accepted Solutions (1)

michael_devine
Active Contributor
0 Kudos

Hi Varma,

Make sure that you have these Notes in the system:

1416737

1387593

1396485

Regards,

Michael

Answers (0)