Use Custom Fixed position pattern for 13 periods of 4 weeks

On loading data into a module, the Time dimension Custom patterns are based around a true calendar month, 1-12. There isn't a custom mapping pattern for periods which where the system time is set to 13 periods of 4 weeks.

For instance, using custom YYYY_MM or YYYY?MM for the below data, would allow to load the data straight into a module (see example below). So 2023_01 —> P1 FY23, etc.

This will help with minimizing the need to ament the data source or building supplementary modules with fake time mappings to load the data.

A big thank you to @Tiffany.Rice for finding the relevant documentation.

2
2 votes

New · Last Updated

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!