Simpler, Quicker, Better
In How to compare Oracle Financial Management (HFM) metadata – Part 1 I discussed how metadata could be compared using a script to sort the members sections of HFM metadata APP fles and then compare the files using file comparison software.
When updating an HFM application it is very useful to be able to identify the changes that are being loaded. If you have ever tried to do this by comparing APP files using file comparison software you will know it
This post will tell you how to get HFM to spot misspelled variables in rules files automatically. For example. if you write run a rule like this: Sub Calculate AccountList = HS.Account.List(“”,”AList”) For Each AccountMember In AccountList HS.Clear “A#” &
This post describes a security model for larger HFM applications (roughly more than 50 users or 50 entities). The model is probably too complex for smaller applications (roughly less than 10 users or 10 entities). However, elements of the model,
For those not already familiar with Calc Manager, it is Oracle’s visual tool for creating rules for HFM and Planning. In my experience Calc Manager is not widely used to create HFM rules. However it is well worth looking at
When you extract metadata files from HFM in APP format the files have a lot of padding to align columns. I often want to remove this padding but sometimes I cannot remember the regular expressions and spend a few minutes