Saturday, 26 October 2013

..calculation options

Hi again,

There is a really interesting topic that I believe the majority of the administrators and users are confused with. What calculation option to select when they are working on a grid or a form.

The available options are Calculate, Force Calculate, Translate, Force Translate, Calculate Contribution, Force Calculate Contribution, Consolidate, Consolidate all with data and Consolidate all.

  • The first option available in every entity is the

Tuesday, 22 October 2013

...HFM Application Copy Utility

Hi all,

This is a post for one of the most useful utilities that Oracle has provided us. The Financial Management Application Copy Utility!!!

The main purpose of this utility is to copy a single HFM application to a new HFM application in the same or in a different environment. The utility will copy all the HFM tables from the source application to the target application including the tables with metadata, rules and data.

Based on my experience, I believe that the main reasons of using the application copy utility are:

Saturday, 19 October 2013

...Apps 13, London

Hi all,

Apps13 was a great event organized by UKOUG for Hyperion community. It was an opportunity to be updated for the product developments, hear about products or services that are offered to support the day-to-day tasks and to networks with other Hyperion customers and professionals.

I attended the event for two days and I had the opportunity to get introduced to the new features of versions and, to meet ex-colleagues and to listen to the stories of other Hyperion users. Interesting part of the event was the social time when we drunk, ate and danced until late.

The key points that are in my mind after these two days are:

Sunday, 13 October 2013 flow: accounts vs movements design

Hi all,

Building a cash flow report within HFM is always a challenge.

Up to today, I have seen two main approaches of building a cash flow report:

  • Use account dimension to build calculated accounts that will retrieve data from balance sheet.
  • Use the custom dimension that is used to maintain the balance sheet movements and build an alternative hierarchy for balance sheet movements to simulate the cash flow.
The first set of questions that I will try to answer is:

Saturday, 12 October 2013

...locking entities in HFM

Hi all,

Recently, I was working on an assignment to start locking the entities in an HFM application with 8 scenarios, 9 years of data and 600 base entities.

The options were the following:
  1. Should we lock only the base entities?
  2. Should we lock both the base entities and the parents?
  3. Should we not lock anything? 
In the end, we decided that the best approach is

Friday, 11 October 2013

...about me (the first post)

Thanos is an Oracle Hyperion Financial Management Certified Specialist with extensive experience in delivering Financial Consolidation solutions and active involvement in Business intelligence projects.

Main objective in all the projects is the optimisation of the finance processes through the integration, simplification and the automation of the various existing financial processes. Key strength is the combination of my accounting background with my technical expertise. This combination enables me to gather detailed business requirements, create effective processes and compile financial calculation and consolidation rules, supported from efficient data management models. The wide experience in management and statutory reporting allows me to rapidly produce complex financial reports for internal and external purposes. This combination is supported by a proven track record of excellent social and communication skills, which includes challenging and guiding the client to make important decisions. My in-depth knowledge of the HFM structure permitted me to build a metadata design application in order to improve the management process and reduce the required time and effort for maintaining an HFM application.

The last years, I have actively participated and led implementation projects in different industries, which includes banking, construction and consumer goods industries as well as public sector.

- IFRS Consolidation and Reporting
- FinRep Reporting
- Management Reporting
- Tax Reporting

- Oracle Hyperion Financial Management 9/ (soon 1.2.3)
- Hyperion Reports
- Hyperion Shared Services
- Hyperion Workspace
- Oracle Smart View
- Hyperion Data Relationship Management

- Microsoft Business Intelligence
- Microsoft SQL Server 2005/2008 (Integration - Analysis - Reporting)
- Microsoft Excel

- Profitbase Management Studio

...using SmartView

Last week I was chatting with an ex-colleagues about our HFM experiences. After 10 years, we both have a lot of stories to share but a...