2.3.8.2 Import into DEM01 Module

I seem to be having an issue uploading my data into this module.

The module is set to month, yet when I try to set the import period, it is in weeks:

Separator can be any non-alphanumeric character
Y represents year number (1, 2 or 4 digits)
W represents week number in year

Further, entering a custom format of YY?MMM to match the .csv header, or any variation there of, produces this error: "The custom format is not valid for this import"... what is going on here?

Accepted answers

ChrisAHeathcote

Unlike the applies to the module setting dies not automatically configure the line items.

Lookout for a small icon which looks like a little grid by the line item name. This indicates that the line item is set up differently to that of the module.

If the line item was set to weeks by default this would suggest that the time frame used is set to weeks. Check your default calendar in time setting.

KirillKuznetsov

@jadefortunatogood, I was expecting that my question will help you understand if something is not matching 🙂

Chris explained well the idea of this which is also called as "subsidary view". You can check out more details about this in the following lesson https://community.anaplan.com/t5/On-Demand-Courses/Subsidiary-Views/ta-p/63627

All comments

KirillKuznetsov

@jadefortunatoplease provide a screenshot of the brueprint of your module. Might be that you have selected months for module but not for the line item or the other way around.

jadefortunato

Based on your question I found the issue when I went into the blueprint view. The line item Growth % was set to weeks, though I'm not sure why, when I set the module to months after creation. Does changing a module timescale not change the line items within it?

ChrisAHeathcote

Unlike the applies to the module setting dies not automatically configure the line items.

Lookout for a small icon which looks like a little grid by the line item name. This indicates that the line item is set up differently to that of the module.

If the line item was set to weeks by default this would suggest that the time frame used is set to weeks. Check your default calendar in time setting.

KirillKuznetsov

@jadefortunatogood, I was expecting that my question will help you understand if something is not matching 🙂

jadefortunato

Thanks @KirillKuznetsov !

jadefortunato

Thanks @ChrisAHeathcote !

jadefortunato

The overall calendar IS set to weeks. I was aware of this, but since there was no instruction to change that, I left it. The issue came down to the line item, which I guess I assumed would take the module's setting, not the calendar's.

Quick Links

Can you help?

Unanswered questions

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…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?