FDMEE SQL Script mapping - Connect to HFM Database
Hi
I am using EPM 11.1.2.4 (HFM,FDMEE).I am trying to setup a SQL Script based FDMEE LIKE mapping to map ICP dimension.
This is my requirement:
WHEN ACCOUNTX = 'ICP Account' AND ICP = [NULL] THEN ICPX = 'XXXX'
Instead of hard coding the list of ICP Accounts in HFM (based on "Is ICP" property) I would like the FDMEE Script pull it from the HFM Schema based on the Is ICP Property. Below is the table or query which pulls the list of ICP Accounts:
SELECT LABEL FROM EPM_HFM.CONSOL_ACCOUNT_ITEM WHERE ISICP = 1;
Could someone help me , how to connect to the HFM Schema from the FDMEE Script and execute the above query.