Get Monthly Data from Yearly Module

Hi!
I am quiet new to anaplan and I just got stumbled into this problem.

So I have 1 Module which has dimension of Malls(list) and year(list) and line item Revenue.

Then from that module I wish to show how many Revenue per Mall per month(the amount should be Revenue / 12). So I create Module 2, which contain mapping of what year(list) is what FY.

I also create Module 3, which has dimension of Malls and time period month also line item Revenue. This shall be the result module.
However, I cannot get the data from module 1 shown in the module 3 yet.

How can I link Module 1 to Module 3 with these modules?

Thanks a lot

Accepted answers

StevenBeerthuizen

Can you explain a bit more what you try to do in Module 2? Because i think that one should be with months in the dimension and a line item showing the year the months apply to. Then you can lookup to module 1 via the lookup module 2 and divide the result by 12.

deantari

Hi,

You were right.
Module 2 generally should be a mapping from Year(list) to Months.
I was trying to map it Year(list) - Year but ends up confused because the end result I want is still in Month time.

So I mapped the Month - Year(list) and it actually solved the problem.

something like this.

Again, thank you very much.

Regards

All comments

StevenBeerthuizen

deantari

Hi,

Sure! Module 2 shown like this.

Since Module 3 has Month FY as time dimension on it, I think I might need a mapping to know which year is which. Is this unnecessary?

Regards

deantari

Hi,

You were right.
Module 2 generally should be a mapping from Year(list) to Months.
I was trying to map it Year(list) - Year but ends up confused because the end result I want is still in Month time.

So I mapped the Month - Year(list) and it actually solved the problem.

something like this.

Again, thank you very much.

Regards

ChrisAHeathcote

Make this more efficient by mapping your year list to year time then map month time to year list. That way you will only have to mao years and the months will fall in line automatically.

Map year time as a dimension to your year list.

Then use YEARVALUE to map a year list set as a line item in a month time mapping module.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…