Report rendering
Maximum number of pages in long reports
To prevent Microsoft Excel from generating an error, keep track of the number of pages in lengthy reports.
Microsoft Excel can support a maximum number of worksheets per workbook, limited by available memory. If the report pages exceed that limit, Microsoft Excel generates an error.
When you import report elements from IBM Cognos Analytics, you can choose the Create new worksheets for report pages option in the Import Content wizard. When you choose this option, each page in a report becomes a worksheet in Excel.
Color differences in rendering to Microsoft Excel
Microsoft Excel supports a predefined set of colors. When a report is rendered, Excel tries to best match the report colors to those in its standard color palette for workbook elements.
Images
An image can be a logo or a picture, or it can be a picture that is repeated with rows of data.
If the report author used a URL-based image in a report, the image contains a URL that points to an image on the IBM Cognos Analytics report server. Images are rendered to Excel as static pictures.
If your credentials do not have sufficient rights to access the image, the image will not be shown in the report.
Lists
If the report element that you are importing is a list, you can choose to import it as an Excel list by selecting the Import as an Excel list option in the Import Content wizard. You can then easily manage and analyze groups of related data in a worksheet. When you designate a range as a list, you can also manage and analyze the data in the list independently of data outside the list. For example, using only the data contained in the list, you can
- filter columns
By default, the AutoFilter is enabled in the header row so that you can filter and sort your data quickly.
- add a row for totals
When you click a cell within the total row, a drop-down list of aggregate functions becomes available.