SUM when dimensionality is different b/w source & target in terms of "VERSIONS"

Hi, Anaplanners,

I have a question regarding how to SUM when a source has versions and a mapping doesn't.

In the attached file, what I am tyring to do in the target module is to simply sum by products.

As per what I understand is the formula "Source Module.Production Vol[SUM: Source Module.Product, SELECT:VERSIONS.Forecast]" doesn't work (this must show zeros) b/c the dimensions of the two modules are different in terms of VERSIONS. But I would like to keep the target "Not Applicable" in a bid to save model size. Would you provide me with some pointers ?

SUM_DifferentDimensionality_42445.xlsx

Accepted answers

DavidSmith

If you check Current? in the Versions settings, that is the value that will come across from the source automatically to the target when the source has versions and the target doesn't

David

All comments

DavidSmith

If you check Current? in the Versions settings, that is the value that will come across from the source automatically to the target when the source has versions and the target doesn't

David

VIGNESH.M

Hi,

In your Source Data, you have Date Dimension, So you need to include Time in your Formula

Try the below Logic,

Source Module.Production Vol[SUM: Source Module.Product, SUM: Source Module.Time, SELECT:VERSIONS.Forecast]

If Forecast version is your Current Version then you don't need to include Version in the formula

Source Module.Production Vol[SUM: Source Module.Product, SUM: Source Module.Time]

Photo1.png.jpg

~Vignesh

gregoryTan

Thanks David. Ive noticed why I couldnt sum the numbers was not due to dimensionality.

As you indicated, CURRENT VERSION came from the source in my case. Thank you.

gregoryTan

Thanks Vegnesh for your reply !

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…