Headcount r

Question

Hi all,
We’ve set up a UD1 member to account for headcount in our application. We have cost centers in our account dimension which we’re using in conjunction with the headcount UD1. The issue is that the numbers translate when reviewing at a base entity depending on the currency or, if we load a USD JE, the numbers are just not visible for base entities in a different currency than USD.
I’ve reached out to OS support and they have no reference for a customer using UD for headcount and say that any account type outside of Balance or NonFinancial will translate (CC accounts are expense). Any thoughts on workarounds for this? We’ve settled with the USD JE though that’s clearly not optimal. Any suggestions would be welcome!
Thank you,Nicole
&nbsp;
PS. I had to add a letter to the header because it didn’t meet the minimum which is why there’s a random r up there&nbsp;

TerryLedet · Answer

One thought without the complete picture is to possibly use a Flow member with Alternate Input Currency set to USD.

Mike_Sabourin · Answer

Alternate Currency for Display is available for the UD members, but it’s limited to one currency. Have you tried setting the Is Consolidated property to True (regardless of Formula Type)? Not sure if that would do anything, but a thought.

Clarke_Hair · Answer

When you say you are using the UD1 to capturer Headcount, are you saying that the UD1 members are numbers like 1,2,3 that represents the number of folks or just the type of Headcount (Salary, Hourly,…). Also, how are you putting Cost Centers in the Account Dim. Is that Cost Center A as a parent with a number of children’s as accounts or you are not using the Account dim as Accounts at all. Making the Account Type = NonFinancial should keep currency from coming into play. You still want it to consolidate so you get summary numbers at the top.

NicoleBruno · Answer

Hi Clarke,We have the parent of Headcount_Total then children Headcount_Filled and Headcount_Vacant as the UD1 members which are then populated with the headcount number by cost center (account dimension). We have CCs in the account dimension the same as accounts - they’re in the opex area of the income statement where costs are driven by CC instead of account. CC is the base member in those areas of the IS with accounts being the base members in other areas (for example, the balance sheet). The CCs then work in conjunction with the UD1s where the shared expense accounts exist (for example, salary, bonus, benefits, etc.).We can’t make the account nonfinancial because it’s a cost center where real dollars exist.Does that make sense? I know it’s a bit confusing so just let me know.

Mike_Sabourin · Answer

I assume you wouldn’t want to have a sibling cost center labeled _HC? You could use that for just headcount and make that non financial. It wouldn’t be the most elegant solution, but it would stop the translation issue. You could also create a USD entity for each of your foreign currency entities to load the headcount in. We did that for one of our clients who wanted to be able to make top-down adjustments without having to calculate the translation for foreign subsidiaries.

Forum Discussion

Headcount r

Related Content

Loading Headcount from Table with no Values

Headcount Roll-Forward using Flow Dimension

Drill from Cube Views to Headcount Details using Linked Dashboards

Forecast Seeding - Need to Add Headcount

Re: Remove text from entities in Data Management