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

MOSC Banner

The problem of FDMEE mapping script

Hi,I have a FDMEE mapping script problem.In Data Load Mapping -> Dimensions(Entity) -> Like,I created a mapping script,the following is code:

entity = fmdAPI.getString("ENTITY")

query = "SELECT TDATAMAP.TARGKEY FROM TDATAMAP,TPOVPARTITION WHERE TDATAMAP.PARTITIONKEY = TPOVPARTITION.PARTITIONKEY AND TDATAMAP.DIMNAME = 'ENTITY' AND TPOVPARTITION.PARTNAME = 'Loc_Dummy' AND TDATAMAP.SRCKEY = ?"

params = [entity]

queryResult = fdmAPI.executeQuery(query,params)

queryResult.next()

TARGKEY = queryResult.getString('TARGKEY')

fdmResult = TARGKEY

queryResult.close()

I have many Locations which also has Entity dimension mapping, it can share an Entity dimension mapping.I created Dummy Location,and other locations are using the Entity dimension mapping of Dummy Location which used mapping script to associated whit it.

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