jeffreygreen
Technical User
I have about 10,000 +/- 400 or so records that get uploaded to my COGNOS DW a month. Then monthly, I have to audit 25 of them, at RANDOM. So what I have been doing is dumping out all 10,000 to Excel, running EzQuant (random number generator) to give me 25 random numbers from 1 -10,000. Then I go beck to Excel, and pull those lines. Way too much work, I think.
Any way of having COGNOS simply run a report every month where COGNOS counts the total records entered the month before (I would use ENTRY DATE for that criteria) and then, from that subset of data, output an Excel spreadsheet with 25 random records??? It might actually be ok for me to be prompted for the Month number . . . but it is always the previous month,
Thanks!!
Any way of having COGNOS simply run a report every month where COGNOS counts the total records entered the month before (I would use ENTRY DATE for that criteria) and then, from that subset of data, output an Excel spreadsheet with 25 random records??? It might actually be ok for me to be prompted for the Month number . . . but it is always the previous month,
Thanks!!