Hyperion Kernel, From Alpha To Omega

HFM is very powerful in dealing with InterCompany Transactions and elimination. (add more notes how HFM dealing with ICP) Our current General Ledger (GL) uses "hard coded" IC accounts. Ex. 1231 (IC receivable CA), 1232 (IC receivable BA), etc. Each receivable account plus entity will require an IC account! This is not only inefficient, but also hard to maintain in FDM mapping (see below). To correct this backward design of GL, NAV team added Partner Code as a new attribute / dimension of accounts, see below. This will appear in the very last column of GL extracts for HFM. Here are steps what need to be done to add new location and ICP mapping. Step1)  Add a new location After LOCALCURRICP is added, we need to ensure the entries in General and Workflow Behaviors are correct. This requires to create a new Import Format LOCALCURRICP Now we can copy the mappings from LOCALCURR to LOCALCURRICP. Make sure copy both Types of "Explicit"...

There are two methods are commonly used for Cash Flow Calculation, 1) Cash Flow Configuration, which leaves the maintenance to the hands of functional users, vs. 2) Rules, which requires more of VB coding skills. Let's take a look at the method #1. Cash Flow Configuration, is to set 1, -1, at the intersection of BS accounts and Cash Flow accounts. Since the matrix can not be setup if BS and CF both are in the same dimension (such as account), it requires to replicate CF accounts and hierarchy in a secondary dimension, which is irrelevant to Cash Flow calculation, but only used for the matrix entries. Here we pick the Cell Site dimension. Followings are the steps to export CF configuration from one year to another. Step0) Please browse the config input forms under Admin/CF Config and see the combinations of the dimensions. Step1) Extract CF configuration into excel. From Extract/Data, select the followings members from each dimensions, and click Extract. Step2) Whe...

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...