nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Different Dimension of two different modules

PrevContributor

Hi, How can we manage to move data from one module to another eventhough thier dimensionality is different? Is there any standard solution approach to this? Regards Wasim Nasir

Accepted answers

leo_tadjudin_1

Hi Wasim,

This typically can be achieved if there is some sort identifier between the two dimensions, for example: Product and Segment. A product could have Segment as a property.
So when you have data in the 1st module by Product and you want to sum the data by Segment in the 2nd module, you can write something like this:

Line Item in 2nd module = '1st Module'.'Line Item' [sum: Product.Segment]
Give it a try. Let me know if it works.

Regards,
Leo

All comments

PrevContributor

[quote=Wasim Nasir]How can we manage to move data from one module to another eventhough thier dimensionality is different?
[/quote]
Hi Wasim,
Can you explain what you are trying to do in a bit more detail? Do you mean you want to copy data, or you want to refer to the same line item in another module?
Thanks

leo_tadjudin_1

[quote=Leo Tadjudin]Hi Wasim,

This typically can be achieved if there is some sort identifier between the two dimensions, for example: Product and Segment. A product could have Segment as a property.
So when you have data in the 1st module by Product and you want to sum the data by Segment in the 2nd module, you can write something like this:

Line Item in 2nd module = '1st Module'.'Line Item' [sum: Product.Segment]
Give it a try. Let me know if it works.

Regards,
Leo[/quote]Thought I should add in some screens for more clarity.

Let me know if it works.

Regards,
Leo

Prineet

Hi Can you please Tell how can i bring Revenue by Product by Time( Ist Module) to Revenue By Time level( 2 nd Module) .

Thanks

Juliani

Hi Leo,

This is fine when you have like max 10 line items, but if you have 200 line items in your module it becomes so time intensive. Is there a way I can link two modules that have 1 different dimension using maybe a subset? As both modules have the same line items I can easily link them together through a subset but I don't get how to write the formula. Thanks.

Quick Links

Can you help?

Unanswered questions

Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
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.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…