It s not that hard, but it isn't enabled by default and you need to do some funny backend changes (not
too complicated, but does require some Cognos/IBM KB research .
Applies to Cognos 8.4 (maybe 8.3, hasn't been fully tested on 8.3)
Technique for ‘Filling in the Blanks’ in Microsoft Excel
Sometimes we are given data in a spreadsheet that contains blanks and in order to process the data we need to repopulate the data appropriately. With lots of data this can be very time consuming and sometimes near impossible.
