Data Import Time dimension
Hi,
I need a bit of help. I have a file of the following structure, with Time dimension going across as column headers. The system is setup to 13 periods of 4 weeks.
When I try to load the data using Custom Fixed position pattern: YYYY_MM, it fails with an error:
- Invalid period for format YYYY_MM
When I try to load the data using ? in Custom Fixed position: YYYY?MM, it fails again with an error:
- Invalid period for format YYYY?MM
Is there a way to load the data in its current format or the Time will have to be updated to P1 FY23?
Thank you
Best Answers
-
Hi Dimitri,
I didn't have this error before, but when I replicated it, I saw that separators and fixed patterns don't work with the 13-period calendar. As you mentioned, the only option in this case is to match names (e.g., FY23).
You can open a support ticket to figure out what is happening.
I hope this helps.
Seyma π·π
1 -
From the Anapedia documentation, , I gathered that the custom patterns are based around a true calendar month, 1-12. There isn't a custom mapping pattern for periods which is what I think be what you would need when dealing with that type of timescale.
After you consult with support to confirm if this is indeed the intended behavior and there is only currently the option to match formatting exactly, you may consider raising an Idea for a future platform enhancement. If you are facing this challenge I'm sure others are too!
2
Answers
-
Thank you seymatas1! Appreciate your feedback. I'll log a ticket to understand why it doesn't work. In ideal case Id prefer not to change it.
0 -
@Tiffany.Rice This is brilliant! Thank you for the research! I'll log it in the idea exchange.
1