Skip to Content
0

Roll forward calculation monthly basis

Feb 01 at 08:19 AM

60

avatar image
Former Member

Hi Expert

Model is YTD

I have requirement wherein my Roll forward calculation happens on monthly basis.

Below is the detailed calculation.

First calculation is current configuration result. I would like to achieve the result mentioned in Required Roll forward configuration. In Required Rollforward config opening balance changes and F_Movement is the changes during the month.

mn9vu.png (20.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Feb 01 at 11:15 AM
0

Balance carry forward rule

F_Activity business rule to calculate Movement

Flow Dimension


dphrs.png (16.4 kB)
cohmv.png (19.8 kB)
r1pzf.png (22.8 kB)
nvgvy.png (23.4 kB)
w3c1x.png (67.6 kB)
Show 8 Share
10 |10000 characters needed characters left characters exceeded

Please attach VISIBLE pictures (rules)! With visible dimension names...

0
Former Member

This are the only rules and the dimension

0

Your rules screenshots are not readable - low resolution! Please replace screenshots!

0
Former Member

Business rule to calculate F_ACTIVITY (i.e. movement during the period)

Business rule for carry forward

Flow Dimension

q6u76.png (12.9 kB)
dt5zw.png (9.6 kB)
0

What is loaded to BPC (for FLOW dimension)?

0
Former Member
Vadim Kalinin

Data from BW is loaded to Flow BALANCE.

0
Former Member
Former Member

Well I have used Account based calculation business rule and did following config to get last month closing balance as the current month opening balance. Just mentioned -1 in source period to get the F_TOT of last month to current month F_OPE

2dwac.png (10.8 kB)
0
Former Member

Data is loaded to BALANCE Flow

0
Vadim Kalinin Feb 01 at 08:49 AM
0

"First calculation is current configuration result." - Please describe your current configuration!

Share
10 |10000 characters needed characters left characters exceeded