...Calculation status: OK SC

     A few weeks ago, I was working on an application update. I started the update on Friday afternoon and thankfully everything went well. I loaded the new metadata and new rules without any problem, completed the "Clear Invalid data" task in 20minutes and then I started the overnight consolidation in order to reconsolidate the whole application and get the status OK in all scenarios/years/periods. I was home before 7pm

...Org by Period

Recently, in the OTN forum, we were discussing the functionality of Org by Period.

Org by Period specifies whether the application allows new consolidation structures to co-exist with previous consolidation structures in the same application.  If it will be set to ‘Y’, it will enable the functionality to activate or deactivate legal entities by reporting period.

As an example, let's consider entity AB which should be consolidate to parent A for period P1 to P3 and then consolidated to parent B for periods P4 to P12. In order to achieve this, in the Ownership management module the entity would be flagged as Active under parent A for periods P1 to P3 and then it will be flagged as Inactive. For periods P4 to P12, the entity will be flagged as Inactive for parent entity A and Active for parent entity B.

Based on this, the parent entity A would retain the values on a YTD basis for only the data that came from P1 to P3.  Data from periods P4 to P12 would be only consolidate to Parent B.

Finally, the metadata would show the entity underneath both Parent A and Parent B, though the various metadata selector dialogs have a "show active only" button when you want to show only the current period's active structure.

Cheers,

Thanos

...the consolidation functionality

It is two days before the end of the year-end reporting period and at 4:50 pm the helpdesk receives a new ticket with title “Consolidation of subsidiaries and NCI query”.

Silence in front of my screen… the subject of the ticket is quite worrying for such a week and as I read further down the situation becomes even worst.  The request of the user was to explain how the system calculates the NCI for specific subsidiaries, why the closing balance was 150.000$ and what the movement consolidation movement represents. A lot of questions….

Proem

Until today, I have seen four approaches in consolidating the values of an entity to the parent entity.

• The first approach is to create manual journals at "Entity Curr Adjs". This journal will be posted both at the subsidiary and at the consolidation entity of the group.
• The second approach is to use the Sub Calculate and the function HS.Exp in order to populate specific members or consolidation accounts at the value dimension members "Entity Currency" / "Entity Curr Adjs".
• The third approach is to use the Sub Calculate and the function HS.Exp in order to populate specific members or consolidation accounts at the value dimension members [Proportion] / [Elimination].

when to blog....

Hi all,

It’s been quite a while since my last post and I should feel guilty. 

However, the first months of 2016 passed really quickly with a lot of exciting things. Last week, thanks to some friends that I had not seen for 6 months, I remembered that I should post more often in order to keep my thoughts alive.

Topics that I have in mind are:

• Using Loop structures in the HFM rules - Performance at stake
• Consolidation journals audit functionality - Transforming HFM to a virtual accountant
• Cloud and Hyperion - The Titan is finally in the air, or not?
• SharePoint and Hyperion - Location? Our location is the world
• Top Gun 2016 - One more year of exciting news
• FDMEE - The change is here, back to the classroom
• Hyperion version 11.1.2.4.200 - Insight, so excited!

Let's see...

... FDM batchloader

It’s been almost two months since my last post but I can say that all this time I had been working on a module that it is really interested but I had not worked before.

So in this post, I am going to describe my experience with FDM Batchloader. I know that it is a bit outdated topic since FDM has been replaced by FDMEE but in my defence not all the companies have upgraded yet.

Proem

As a summary, FDM Batchloader is a module that automates the steps that the user has to execute in order to import a text file with ERP data in the FDM tables, map the data to the HFM or Essbase members and finally load them in HFM or Essbase.

...Debugging HFM rules

Hi all,

I hope you are doing well. I just came back from a 3-weeks holidays ready for a new year hopefully full with Hyperion projects and consolidation challenges.

Proem

Last night I was discussing in the OTN forum on how to debug a complex set of rules. This discussion brought into my mind the multiple times during the last project that I was in the same situation and I was trying to find a problem in a mechanism that includes triggers, variables and multiple HFM expressions.

Unfortunately when you are working on a complex set of rules with different cases and different statements, it is really easy to make a mistake and misread or misinterpret the existing rules.

For this reason, I believe that the easiest way to find the solution to your problem is

...a big thank you to all my colleagues

As a last post from my current role, I would like to say a big thank you to all my colleagues for being so supportive, patient and open to my ideas for the last two years and especially during the Hyperion upgrade project.

See you soon!!!!

Thanos