Hello,
When datasource 0HR_PA_0 (headcount) is loaded into the cube 0PA_C01, the 'number of employees' key figure populates the values in a query. Once datasource 0HR_PA_1 is loaded into the same cube for the same employee in the same month where an action exists (e.g. hire action), the 'number of employees' keyfigure become zero.
We are on BI_CONT 703 patch level 12 and sap_bw 700 patch level 18.
Settings for the No. of employees (0HDCNT_LAST) is: Aggregation = 'SUM' and Exception aggregation = 'Last Value'.
However when I change the Exception aggregation to 'Summation', the query displays the correct value for both 'number of employees' and 'Number of actions'.
I would appreciate it if you assist me on this.
Thank you
Murali