Skip to Content
0

how to nullify headcount for past months

Oct 18, 2016 at 08:57 AM

88

avatar image

Hi,

I have headcount data in cube YPA_C01 for an employee from calmonth 082016. The employee's joining date is 16.08.2016.

Now the employee's joining date is changed from 16.08 2016 to 24.10.2016.

how to nullify headcount from 1 to 0 for old data (for calmonth 08.2016, 09.2016, 10.2016 )

Rgds,

Rathinakumar

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sourav Banerjee Oct 18, 2016 at 11:10 AM
0

Hi,

You can create a copy cube, load it from the original cube using transformation. Add headcount = 0 in the rule for those customers. Delete those employees from the original cube. Load these employees from new to old cube.

Share
10 |10000 characters needed characters left characters exceeded
Francis Yesudas Oct 18, 2016 at 12:05 PM
0

Can you not do selective deletion of this record for calmonth 082016 / employee no from the cube? And then do a repair load of the employee information from the source again with the new joining date?

Share
10 |10000 characters needed characters left characters exceeded