How to Use Lookups from Multiple Modules with Different Dimensions

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]

Isha

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"

Isha

@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

test - Please Ignore
Test - Please Ignore
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…