Before Aggregation in Bex

[Former Member]

Hi,

My query is at a Calmonth level but I have to do the calculations at the Calday level.

OverTime = Actual Hours - Planned Hours

I have Cal Day in my MultiProvider. How can I use Before Aggregation in the query so that I can achieve the calculations at a day level.

Thanks

Deepthi.

[Former Member]

Hi Deepthi,

Use Exception aggreation for the key figure calculating OverTime.

with reference characteristic as 0CALDAY.

If you are in BEx 3.x, you may creat a new calculated key figure , with the original key figure and in the properties of this calculated key figure, you can exception aggregate using enhanced properties...displayed with a button below...

In BEx 7.x.. you can create a new selection and in aggregation tab in the selection properties mentione the exception aggregation as Sum with reference characteristic as 0CALDAY.

Hope this helps,

Best regards,

Sunmit.