Lookup based on a boolean line item

Hi, I have a target module INP01 with 5 dimensions (P1, C5, Size&BPC, Time, and Deal Levels) and I need to bring values from another module DAT05 which has 4 dimensions (P1, C3, Size&BPC and Time)

The point is that it needs to be done based on a boolean line item selected month? in DAT05 (which is true for the month selected in another module), bring the values into INP01.

INP01 Module:

DAT05 Module:

I've tried using this formula: It returns: Level mismatch on common dimension

IF 'DAT05 Pricing Data in Representative and Size + BPC'.Selected Month? THEN 'DAT05 Pricing Data in Representative and Size + BPC'.FOB ELSE 0

I know both modules share P1, SizeBPC, for the customer family: C3(from DAT05) and C1 (INP01) but they don't share Deal Levels dimension that is in INP01 (Target).

Any idea on how to bring the values from DAT05 into INP01?

Thanks

Accepted answers

All comments

ankit_cheeni

In your DAT05, create a FOB Staging line item that has values when your selected month is true. SO something like 'IF Selected Month then FOB else 0'

Then if your INP01 module, directly refer to FOB Staging while looking up on a C3 formatted line item dimensioned by C5. Basically you need to tell Anaplan which C3 value should it look against when getting the value for a C5. Your INP01 formula would then be something like - 'DAT05 Pricing Data in Representative and Size + BPC'.FOB Staging[LOOKUP: SYS C5.C3 Mapping]

JoanZ

@ankit_cheeni for the mapping part, should I create line items list formatted with C5 in DAT05? if this is the case it returns: Level mismatch on common dimension

I do not understand the logic in the mapping part of my problem.

ankit_cheeni

Create a separate system module dimensioned by C5 and create a line item that is C3 formatted. I’m hoping C3 and C5 are part of a hierarchy so parent(parent(item(C5))) as a formula in the line item should give you C3 corresponding to each C5. Use this line item in LOOKUP.

JoanZ

@ankit_cheeni I really appreciate your help,

Mapping worked, but it shows zeros instead of 57.31 for the House DD column.

The value that should bring into INP01.

Could it be related to the other dimension that my target module has Deal Levels?

Thanks

ankit_cheeni

Is time not a common dimension? Check your messages

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…