Level 1 Model Building Certification Exam : Unable to format Roles as List in SYS08

I am having an issue with the Role list. When I try to format the Role line item in SYS08 it gives me this error: Format of mapping used for lookup doesn't match any dimension of the source. I've attached a screenshot of the blueprint.

I've had no luck fixing this issue and I'm going on hour 4 of trying to finish this exam. Hoping someone can help me out of this rabbit hole!

Thank you!

SYS08_66128.png

Accepted answers

bambrose

Also, I understand what the formulas need to be in EMP02, but I think this format issue in SYS08 is causing the error when I try to update the formulas in EMP02: Data type mismatch: format other than LIST or DATE being referenced as a relation.

Attachment of screenshots of EMP02 and EMP03 included for reference.

EMP02_66134.png

EMP03_66134.png

All comments

bambrose

Attachment of screenshots of EMP02 and EMP03 included for reference.

EMP02_66134.png

EMP03_66134.png

prabhu

Hi @bambrose,

I am not sure, whether have you got the solution for your question.

But what are all the steps that you have to follow to overcome this problem are listed below.

Step 1: Copy your formula from Bonus line item in EMP02 Empoyee Expenses module.

Step2: Delete the formula from Bonus line item in EMP02 Empoyee Expenses module.

Step3: Change the format of Role Line item from Sys08 Employee Details Modules from TEXT to LIST FORMAT (ROLE)

Step4: Paste the formula in Bonus line item in EMP02 Empoyee Expenses module.

Line item Format within Lookup(For Mapping) should be only List or Time Period not Text

Number or Boolean or date or time period or list or text [Lookup: List or time period]

Read this : https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/LOOKUP.html

Thanks,

Sorna Raja Prabhu

ajay2021

Thank you so much just adding if you have pasted the same formula to other line items like a phone bill, Medical cost please remove them as well this will not allow making changes from number to list.

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…