Skip to Content
0
Former Member
Aug 02, 2016 at 08:07 PM

BEx Query based on 0EMPLOYEE infoprovider

85 Views

Hi, all!

I created a BEx Query over characteristic 0EMPLOYEE. This BEx Query calculates "Average Hourly Salary" which is the result of "Annual Salary"/"Annual Working Hours". Both of them are time dependent attributes of 0EMPLOYEE.

When I refer to "Annual Salary" I mean standard infobject 0ANSALARY which definition is the following (aggregation tab):

- Aggregation: SUM

- Exception Aggregation: LAS Last Value

- Agg.referen.char.: 0CALDAY


When I refer to "Annual Working Hours" I mean a Z infobject which definition is the following (aggregation tab):

- Aggregation: SUM

- Exception Aggregation: SUM (Summation)

- Agg.referen.char.: -

I'm getting warning message "Exception aggregation reference characteristic 0CALDAY not in Infoprovider 0EMPLOYEE" when saving the BEx Query.

Message description indicates: Characteristic 0CALDAY is not included in InfoProvider 0EMPLOYEE, therefore it is not possible to apply the exception aggregation of key figure 0ANSALARY ( SUM LAS ). The key figures will therefore be aggregated using all characteristics of 0EMPLOYEE with generic aggregation. To be able to perform exception aggregation, add characteristic 0CALDAY to InfoProvider 0EMPLOYEE.

I'm using a key date in the BEx and I expected this key date to guide the "time" of 0EMPLOYEE master data, but it doesn't seem to be working in that way. I need the average to be calculated with the annual salary and the annual working hours that the employee used to have at the Key Date.

Which would be the correct solution for this scenario?

Thanks in advance.

Regards.

Juana