SPM Rollups (roll and smoke your own if you’ve got em)
Posted by Shane Gibson on June 16, 2009
0 comments
We are rolling out SPM in anger and as we started approaching a large number of scorecards (> 1,000) we started to notice perfomrnace of the calc’s were not what we desired.
So our talented DI team on the project have created their own DI Studio code to do the rollups across the scorecard hierarchy.
One of the traps for young players was the fact that the linkid’s between scorecard/elements were not a simple parent.child relationship as we had expected.
But once we got the logic for the linkids from SAS Technical Support, we were away laughing (and calc’ing)
Its a pity we cant use the standard SPM calc’s for the rollups, but needs must.
So roll your own if you’ve gottem.
