on 2020 Dec 14 1:34 AM




Hi All,
Was hoping to get some guidance or suggestions.
We have created a custom time hierarchy for annual input members i.e.
YYYY.INP - Yearly Parent
>> HHHH.INP - Half Yearly Parent
>> QQQQ.INP - Quarterly Parent
>> 2021.INP,2022.INP,2023.INP etc. - Annualised Input members
I am now try to extend the balance carryforward account calculation which was used for the base periods to these annualised periods.
Have put in a screenshot of the TIME dimension members and properties for the Annualised members above.
The carryforward is working for the standard monthly time periods i.e. 2020.01, 2020.02 etc. but does not work for the annualised members i.e. 2021.INP, 2022.INP etc.
I have populated 2021.INP with Closing and running the Account calculation for 2022.INP, expecting Closing from 2021.INP will populate 2022.INP Opening flow.
Any guidance/direction will be much appreciated.
Thank you again.
Request clarification before answering.
| User | Count |
|---|---|
| 8 | |
| 8 | |
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.