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

MOSC Banner

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.

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