Forecast Seeding - Need to Add Headcount
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...
Forum Discussion
kmilner Just add the Haedcount account under accountfilter string -
Old
Dim accountFilter as string ="A#IncomeStatement.Base"
New
Dim accountFilter as string ="A#IncomeStatement.Base,A#Headcount"
That was my original thought as well, however when I test that update nothing is being kicked over from actuals.
Hey kmilner!
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.Here is what I am seeing when I look at the POV.
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.