Hyperion Kernel, From Alpha To Omega

ESSBASE common functions: /*@RELATIVE to bring level 0 members and @REMOVE to exclue second portion member list*/ @RELATIVE("TotalDepartment",0)  @REMOVE(@Relative("Service", 0),@RELATIVE("UCS-S",0)) /*Clear data, normally with FIX range*/ FIX(&CurPlanScenario,&CurPlanVersion) CLEARDATA "Opex_Inputs"; ENDFIX /*@MDSHIFT  and @PRIOR*/ IF(@ISMBR("Jan"))    "AC_1921" = @MDSHIFT("Other_Inputs"->"DEP_GEN"->"Input_USD"->"AC_1921",11,"Periods",,-1,"Years",);  ELSE      "AC_1921" = @PRIOR("Other_Inputs"->"DEP_GEN"->"Input_USD"->"AC_1921"); ENDIF /*@PRIOR  to handle Feb:Dec vs. Jan*/ Fix(@Relative("Service",0)) "Attrition" ( IF(@ISMBR(Jan)) "Attrition" =  @PRIOR("UOL"->Dec, 1, @RELATIVE(Years,0)) * "Attrition %" -> "BegBalance...

Migrating HFM application from 11.1.2.2 to 11.1.2.4 involves several steps - - Copy application from HFM copy utility    a. Ensure UDL files of the source and the target app are created correctly. (preferable to run copy utility from the target HFM server.)    b. When copy, select converting from EPMA to Classic, this ensures copy successfully. You would have to convert it back to EPMA later. -  Run install configuration from HFM server, and check upgrade from previous release. - Manual update Hyperion table from the back end. (Oracle is yet to provide patch on this). Without this step, you won't be able to see the app from Consolidation Administration / Application.   HSX_DATASOURCES table needs to be manually updated in order to add the application in   Consolidation Administration.Without this, the HFM app will not show up as an application   a. To add a new record, open the HSX_DATASOURCES table and insert a new line.   ...