2 Replies Latest reply: Sep 9, 2013 6:53 AM by JTF85 RSS

    How to get an account with an IsICP -"R" attribute calculated in the HFM Rule file

    Ravi Savvana

      Till recently everything was going fine with the calculations in our HFM setup ( Version 4.1)

       

      We have say around 8 Expense accounts which roll up into a Parent account say ALL446 which finally rolls up into Operating Expenses.

       

      Operating Expenses

        |__ parent account

            |_INVALO

             |_ALL446

                |__222446

                |__242446

               

       

      And we have a calculation in the rule file as below

      HS.EXP "A#BE FIXED COST = A#Operating Expenses +A#SGA - A#BE VC OP F10"

       

      This was calculating correctly till we did the below change

       

      Added IsICP attribute to couple of accounts say 222446 and 242446 ( in the above example) in the metadata which finally rolls up into Operating Expense.

      Note: we did not add any Plug account attribute to the accounts

       

      Now the problem what we have in hand is -> Fixed Cost is not calculating correctly.- It happens that the two accounts for which we added the IsICP are not showing up in the calculation and the data in those two accounts are not adding up in Fixed Cost.

      POV in GRID/Excel -> actual,2013,periodic,<Entity Currency>, ICP Top, AllCustom1, AllCustom2, AllCustom3, None( for custom4)

       

      But when we retrieve Operating Expenses in Excel - it is showing the correct amount, even in the grid - but looks like when the rule tries to calculate Fixed Expenses using the above rule - these accounts are not adding up in the Operating expenses.

       

      I tried the formula ( to check what number is coming into Fixed cost ) - the result is zero - But in the grid/excel I see amount for acct2. Same POV as above

      HS.EXP "A#BE FIXED COST = A#222446"

       

      and if I add & Tops to the account like below ( getting some weird number instead of what is there in acct2)

       

      HS.EXP "A#BE FIXED COST = A#222446" & Tops

      Questions:

       

      1) Where exactly I am going wrong ?

      2) Is it MANDATORY to have a Plugaccount attribute when we have IsICP turned to "R" ?

      3) What will happen if we do not have a Plugaccount for the IsICP account ?

      4) How to correct the formula to make sure I get the number in the acct2 into Fixed Cost??

      5) Do we need to have the IsICP turned on to the immediate parent of the account having IsICP and the Top parents of the account too??

      6) Is it possible to get the exact number what we have in 222446 into BE Fixed Cost account via Rule?- why I am not getting it

       

      Notes:

      BE Fixed Cost-> account type -"Expense", IsCalculated - yes, IsConsolidated - yes, IsICP- N, Custom1TopMember - AllFunctions, Custom3TopMember- AllCustom3, enabled allcustom1,2,3,4aggregations

       

      Operating Expenses->"Expense", IsCalculated - No, IsConsolidated - yes, IsICP- N, Custom1TopMember - AllFunctions, Custom3TopMember- AllCustom3, enabled allcustom1,2,3,4aggregations

       

      INVALO ->"Expense", IsCalculated - No, IsConsolidated - yes, IsICP- N, Custom1TopMember -none, Custom3TopMember- none,

      enabled allcustom1,2,3,4aggregations

       

      Problematic account 222446 -> "Expense", IsCalculated - No, IsConsolidated - yes, IsICP- R, Custom1TopMember - Operations, Custom3TopMember- AllCustom3, enabled allcustom1,2,3,4aggregations

       

      The Entity on which I am trying to get the data( mentioning wherever I have attributes for this entity)

      DefCurrency - DEM, Allowadjs- enabled, IsICP - enabled, Userdefined 2 - financial, - SecurityasPartner attribute - is not selected through out the applicaiton.

       

       

      Variable

      Tops = ".I#[ICP Top].C1#AllCustom1.C2#AllCustom2.C3#AllCustom3.C4#[None]"

       

      tried attaching the attachments ( but service is unavailable)

       

      Waiting for all of your valuable suggestions..

        • 1. Re: How to get an account with an IsICP -"R" attribute calculated in the HFM Rule file
          Ravi Savvana

          After some good amount of testing I got what I wanted.. to get the same amount in BE Fixed cost..

           

          Changed the formula to

          HS.EXP "A#BE FIXED COST = A#222446.I#[ICP Top]"


          ====

          But I do like to know the answers to the below questions from our learned members and suggestions too.

          1) why was I not getting the formula right when I use & Tops

          2) Is it MANDATORY to have a Plugaccount attribute when we have IsICP turned to "R" ?

          3) What will happen if we do not have a Plugaccount for the IsICP account ?

          4) Do we need to have the IsICP turned on to the immediate parent of the account having IsICP and the Top parents of the account too??

          5) which will have priority the rule or the Grid where we have the calculated member like the BE Fixed Cost - because in the grid I had icptop, allcustom1,2 3 and when had & Tops to the account - I got some weird numbers...


          Thanks

          Ravi

           


           



          • 2. Re: How to get an account with an IsICP -"R" attribute calculated in the HFM Rule file
            JTF85

            1) why was I not getting the formula right when I use & Tops


            I'm assuming that BE Fixed Cost has N for IsICP, in that case you can not write to invalid intersections as it would attempt to use the same ICP information


            2) Is it MANDATORY to have a Plugaccount attribute when we have IsICP turned to "R" ?

             

            No

             

            3) What will happen if we do not have a Plugaccount for the IsICP account ?

             

            It will not run eliminations

             

            4) Do we need to have the IsICP turned on to the immediate parent of the account having IsICP and the Top parents of the account too??


            If you want it to rollup, yes you would need that.  We have all Parent accounts as isICP set to Y and top member to ICP Entities so that they roll up


            5) which will have priority the rule or the Grid where we have the calculated member like the BE Fixed Cost - because in the grid I had icptop, allcustom1,2 3 and when had & Tops to the account - I got some weird numbers...


            I'm not following the question here, grids are just really a display mechanism, rules will handle all of the calculations.