Load monthly data into weekly time setting model

tingtingxia · 2023-01-30T07:34:18+00:00

There was an error rendering this rich post.

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

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…