We seed actuals into the monthly forecast, but headcount isn’t pulling over and we’d like it to for reporting.
I found where the business rule is for this process and can see it is currently set up to just pull Income Statement accounts. I just don’t know how to update/change it to include headcount (our headcount is a statistical account).
What is the account type of your "Headcount"?
@kmilner Just add the Haedcount account under accountfilter string -
Dim accountFilter as string ="A#IncomeStatement.Base"
Dim accountFilter as string ="A#IncomeStatement.Base,A#Headcount"
Can you see the headcount in a cube view? After running the cube view, can you display the cube POV information? Can you show us the formula syntax and also the code you are using.
Your data for headcount is at a different flow member called "F#EndBal_Input". In your business rule , you are filtering on the flow member with F#AddBack_Tot.Base.
Can you let us know if F#EndBal_Input is base of F#AddBack_Tot. If not , you may want to include F#EndBal_Input also in your business rule.