Conditional mapping script query

reachsubbiah Jan 15, 2013 4:45 PM

Hi All,

For Account dimension, we have both Explicit and Like mapping. In the like mapping we have one script If varValues(15)<>"2000" Then Result = "4001" Else If Left(varValues(21),1)="1" Then Result = "4000" Else Result = "4001" End If End If.

I know that varValues(15) is nothing but source entity and I would like to know Left(varValues(21),1)="1" defines which dimension?

Thanks,
Sanjeev

1. Re: Conditional mapping script query

LarryR Jan 15, 2013 5:00 PM (in response to reachsubbiah)

The dimension specified by varValues(x) is defined in a table in the FDM Admin Guide, in the "Conditional Mapping" section of the chapter titled, "Mapping Tables". varValues(21) is defined there as the Source UD2 dimension.
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Conditional mapping script query

SH_INT Jan 15, 2013 5:05 PM (in response to reachsubbiah)

Don't know if you have just typed the following incorrectly

If varValues(15)"2000" Then Result = "4001" Else If Left(varValues(21),1)="1" Then Result = "4000" Else Result = "4001" End If End If

but ... you need a '=' after varValues(15) and need to remove one of the End If's if this is to be a syntactically valid statement.
1 person found this helpful
Like Show 0 Likes(0)

Actions
3. Re: Conditional mapping script query

reachsubbiah Jan 15, 2013 5:23 PM (in response to LarryR)

Thanks a lot for your Reply...

Sanjeev
Like Show 0 Likes(0)

Actions
4. Re: Conditional mapping script query

reachsubbiah Jan 16, 2013 8:24 PM (in response to LarryR)

I agree that varValues(21) is custom 2 dimension. What does Left(varValue(21),1) = "1" Then Result = "4000" supposed to do in Account mapping, I checked the FDM bootcamp but i didn't got any clue. Also I am new to Like mapping...

Sanjeev
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.