Code: Select all
['Bank closing balance']=>
DB('Cube',!Result,!Entity,!AccountItem,'Bank opening balance',!Scenario, DB('Day Properties',!Day,'Next') );
The bank opening balance of day N is the closing balance of day N-1. The closing balance is a consolidation of the opening balance plus any movements, so using the closing balance to feed the opening balance is causing quite a bit of work to go on as there is a massive chain of feeders stretching right back to day 1.
My proposed solution is this: to change the feeder to be
['Opening Balance', 'Day 1'] => ['All days', 'Opening Balance'];
I.e. use one single value to feed thousands of lines. There are 3000+ (i.e. more than 1600) elements in this dimension.
So my questions is, am I correct in thinking that this won't be affected by the stack limitation of 1600 because each feeder is independent? And that instead of having a massive chain of feeders, I'm merely going to have one feeder occur 3000+ times?
Comments on alternative designs welcome too as I realise this isn't a "pure" way of doing the feeders.
Martin