Error in Import - Expected 2-digit month number in date/period
This might be simple but I do not get why it is having an error. So I have 2 identical modules. I have IC PNL and AIC PNL. They are both identical in terms of dimension and line items. So what I am trying to do is import IC PNL to AIC PNL that simple. Whatever numbers is in the IC PNL should be the same as the numbers in AIC PNL. I am getting this error, see below:
This is the current settings in TIME that I have. I tried the custom format as well as match names and it is still not working.
And also the figures are doubled up. ANy ideas on this issue?
We are using the same time range however there is a Dimension in the IC PNL which is not needed in the AIC PNL that we removed.
This Dimension is only present in the IC PNL but not on the target AIC PNL. Is this what is causing this problem? We cannot include this column because it is not the same version as AIC PNL. I hope that makes sense. So in the mapping part we removed it.
Any ideas on importing the data to a Target module without this version present?
Appreciate the response. They do have the same timescale, however, in the IC PNL module we have a dimension which we do not need to use in the AIC PNL. It is the process flow dimension. Is that why I cannot use the match names?
Highlighted below is the dimension I am talking about. This is not present on the target module since AIC PNL will have a different version. Is this why I cannot use the Match name option? Because the error with the match names it prompts on looking for that dimension.