cancel
Showing results for 
Search instead for 
Did you mean: 

FIM 10.0 Period mappings

Former Member
0 Kudos

Hi All,

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.

Regards

Srikanth

Accepted Solutions (1)

Accepted Solutions (1)

Marc_Kuipers
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Srikanth,

I don't really see the issue here - the type on source and target are not the same.

So you can simply map

Time               PER

1/8/2015          2015.JAN

Now, if that date changes (i.e. 1/8/2015, 2/8/2015, 3/8/2015) then it becomes more complicated. You would have to use either some string manipulation (Substring) or you map the 30/31 values of the month to the same target

Marc

Former Member
0 Kudos

Hi Marc,

Yes, here the dates are changing as you mentioned (i.e. 1/8/2015, 2/8/2015, 3/8/2015), could you please let me know if there is any way to map these dates.

Regards

Srikanth

Marc_Kuipers
Product and Topic Expert
Product and Topic Expert
0 Kudos

Srikanth

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.

Marc

Answers (0)