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

Highlighted
Contributor

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 ?

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

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

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

Highlighted
Contributor

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

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.

Highlighted
Master Anaplanner/Community Boss

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

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]

 

OR

 

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

 

 

Contributor

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

Thanks Vegnesh for your reply !