BusinessObjects Board

Rolling Summary function

Just FYI in case this is of value to anyone –
There is a Rolling Summary function called in several of the RapidMarts, but the results are not correct in many instances (unless it has since been fixed). Each call within a job must have its own set of variables, as the function relies on the persistence of these variables to do the cross-row calculations. In particular the code for the Cost Summary Fact looks like it was not completed; there are 8 calls but only 4 set of variables defined, and only 1 set is actually used. Some of the jobs define the value variables correctly, but they all only use a single key variable which also causes problems. The initial values are also not initialized in many jobs. I had to make almost 900 changes to get them working correctly.


craiggsmith (BOB member since 2009-06-01)