Role not pulling through correctly when importing into the SYS08 Module.
I have changes the format to text and to role but it's still not working.
Please someone help an amateur anaplanner out!
I believe this could be to due to me categorising Role wrong in a lists but do not know where to put it and can't seem to put it in lists as a standalone like sizes.
I think i have updated the formulas correctly further down the line in the exam but now the formulas are crashing due to this role issue.
Somebody help please!
Hi @Dawsonc ,
Technically the locations of list doesn't matter, but it's good to have it among other related lists (employee lists in this case). Easier to find.
Is your "Role" list populated or is it empty?
Regards,
JussiLi
Hi @JussiLi , thanks for coming back to me.
I thought that the case with lists too but when i enter my formula i get the following message (part of message removed)
Invalid formula: Role hierarchy is not possible as Role does not have a built-in top level
But unable to build in a top level into this list
Thanks again
Problem can exist somewhere else as well, but let's check "Role" list first. Role list doesn't have parent hierarchy, but it should have Top level. (More information about Top level item and Parent hierarchy https://community.anaplan.com/t5/Best-Practices/Top-Level-Item-and-Parent-Hierarchy/ta-p/56249).
Top level should have been automatically created when list was updated from Role.csv file. The file contains fields: role, parent and code.
@Dawsonc
Ah, the dreaded top level error.
Make sure you roles list has a top level, in this case "All Roles". Easy to miss.
Keep going! You're almost done!!
Hi @Dawsonc
In addition to @JaredDolich reply, Please follow the below steps for you to get the correct role mapping to employees using roles list.
1. Assuming you've added Roles list and entered "All Roles" under Top level column -> Import Roles.csv file to get roles list items with corresponding codes.
2. Go to SYS08 Employee Details module -> Add a line item named Role and format it with Roles list shown in the below snapshot,
3. Go to grid view -> Data-> Import Employee details by Role.txt file and do the mapping in below manner(highlighted in black)
4. #E2 employees should automatically get mapped using the code and then SYS08 Employee Details Line items tab should be mapped to 'Role' line item in below manner,
5. Run import. You'll see all the employees getting correctly mapped to their corresponding roles.
Hope this clarifies your doubt.
Ajinkya
Hi, I’m experiencing a strange issue in ADO that I can’t seem to resolve. Before reaching out to Anaplan Support, I thought I would check with the community for advice. I’m trying to extract some list properties for an ADO mapping from a Polaris model/module. However, no matter what I do, I keep encountering the same error…
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…
