Import without errors and warnings (extra columns in headers and times)
I want to bring up the next topic. Best practices and guides suggest that all imports should go with a green check mark, without warning. If there is a warning or an error, then something went wrong and the administrator must intervene.
But I found a case where I don't know how to achieve this without terrible workarounds.
The fact is that I have a template that users unload from the system, fill in and load back. The template has approximately the following columns:
Dimension 1 (code) - used for mapping in action
Dimension 1 (name) - not used in the download, reference information for the user (not everyone knows the codes, it is inconvenient to work with them)
Dimension property 1 (unloaded through labels, used for the convenience of the user when filling out. This can be a mapping to an old dimension or some kind of auxiliary information, such as a store opening date or PL line type)
And several columns in the month-year format (our anaplan time).
An example of such a template is in the attachment.
The problem is that when setting up the loading mapping, I indicate that the time is in the headers and also explicitly indicate the mapping for column 1 (reference code). At the same time, I need to ignore the additional information, but I cannot configure this, because time measurement has its own special mapping. And I cannot set certain columns to ignore in it.
As a result, extra columns lead to the warning "this element does not correspond to the time dimension". What are some tips to get rid of this warning? At the same time, there is no need to force users to delete unnecessary columns before loading or somehow break the template.