Get Data from a module with dimensions to a module without dimensions

jakerlund · 2025-03-07T13:34:12+00:00

There was an error rendering this rich post.

Hello,

I have a module with dimension "Invoice Number", in this I have Start Period and End Period for the invoice (it can cover multiple months). In another module without dimensions I want to be able to show which Start Period and End Period a invoice have based on if a boolean is true in the first module. Does anyone have any ideas on how to build this?

Accepted answers

devrathahuja

@jakerlund - In that case, I assume you want to select any 1 invoice & show the break-down of that invoice, you can achieve it as follows-

Module 1 : Source Module-

Summary of Invoice # line item is firstnonblank

You can also add a DCA such that once 1 invoice is selected the user cannot select any other invoice.

Module 2 : Target without the invoice dimension-

You can then use lookup on the invoice number to fetch any data associated with this invoice.

jakerlund

Thank you @devrathahuja ! Works great

All comments

devrathahuja

Hi @jakerlund ,
Do you also have time dimension in the first module or are the start & end period a line item formatted with time period?

In module 2, when you mention "without dimensions" - Do you mean without the invoice number dimension as well?

jakerlund

Hello @devrathahuja

In the first module start & end period is a line item formatted with time period.

For module 2, exactly, it does not have the invoice number dimensions.

To further elaborate the use of it will be to filter my data module to show what data (resources, hours) is in the chosen invoice, and the "invoice number" list are dummy invoices so they are not possible to include in the data import.

Thank you

devrathahuja

@jakerlund - In that case, I assume you want to select any 1 invoice & show the break-down of that invoice, you can achieve it as follows-

Module 1 : Source Module-

You can then use lookup on the invoice number to fetch any data associated with this invoice.

jakerlund

Thank you @devrathahuja ! Works great

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
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…