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

MOSC Banner

Converting FDM Event Script to FDMEE

I need to convert the below AftImport event script from FDM to FDMEE:

Dim strSQL
  Dim tblName
  tblName=API.State.GstrActiveWorkTableName

' -----------------------------------------------------------------------------------------------------
If strLoc="CH_POM_SUB" Then

' ---- Create Own Footprint amount,  OF =(1-PN)
  strSQL="INSERT INTO " & tblName & " (DataView,PartitionKey,CatKey,PeriodKey,Entity,CalcAcctType,Account,Desc1,UD1,UD2,UD3,UD4,UD5,UD6,UD7,UD8,Amount)" _
        &" SELECT DataView,PartitionKey,CatKey,PeriodKey,Entity,9,'SUB_NOOFSUB_PNOF','OF', UD1,UD2,'OF',UD4,'NO_MOVEMENT',UD6,UD7,UD8, (1 - Amount)" _
        &" FROM " & tblName _
        &" WHERE Account='SUB_NOOFSUB_PNOF' AND UD3='PN'"
  API.DataWindow.DataManipulation.fExecuteDML strSQL

Specifically, I am wondering what replaces API.State.GstrActiveWorkTableName.

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