Skip to content
Consolvus

Consolvus

Simpler, Quicker, Better

Menu

  • Home
  • Projects
  • Heroes
  • Blog
  • Contact us

Blog

How to Convert Text Number to Values in Excel

How to Convert Text Number to Values in Excel

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

David April 13, 2021April 30, 2021 Microsoft Excel Read more

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

David June 21, 2018October 18, 2021 Uncategorized Read more

How to configure Oracle Financial Management (HFM) security

How to configure Oracle Financial Management (HFM) security

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,

consolvus_uytdli June 9, 2018 Oracle Financial Management (HFM) Read more

How to write better Oracle Financial Management (HFM) rules by copying Calc Manager

How to write better Oracle Financial Management (HFM) rules by copying Calc Manager

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

consolvus_uytdli May 9, 2018 Oracle Financial Management (HFM) Read more
  • « Previous

Recent Posts

  • How to Convert Text Number to Values in Excel
  • How to compare Oracle Financial Management (HFM) metadata – Part 2
  • How to Protect Cells in Excel with a Macro
  • Oracle Open World London 12 Feb 2020
  • How to compare Oracle Financial Management (HFM) metadata – Part 1

Archives

  • April 2021
  • October 2020
  • September 2020
  • February 2020
  • October 2019
  • September 2019
  • July 2018
  • June 2018
  • May 2018
  • April 2018

Categories

  • Microsoft Excel
  • Oracle Financial Consolidation and Close (FCCS)
  • Oracle Financial Management (HFM)
  • Uncategorized

Newsletter

[mc4wp_form id="452"]

Follow Us

  • LinkedIn
  • Twitter

Search

Menu

  • Home
  • Projects
  • Heroes
  • Blog
  • Contact us

Newsletter

Copyright © 2023 Consolvus. All rights reserved. Theme Spacious by ThemeGrill. Powered by: WordPress.
  • Privacy Policy
 

Loading Comments...