Time treated as common list on Import Action

paolovm

Hi,

 

I am loading a CSV into a module that has simple time list at month level – however the import action is treating TIME as a common list rather than allowing to do the specific time mappings as expected. Im sending below the details with all the screeenshots I believe are necessary to help understanding the issue.

 

Here is the CSV in notepad

 

Here is the module blueprint showing that time is indeed from the native functionality with Month granularity

 

 

Here is the source file mapping

 

 

Here is the import itself and what appears in the main tab

 

 

 

And here is the issue. Instead of allowing the customized time mapping it is forcing me to match by name or manually.

This is what I would expect instead of what I find in ITEM 5

 

Ive allready tried creating the same action for different module with same lists – same result.

 

Please let me know if anyone need additional info

 

Regards,

Paolo

 

 

VIGNESH.M

Hi @paolovm @Harsha 

 

We have duplicates in the Time period, this is causing the problem. 

 

#1. I tried to load this file without making any changes and seeing the system taking time as a flat list, also highlighting the duplicates

#2. Removed the duplicates, the system is recognizing the Time Period and I am able to load the month values successfully, year values are getting ignored as expected.

Here is a simple month example,

#1. With unique months, am seeing the right mapping.

#2. With duplicate months, the system showing the duplicates.

 

When we have duplicates in the Time Dimension, the system cannot identify the one to one mapping and we need to manually do the mapping.

 

Thanks,

Vignesh M