Today I spent time working out why I could not convert some text values I had pasted from a FR report to Excel into numbers. It turns out the text values were padded with non breaking spaces which TRIM() did
How to compare Oracle Financial Management (HFM) metadata – Part 2
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.
How to Protect Cells in Excel with a Macro
Occasionally I am asked to create a protected Excel workbook where users are only able to enter data into specific cells. For example, in the above sheet users can only input into cream cells. This is done by unlocking
Oracle Open World London 12 Feb 2020
After a long walk through Excel I arrived at the entrance to Oracle Open World. I had forgotten how big Excel is. My first session was Tracey Edwards talking about her life and Maiden, the first all-female crewed yacht to
How to compare Oracle Financial Management (HFM) metadata – Part 1
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
How to make Oracle Financial Consolidation and Close (FCCS) consolidations faster using @CALCMODE
I have just finished an FCCS project where consolidations were running very slowly. Someone suggested using @CALCMODE(BOTTOMUP) as shown in the following example. This improved the consolidation time by a couple of orders of magnitude! /* Checks Balance Sheet balances
How to get Oracle Financial Management (HFM) to spot misspelled variables for you
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#” &
Is it any #$@&%*! good?
One of our tech heroes is Stanley Hooker who designed the engines for Concorde, hence the picture. I have just been watching a YouTube video about his career. One of my favourite sections is at the end when he says