Year Value into a Months Module

logikalyan

Hello friends,

Can someone please help with this.

I have my number in the below source module (profit) by year.

I am trying to get FY24 value (profit) into below target module (i.e. 5,999) depersonalised by month:

I tried yearvalue() function and it is pulling all 0's.

Can somebody please advice?

Thanks

Kal

Accepted answers

All comments

Dikshant

I can see your GPS line item is a subsidiary view. Can you change the line item dimension to Months.

Kanishq17

Hi @logikalyan the dimension for time for lineitem needs to be months

logikalyan

Hi Kanishq, Dikshant,

Thanks for your responses. But not sure if I understand it correctly. Below is the full blue print of the line item. Its dimensionalised by month and the subsidiary view probably cos I added Region list to applies to column as Anaplan was throwing dimension mismatch error.

Thanks

Kal

SriNitya

Hi @logikalyan
From your screenshots
Source Module → Time( Year), X dimension
Target Module → Time (Month), Y dimension
X dimension → Y dimension in your logic you are not defining any mapping.
So look into the mapping and update your logic.

logikalyan

Hi SriNitya,

Thank you for your response. The source module X has Region as dimension which is a parent of Sector dimension in Target module in Y. So for this line item in target module Y, I have added 'Region' as dimension.

What mapping that I need to add more. Can you please advise.

Thanks

Kal

SriNitya

If I understand correctly
Hierarchy is L1 → Region
L2 → Sector
So for this line item in target module Y, I have added 'Region' as dimension. → Adding Region dimension is not required.
In Target Module Time (Month), L2 sector dimensions - GSP line item, no need to add Region
Create a system module for Sector and in one lien item derive parent mapping of Sector and then use that line item in logic of GSP using lookup.
I have one question what are volume(gross..), profit, revenue in your Source module(line item/ dimension?)

logikalyan

Hi SriNitya,

volume(gross..), profit, revenue are part of a LIS and used in target module.

Thanks

Kal

TimWard70

What is the summary setting on the line item in the source? If set to none & you are looking at a parent level in the target you will see 0

logikalyan

Hi all,

Thanks for all your responses. I have sorted this myself by adding the required dimension in applies to column and creating one more line item with formula. I then referenced this line item using yearvalue function which is working fine.

Thanks again

Kal

alexpavel

Having in a Time by Month module a line-item with the year and using LOOKUP could also solve the issue to reference Year values in a target module by month from a source module by Year.

Quick Links

Can you help?

Unanswered questions

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…
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.…