FIM 10.0 Period mappings
We have a requirement where the Time in source system(Oracle) is in "1/8/2015" format and it should be mapped to Target system (BPC) where Time is in "2015.JAN" format.
Kindly share your views on this.
Marc Kuipers replied
You would get something like this:
As you can imagine, this will be terrible to maintain (365 lines, which need changing each year....)
I would recommend you customize something in DS, there you can do something with substr() and IF conditions
I.e something like
IF (substr(date, 1, 1) = "1" and substr (date, 5,4)="2015")....etc.