Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

Event Mapping failed

edited Sep 17, 2015 10:05AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 5 commentsAnswered

Hi every one ,

I am beginner and need help with my event script , i want update table in  condition when data with " account like 1* and amount < 0 then accountx = N  OR account like 2* and amount > 0 then accountx = N " after that it will validation error because i havent member N in my target. For now i use event aftprocmap :

My data

Account     Accountx     Amount

100000     100001          10

120000     100001          -5

200000     200001          20

220000     200001          -25

my script :

fdmAPI.logdebug

try:

query = "UPDATE TDATASEG SET ACCOUNTX = 'N'  WHERE LOADID= ? and ACCOUNTX like '1%' And AMOUNT < 0 OR ACCOUNTX like '2%' And AMOUNT > 0"

params = [ fdmContext["LOADID"] ]

print fdmAPI.executeDML(query, params, False)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center