FDMEE sql mapping
edited Aug 27, 2020 10:11AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 5 commentsAnswered
Hi Experts,
Is it possible to update Account mapping in some other dimension? i.e in Custom1, i want to assign the value to ACCOUNTX? Will it work?
Basically, i want to check the net balance of two source accounts against each entity and if net is positive map to one account else another. Hence, i am using below query.
case
when (select sum(amount) from fdmee.tdataseg B WHERE B.ACCOUNT in('Acct1','Acct2'))<0 THEN 'TargAcct1'
Else
'TargAcct2'
However, since its not considering all the records related to Acct1 and Acct2 for summation.
So, used as below in UD1. But it gives me error.
Tagged:
0