Data import of different Dimension

Highlighted
Super Contributor

Data import of different Dimension

I apologise for asking a basic question.

As I have none to assist, so seeking assistance from Anaplan Community.

 

The Source Data Module has Yearly Values.

The Target Data Module will copy all the values in Weekly as well as Monthly.

 

Please assist me, if any Document is there in Anapedia, mentioning the way out.

Alternatively you request to suggest ways.

 

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Data import of different Dimension

Hi Sravan,

 

You need to create a system module to identify the year of the weeks and then use the lookup to bring the yearly data to weekly.

It's not an import, you need to pull the number through the formula.

001.png

Regards,

Vignesh M

Highlighted
Super Contributor

Re: Data import of different Dimension

Hi @Sravan_Kumar 

 

As mentioned, we have to convert yearly values into weekly values.

 

 

del1.JPG 

This can be achieved by using YEARVALUE() function.

 

Hope it helps,

 

Thanks,

Prabhu

Sorna Raja Prabhu
Highlighted
Frequent Contributor

Re: Data import of different Dimension

@Sravan_Kumar 

 

Also, if you need the target weekly formatted line item as editable, get the data to the weekly formatted line item with the formula (YEARVALUE(x) would do in your case) and import it another weekly formatted line item.

 

 

 

Thanks,

Sandeep