Skip to content
Consolvus

Consolvus

Simpler, Quicker, Better

Menu

  • Home
  • Projects
  • Heroes
  • Blog
  • Contact us

Author: David

How to compare Oracle Financial Management (HFM) metadata – Part 2

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.

David October 15, 2020October 15, 2020 Oracle Financial Management (HFM) Read more

How to Protect Cells in Excel with a Macro

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

David September 4, 2020October 15, 2020 Microsoft Excel Read more

Oracle Open World London 12 Feb 2020

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

David February 13, 2020October 15, 2020 Uncategorized Read more

How to compare Oracle Financial Management (HFM) metadata – Part 1

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

David October 2, 2019October 15, 2020 Oracle Financial Management (HFM) Read more

How to make Oracle Financial Consolidation and Close (FCCS) consolidations faster using @CALCMODE

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

David September 26, 2019October 7, 2019 Oracle Financial Consolidation and Close (FCCS) Read more

How to get Oracle Financial Management (HFM) to spot misspelled variables for you

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#” &

David July 10, 2018 Oracle Financial Management (HFM) Read more

Is it any #$@&%*! good?

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 then he says

David June 21, 2018September 26, 2019 Uncategorized Read more

Follow Us

  • LinkedIn
  • Twitter

Search

Menu

  • Home
  • Projects
  • Heroes
  • Blog
  • Contact us

Newsletter

Copyright © 2021 Consolvus. Powered by WordPress. Theme: Spacious by ThemeGrill.
  • Privacy Policy