Calendar type: 4-4-5, 4-5-4 or 5-4-4's restrictions

Mick

Hi all,

I have a question regarding Calendar type "4-4-5, 4-5-5 or 5-4-4".

When this type is selected, I can't any import files which have monthly buckets.

Only weekly or daily buckets can be imported into Anaplan my model.

But I can input and change monthly buckets' value directly on the model.

Do you know Calendar type "4-4-5, 4-5-5 or 5-4-4" has restrictions to upload files?

Thank you.

****

Accepted answers

ChrisWeiss

Hi ****,

That makes sense. The breakback is the reason for your issue, it would let you enter data at the Month level through the UI, but not load data to that level since it would be the incorrect dimension based on the line item settings.

I would say your options would be to either change the dimensionality of your line items to set them to the Monthly level (which may not be possible if your business process requires entering data both weekly or monthly), or to build a second set of module(s) that mimic the current modules but with all line items set at the Monthly level, to which you would load your monthly data. You would then need some formulas to aggregate and pull down the data to the Weekly level if necessary.

Happy to provide more details on that, hope that helps!

All comments

ChrisWeiss

Hi ****,

What is the time dimension setting for the line items into which you are importing your data?

Mick

Hi Chris,

The line item is weekly setting.

I can input and change value of monthly buckets on the screen,

so I expected to import monthly buckets data into the line item...

Thank you.

****

ChrisWeiss

Hi ****,

Thanks for the details, happy to help troubleshoot this. One more quick question, do you have breakback enabled for those line items?

Mick

Hi Chris,

Thank you for your support.
I use breakback enabled for those line items.

Thank you.
****

ChrisWeiss

Mick

Hi Chris,

Thank you for your reply.

That makes sence. Very helpful!!

Quick Links

Can you help?

Unanswered questions

ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…