Importing into SYS08 system module

kunal_311

I am confused with the mapping part of the source to target as well. As is where to map

Active?

Employees = Code? ( Because it is numbered list)

Dept Code = Department?

Country Code = Country?

Active? =?

How to make sure data we are mapping is correct?

Accepted answers

filip.sypniewski

Hi @kunal_311,

when it comes to mapping Employee - Code, because it is numbered list. This is something you need to map on the 'Mapping' tab. Please select Code to map the Employees correctly, make sure that on tab '#E2 Employees' all of them are mapped. So, you dimension in your SYS08 module are Employees, and you are loading attributes of your employees, like Code, Start Date, Salary etc.

Now, looking at the Line Items.

Active? -> what is your source? is it saved view of a module? probably Data Hub? I assume Active? is only used as filter, to filter out employees who are not active. You do not need this information really. Else, if you need it, then would create boolean-formatted Line item in your SYS08 to map it. Does it make sense?

Employees -> I believe it is name of an employee, probably it needs to be mapped to the 'Name'

Code can be retrieved via formula in your system module. Please see: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/CODE.html

Department Code & Country Code you are mapping correctly to Department and Country respectively.

Please let me know if you have any additional questions!

filip.sypniewski

Then, in principle, you do not need to have this line item in your system module.

If you want to add it, open blueprint in your SYS08 module, and click + button to create new line item.

All comments

filip.sypniewski

Hi @kunal_311,

Now, looking at the Line Items.

Employees -> I believe it is name of an employee, probably it needs to be mapped to the 'Name'

Code can be retrieved via formula in your system module. Please see: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/CODE.html

Department Code & Country Code you are mapping correctly to Department and Country respectively.

Please let me know if you have any additional questions!

kunal_311

Thank you for such a detailed explanation.
All points understood.
Regarding Active? =you are correct, it is used as a filter to filter out among all the employees who are active, throwing result TRUE & FALSE in source file but in my target file in course, it did not mentioned anywhere that active? is one of the line item we need to add.
If i want to add it then how to go about it?

filip.sypniewski

Then, in principle, you do not need to have this line item in your system module.

If you want to add it, open blueprint in your SYS08 module, and click + button to create new line item.

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…