Hello fellow community users! I was wondering if anyone else had issues changing line item formula with lookup with the following error message: "format of mapping used for lookup doesn't match any dimension of the source" and what to do to remedy the situation.
i follow the step by step you provide and it so helpful i get the formula but when i enter/apply it the to the E2 i get an error which i attached. please help where is my mistakes? i have include those error as i try twice differently
Are you sure you followed the instructions step by? and that you understand the purpose of each step? Because it certainly works. Please reread the instructions step by step and ensure you understand why you are doing each step.
The First error message you screenshot about the automatic sum is usually caused by failing to provide a list item in your LOOKUP, that the target module is expecting (because it is dimensioned by that item's list). For example, which role you need the information for. When you don't provide a particular list item for a list used as the dimension in the source module, the Anaplan Engine assumes you want the data for all the roles in the list, That's why it looks for the Top Level as that where the aggregate information is. While adding a top level as suggested by
Will probably make the error go away, it doesn't mean it will produce the correct result. It is also against Best Practice to add a top level to lists if you don't need it causes performance issues. Check here to understand Top Level
A possible reason for the second error is that Bonus% has a non-alphanumeric, which means you have to single quotes around the name.
Einas "Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Dear community members Consider posting your question as a new topic and not in the thread of another topic/question. This help other community members to easily find the answer they looking for and doesn't cause the original thread to be so cluttered that we can't find what we are looking for