Model Builder Level 1

I changed the format in the Code line to text and it worked.

Thanks Tiffany

All comments

@Jacob3 - Try modifying the source to target mapping on the import. E2 Employees# should map to the code - this is the unique identifier that indicates which employee is being referenced in the data. Line items should be mapped to column headers.

Hi Tiffany,

I modified the source to target on the modifying at the import. But do not think I have got it right. I mapped the E2 Employees# mapped to the code. The Country details and SYS08 details is not correct. Not sure how to fix.

I have attached the updated screenshots.

Appreciate all your help.

E1_Departments_View_118034.jpg

Blueprint_View_118034.jpg

SYS08_Emp_Details_View_118034.jpg

Line_Items_View_118034.jpg

G2_Country_View_118034.jpg

E2_Employee#_View_118034.jpg

Mapping_View_118034.jpg

@Jacob3 - the blueprint view on SYS08 doesn't look quite right. You have different "Applied To" on the individual lines but in order for the module to operate as intended you should be applying a consistent dimensionality (i.e. Applies to) through out. All line items are defining attributes of E2 Employees#. For highlighted items, set the applies to as a "-" meaning the same list applies to all line items.

SYS08_Employee_Details_Line_Items_View_118114.jpg

Thanks Tiffany.

I made the changes you highlighted and ran it again. Have attached screenshots after updates.

Also what are those little squares besides the List name in the List view. In the course work page that is not present.

Another general question - community related. I am not familiar how this community thing works. Is this post viewed such that everyone can view. Reason I asked is, if that was the case I can get help regardless of what time of day/night I post.

Import_Failure_Summary_118114.jpg

Blueprint_View_118114.jpg

Line_Item_View_118114.jpg

E2_Employee#_View_118114.jpg

Mapping_View_118114.jpg

Import_Failure_Details_118114.jpg

@Jacob3 the little square indicate that the line item is a "subsidiary view" which means it is setup with a different dimensionality then the rest of the module. If you look at the blue print you will see that the Applies To for those lines is blank - all line items need to be have the same list E2 Employees applied (this is the cause of your import error). Anaplan will do this by default when you create a new module, these subsidiary views only occur when you change the Applies To in the blueprint mode.

Community posts are open to all members day and night. This is not a manned support line but rather a platform for Anaplan end users to interact and help one another along the way. Welcome to the community and good luck with your journey to become a model builder!

Thanks for your guidance.

Before I make the changes and run it again I have a question.

Should the "E2 Employees#" be on the SYS08 Employee Details" line (Blueprint view)

Yes, the applies to notes on the SYS08 Employee Details line indicates the setup for the module itself. This would reflect the lists that you selected when you setup the module. By default this gets applied to every line item unless something else is specifically entered within the applies to section for that line item. See below - this is the correct setup. The circled bit is what tells you that the default for the module is being applied to the line item.

SYS08_Employee_Details_from_Employee_View_118122.jpg

Thanks.

I made all the changes and still have some error msg. Please see attached screenshots.

Results_Summary_View_118122.jpg

Line_Details_View_118122.jpg

Blueprint_View_118122.jpg

E2_Employees#_View_118122.jpg

Mapping_View_118122.jpg

Result_Error_Details_View_118122.jpg

Make sure all line items are mapped in the import action. See below - highlighted items are not mapped because the column header is not equal to the line item. Selection option to manually map and then ensure every column header is either mapped to a line item or set to be "ignored" in the import action. This is a critical step in every import setup action so you will want to get very comfortable with this process and ensure you are reviewing this tab in every import action that you setup.

SYS08_Employee_Details_Line_Item_View_118131.jpg

Almost there. The salary details are still showing in the "Code" line which should not. How do I fix that?

Line_Details_View_118131.jpg

SYS08_Employee_Details_Line_Item_View_118134.jpg

Thanks Tiffany for all your help.

I imported the data after changing "Which target items to clear prior to import? to "All mapped items" (See highlighted text) and the salary is replaced by zeroes on the line item named "Code". It should be blank as per the Level 1 Model Builder screenshot.

Appreciate any help I can get so I can use the weekend to progress in my learning

Line_Details_View_118134.jpg

I changed the format in the Code line to text and it worked.

Thanks Tiffany

Dear Anaplan family

i am also on 7.2.3 level 1MB, see my blue print below and the results i get after doing everything to my best of knowldge i still cant get the desired outcome