I am trying to import a file manually. On the mapping tab in pigment the year column shows error. I tried various variations of the date format in my source file but the error is still not resolved. In pigment values for year dimension look like “FY 10”, I maintained the same date formatted structure in source file but the import did not work. I tried changing the year to look like “2010” in source file but that did not work either. what could be the possible reason for this error?
Best answer by Anas.Tahri
Hello,
If your date format is something like “FY 10,” you should customize the Year dimension during import by using the format "FY "yy
If the format is simply “2010,” then you should use yyyy
Hope this helps!
Hello,
If your date format is something like “FY 10,” you should customize the Year dimension during import by using the format "FY "yy
If the format is simply “2010,” then you should use yyyy
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
