Multiple Lookups into DATA... module?

I have 3 hierarchies, Customer (C1-C9), Developer (D1-D3) and Product (P1-P6). I also have a combined list C10 which is C9_D3_P6.

I have a DATA Rebates module with a LOAD list dimension and properties for C6, D2, P3.

I have a reporting module with C10. I've also got a PROP C10 module with line items for each of the items in the relevant hierarchies.

I want to create a formula within the reporting module that can lookup the values in the DATA Rebates module however I'm not sure I can do it easily.

Do I really have to create another combination list item (and associated views/actions etc) for C6_D2_P3? Is there a better way of doing it?

Accepted answers

andrewtye

Then I think your only option might be to create that C6/D2/P3 combination list and have the middle module again

or you ignore planual and do lookup/sum in the same line item 💣️💥

All comments

MayraS

Just a clarification question,

Report Module is using C9_D3_P6

DATA Rebates has C6 (parent of C9), D2 (Parent of D3), P3 (Parent of P6)?

How do you want to populate DATA Rebates to your Report Module?

GeorgeDuckett

Sorry, not too sure what you're asking here. You're correct that C6 is a parent of C9 (via C8 & C7), D2 is a parent of D3 and P3 is a parent of P6 (via P4 & P5).

Ideally I'd want the figures in DATA Rebates to get into the Report Module via some formula (with an intermediary module if needed), rather than having to create a new list just for this purpose.

andrewtye

Hi @GeorgeDuckett

What does the DATA module look like? Sounds like it's dimensioned by some other list but those have properties of C6, D2, P3.

If so what i'd probably do is have a module that's dimensioned C6, D2, P3 and do a standard sum against the DATA module line items

Then you can just do lookup in the reporting module against the module you've just created using your property module.

Unless of course i've got the wrong end of the stick!

MayraS

hi George, instead of creating a new list, I think you can make a line item to define the C10 (finditem) in the DATA Rebates module based on the C6, D2, P3.

then you can take the value and sum by the C10 line item

Do you think this will work?

GeorgeDuckett

You're right about the DATA module, yeah. It's dimensioned by a list for data import, then with properties C6/D2/P3.

Sorry I should have said, I can't do a module with C6/D2/P3 as the number of combinations is too high.

I can't create a line item int he DATA Rebates module because the C10 item relates to items at the bottom of each hierarchy, whereas C6, D2 and P3 are in the middle, so don't relate to a single C10 item.

andrewtye

Then I think your only option might be to create that C6/D2/P3 combination list and have the middle module again

or you ignore planual and do lookup/sum in the same line item 💣️💥

GeorgeDuckett

Ahh ok, that's what I feared. Thanks for your help!

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…