Load monthly data into weekly time setting model

Dear Anaplanners

I have a dump question whereby I cannot get it over yet.

I have a model whose time setting is designed as weekly (for later stage replenishment planning)

While the demand forecast is still by month, so I have an import module to load monthly history sales dimensioned as below:

My source csv file looks like below:

But when I uploaded the data, time mapping looks weird. Not the regular month-to-month automatic mapping that I expected. Any thoughths, advice on this?

Thanks!

Cheers

Accepted answers

ManjunathKN

Hi @tingtingxia,

Firstly, we cannot import directly from monthly data to 4-4-5 Weeks time scale ( 4-4-5 weeks means, in one quarter, first and second month are having 4 weeks (4*7=28 days each) and last month will have (5*7=35days)) this does not work by months.

I will get back after the troubleshooting.

Thanks,

Manjunath

ManjunathKN

@tingtingxia ,

Can you remove the columns 4 and 5, since it is not mapped to anywhere and you have marked the mapping as column headers and Anaplan will consider this also as time.

I think it should work with the same mapping after removing the column 4 (item description) and column 5.

Edit: Keep the time mapping to Periods (Y-M)

Thanks,

Manjunath

tingtingxia

Hi @ManjunathKN

I checked my file again and removed "invisible" columns beyond the time horizon and now it works. Thanks so much for the advice!

But I used to think that we can have some redundant/not needed columns in the source file as long as they are not mapped. Or is it because I am loading monthly data into weekly model, hence the extra caution?

All comments

ShubhamCh

Hi @tingtingxia

I tried to replicate the scenario, but I couldn't. I see that in your screenshot Time dimensions' mapping is shown as a list mapping which shouldn't be.

Time dimension mapping looks like

while your model is showing it as a list mapping. Not sure why it is doing that. @ManjunathKN @Misbah can you please take a look at this?

Thanks!

-Shubham

tingtingxia

Hi @ShubhamCh

Thanks for checking this out. Below is how my initial mapping looks like based on the source file format I got.

Screenshot 2023-01-31 at 11.55.26 AM.png

Just add on here to see whether anything weird can be spotted here.

Cheers

ShubhamCh

Hi @tingtingxia

I don't see anything wrong with the mapping tab but only with the Time mapping tab and I don't have any explanation for this as this is the first time when I'm seeing this kind of behavior. I'll tag Anaplan experts. Maybe they can give a better explanation.

@ryan_kohn @JaredDolich @rob_marshall please have a look at the problem.

Thanks!

ManjunathKN

Hi @tingtingxia,

I will get back after the troubleshooting.

Thanks,

Manjunath

ManjunathKN

@tingtingxia ,

Can you remove the columns 4 and 5, since it is not mapped to anywhere and you have marked the mapping as column headers and Anaplan will consider this also as time.

I think it should work with the same mapping after removing the column 4 (item description) and column 5.

Edit: Keep the time mapping to Periods (Y-M)

Thanks,

Manjunath

tingtingxia

Hi @ManjunathKN

Thanks for helping out here! Really appreciate it. I deleted Column 4 & 5 and tried to upload again. Unfortunately I am still seeing the same thing. This does puzzle me quite a lot since I did work with weekly setting models but have monthly data load. This encountering is something I've never seen before.

Screenshot 2023-01-31 at 11.49.19 PM.png

Screenshot 2023-01-31 at 11.49.27 PM.png

Cheers

ManjunathKN

@tingtingxia,

You should not get this error. I had reciprocated the problem in my testing model and tested the scenario.

I believe there will be additional columns as column headers other than periods.

If you could send me the file, which doesn't contain original data, I will correct the file and send you sample one.

Thanks,

Manjunath

tingtingxia

Hi @ManjunathKN

I checked my file again and removed "invisible" columns beyond the time horizon and now it works. Thanks so much for the advice!

ManjunathKN

@tingtingxia ,

Great! Happy to hear that it works for you.

Yes, redundant columns are not a trouble unless it is not mapped. But, in your case you have mapped by mapping it through column headers. So, indeed the concept is correct but by mistake you have used those columns in mapping.

Thanks,

Manjunath

Quick Links

Can you help?

Unanswered questions

Sorting in Combined Grids
Hi Team, I have been trying to apply a sort based on a column in one of the combined grids and seems like the option is disabled. Does anyone has any idea on this? Regards, Aakash Sachdeva
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…