Skip to Content
avatar image
Former Member

how to nullify headcount for past months

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 18, 2016 at 11:10 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2016 at 12:05 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded