Implementing FCCS for banking customers
Loading daily average and ending balance in FCCS.
Hi There,
Has anyone implemented FCCS for a banking customer ? For banking industry, daily ending and average balances are critical to consolidate and report. I see challenges if we need to load average balances and calculate the ending balances.
Some thoughts on how to handle them, please provide feedbacks/inputs..
Ending balances
Create Day1 to Day31 in Data source dimension and load periodic data based on the day. Load all the data to "FCCS_Net Income" member in movement dimension assuming OOB cashflow calculation is not required.
With above approach, lets assume we are in Feb month. The opening balance for a day wont match with the closing balance of prior day because FCCS would handle it the way its mentioned below..