Hyperion Kernel, From Alpha To Omega

HFM migration steps - Step0) If the destination HFM app name exists already, delete it first. Step1) Check source (ex. HFM) and target (ex. PRODHFM) UDL files. They could reside in any HFM servers. Step2) From HFM server 161, run copy utility Step3) Ensure the source and destination UDL files are selected correctly Step4) Select source application, and confirm it will be converted to classic to ensure migration successful. We will need to convert back to EPMA. Click Yes and Yes. Step5) Select destination. define the application to copy to and click next  Copy in process Step6) After Copy is completed successfully, need to register HFM application, so it can be visible. Step7) After copy, user Admin is only assigned with provision access. We need assign administration to user Admin. Go to shared service, find Admin, and right click to select provision. you also can copy provision (select application under consolidation, right select Copy P...

When in developing calculation scripts (or business rules), sometimes we are tempted to put together formulas without closely exam the formulas we are assembling are sparse or dense formulas. Since each time when Essbase tries to calculate sparse formulas, it has to search the blocks in the storage, those blocks which contain the sparse members, and brings them into memory. This takes time! Let's look at an example. Different technologies are installed into airplanes to enable the aviation connectivity. As time goes by, old technologies are uninstalled (ex. ATG), retrofit to newer technology (ex. ATG to ATG4, to KU, or ATG4 to KU), or transferred from on airline to another.  In all those scenarios, we need to calculate AOL (Airplane On Line), CLOL (Content Loader On Line). Developers put together the following business rule - /* Current Year Calc*/ Fix(&CurrYear, "Actual", "Jan":&CurrMonth, {rtp_Airline}, {rtp_AircraftType}, {rtp_Region}, {rtp_Ro...

Planning/Essbase professional like to use Dynamic member formulas. One of advantages is to take no data storage, therefore to improve overall performance. Second, it improve the correctness of calculation and can be easily and quickly verified, without waiting for calc scripts to run (some may rely on aggregation). When you have multiple Dynamic Calc members, whether within a dimension or cross dimensions, you would have to understand the ordering between Dynamic Calc members. 1) Dynamic Calc order within a dimension follows the outline order. 2) Dynamic Calc on Sparse dimensions will come before Dynamic Calc on Dense dimensions. The reason for this is that the Block Storage need be VIRTUALLY created first before it can perform calculation. 3) Dynamic Calc on Dense dimensions will come after Dynamic Calc on Sparse dimensions. (is this just a repetition of #2 in an opposite way?) Among the dense members, Account and Time will be calculate first, following by other Dense dimensions...

Application is currently not accepting connection. Essbase Error(1054009) There are occasions when users receive the above error message when they try to connect to Planning Essbase cluster via SmartView. This is normally caused by one of the following activities:   a) Database is being refreshed (Classic) or deployed (EPMA). Solutions: Wait till refresh to be completed. b) Allow connects under security is unchecked.  Solutions: In EAS, from application, select edit property, and under General tab. c) Connection is disabled using MaxL . Solutions:   Code examples: alter application $4 disable connects; alter application $4 enable connects ;   d) Connection is disabled using ESSCMD. Solutions: Code examples: DISABLELOGIN; ENABLELOGIN; When all of these are checked, and users are still not able to connect to the application, then the ultimate solution is to restart all Hyperion servi...