All,
I have a Report Studio report that has about 55 Report References with prompts going against TM1 cubes. Running a single report might finish but takes up quite a bit of memory. Lots. Running two at a time, forget it. Plus they take quite a bit of time to run.
So, ideas that have been pushed around is using DQM, upping memory on the server, adding report services, breaking up the report to say 5 sectional reports, etc.
Although I am open for any ideas someone might have on this board for getting this report to run, is there just a memory amount on a Cognos report that if we hit we would say "nothing we do on earth would fix this" without major changes to the report?
Thanks in advance!