Tracking employee\asset moves

I'm looking for a way to track employee movements. I have a transaction table to that includes Employee Number, Cost Center and Month values. Is there a way that I can look up the Cost Center that was assigned to an employee from a previous month? I know there is a PREVIOUS function that can pull numeric values, but wasn't sure if there was something similar that can pull the list member for a certain period.

Thanks

Accepted answers

rob_marshall

@OSUBlakester

Blake - create a module Employee Flat on the rows, Time across the top, and a line item formatted as Cost Center. This way, you will be able to track the cost by time for each employee.

Rob

All comments

helennie

PREVIOUS() works with list formatted items as well, see:
https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/PREVIOUS.html

In order to use it, you need a data module dimensionalized by Employee and time (native Anaplan timescale), not just a transactional data table with Month as one of the line items. If the data is already in your transaction table, you may just need to pull it into a new dimensionalized module, then you can use PREVIOUS() to compare.

rob_marshall

@OSUBlakester

Blake - create a module Employee Flat on the rows, Time across the top, and a line item formatted as Cost Center. This way, you will be able to track the cost by time for each employee.

Rob

OSUBlakester

Hey Rob,

Thanks for the quick response as always!

I hear what you are saying. I think my problem is that I currently have my Employee list set up where the Employee is a child of a Cost Center. (using the combination of Employee Number and Cost Center as the Code). The same employee could exist under different cost centers. This allows me to keep history when employees move. I think what I need to do is create another Employee list without the Cost Centers and then use that to track the history.

I'll give that a try.

rob_marshall

@OSUBlakester ,

You are correct, try creating just a flat Employee list which stores all of the metadata for the employee (hire date, name, etc.) and then another module as I described above. Now, to create the hierarchy, with the employee ID at the base, you could create your cost center hierarchy (call it L1->L5) and then create a module dimensionalized by Cost Center L5 by Employee by Time. Then create a filter which references the Cost Center line item in your Employee by Time module. This way, you see the which employees roll up to a cost center for a particular month.

I used cost centers here as the base, but you would use Employees

In the "join" module, again you would substitute CC L9 Flat with your Employee Flat list

And create the following filter:

The results are:

Hope this helps,

Rob

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…