How to Use Lookups from Multiple Modules with Different Dimensions

SinduraDappili · 2024-12-01T02:48:08+00:00

There was an error rendering this rich post.

I have three modules with different dimensions:

Product Details:
- Dimension: 'Product'
- Line Item: 'Dispatched Qty'
- Formula I used is : 'Order Import Data'. Dispatched Qty [LOOKUP: 'Order Import Data'. FIND_PRODUCT]
Attributes Allocation:
- Dimension: 'Allocation ID'
- Line Item: 'Dispatched Qty'
- Formula is : 'Order Import Data'. Dispatched Qty[LOOKUP: 'Order Import Data'. FIND_ALLOCATION]
Record Key:
- Dimension: 'Issue Key'
- This module should look up the 'Dispatched Qty' from both the Product Details and Attributes Allocation modules.

Currently, I’m using this formula to retrieve data from Attributes Allocation:

Attributes Allocation. Dispatched Qty [LOOKUP: 'Allocation']

However, I also need to include the 'Dispatched Qty' from the Product Details module in the Record Key module's 'Dispatched Qty'. Since Product Details and Attributes Allocation have different dimensions, I’m unable to use a single LOOKUP on the same line item due to dimension incompatibility.

How can I configure the Record Key module to effectively look up data from both modules? Please advise!

Accepted answers

All comments

Dikshant

Do you have text-formatted product line items in the Record Key module? If yes, then create another line item (FIND PRODUCT) and formula FINDITEM(Product list, Product ID). then final formulla will be

Attributes Allocation. Dispatched Qty [LOOKUP: 'Allocation'] + Product Details.Dispatched Qty[LOOKUP: FIND PRODUCT]

SinduraDappili

Hi Dikshant

Thank you for the suggestion!
I've Product line item in the Record Key Module.

I have a question, The formula consolidates Dispatched Qty values from the Attributes Allocation and Product Details modules based on the respective mappings (Allocation and FIND PRODUCT) for each Issue Key.

Attributes Allocation Module:

Allocation ID

Dispatched Qty

A1	100

A2	150

Product Details Module:

Product

Dispatched Qty

P1	200

P2	300

Target Module ( RAM Key)

Issue Key

Allocation

FIND PRODUCT

IK1	A1	P1

IK2	A2	P2

Final Result in RAM Key Module:

Issue Key	Dispatched Qty (from Attributes Allocation)	Dispatched Qty (from Product Details)	Total Dispatched Qty
IK1	100	200	300
IK2	150	300	450

Dispatched Qty is 100+ 300 for IK1.

Dispatched Qty is 100+ 300 for IK1. Is this what our formula does? please advice?

TristanS

@Isha I'm a bit confused with the formulas you provided. From what I can tell the formulas for items 1 and 2 shouldn't even work. But you say that's how it has been setup? Can you please advise on the following:

What are the dimensions for the module "Order Import Data".
What is the line item format for FIND_PRODUCT in "Order Import Data"
What is the line item format for FIND_ALLOCATION in "Order Import Data"

SinduraDappili

@TristanS ,

Apologies for the delayed response—I missed your reply. I was able to resolve this on my own, but I appreciate your help. Thank you!

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…