Modules with Different UID Dimensions

Isha
Isha
in Modeling

Hi ALL,

I have three input modules, each with different UID dimensions:

  • Module A → Dimension: X_UID
  • Module B → Dimension: Y_UID
  • Module C → Dimension: Z_UID (also includes a dropdown line item with two options: Product X and Product Y)

Requirement:

  • If a user selects Product X in Module C, the record should be stored in both Module C and Module A.
  • If a user selects Product Y, the record should be stored in both Module C and Module B.
  • The only common field across these three modules is Location.

Do I need to create a mapping module, LOOKUP, or another approach be the best practice to achieve this?

Please Advice!

😀

Best Answer

  • Prajjwal88
    Prajjwal88
    edited February 12 Answer ✓

    Hi @Isha ,

    If I’m understanding your problem correctly, where the source data module is Module C itself (though I’m not entirely sure what kind of data needs to be recorded—maybe a screenshot could help), here’s an approach you can consider:

    Since the records will always be stored in Module C, you can:

    1. Create a separate line item in Module C to store the data using an action with a non-blank filter.
    2. For storing data into Module A and Module B, create mapping line items in Module C. These can be formulated using FINDITEM based on the concatenation of the selected Product/Product code (Whichever you're using for creation of list X_UID/Y_UID) in Module C and the corresponding UID which you can extract as you stated module C has dimension of Z_UID.
    3. Then, create separate actions for pushing data into Module A and Module B based on these FINDITEM mappings (again using non-blank filters).
    4. Finally, combine these actions into a single process so that everything runs with just one action button.

    Hope this helps!

Answers

  • lokeshm
    lokeshm

    @Isha can you provide the screen shots from the Anaplan .and storing the data means its should be stored as transaction or in any other way .

  • Isha
    Isha

    Hi @lokeshm ,

    Sorry for the delayed response and Thank you for your reply.
    I meant that the data is stored as transactional data.

    😀

  • Isha
    Isha

    Hi @ Prajjwal88,

    This sounds great, and it worked well. Thank you for your detailed steps and helpful response!

    😀

Categories