Convert Date to Period
Has anyone had success taking a date, say 12/2/2024, and the cube name I assume, and converting it to a period like 2024M12?
Forum Discussion
This was my my frist thought but then quickly considered the case of non-calander year end time profiles. In such cases this would not work I think.
I think you can add some additional conditions to handle that. Alternatively, if you can share an example here, I can take a look and help.