Has anyone had any success directly connecting to a COGNOS table or accessing report results in the XML format? For most reports I run, a flat Excel is sufficient. However, the number of rows written to the most important one regularly exceeds the maximum number of rows written by Excel, requiring me to break it up into multiple files. My thought would be to try to access it directly somehow, but perhaps there is a better way? Any assistance is appreciated!
