Topic
  • 3 replies
  • Latest Post - ‏2012-05-08T05:07:05Z by SystemAdmin
Deva_S
Deva_S
3 Posts

Pinned topic Cognos 10.1.1 - Issue with Excel 2007 and PDF Exports

‏2012-05-07T08:17:40Z |
I have a crosstab, with the totals, sub totals and rows displayed in a single column.
This gives me correct outputs in HTML and Excel 2002 but not in Excel 2007 and PDF.

I have tried running this on 2 environments
Cognos 10.1 GA - All outputs are correctly formatted
Cognos 10.1.1 - Do not get correct format in Excel 2007 and PDF

I am attaching a sample based on the "GO Sales (Query)" package.

Please help with the issue.
Updated on 2012-05-08T05:07:05Z at 2012-05-08T05:07:05Z by SystemAdmin
  • Deva_S
    Deva_S
    3 Posts

    Re: Cognos 10.1.1 - Issue with Excel 2007 and PDF Exports

    ‏2012-05-07T08:22:46Z  
    • Details of the issue:

    When exporting in Excel 2007 or PDF, The subtotal, grand total cells are shifted to the right (as shown in attached file).

    This only happens in 10.1.1 and not in 10.1

    As the production server has already been upgraded to 10.1.1, this is creating a lot of problems.
  • Deva_S
    Deva_S
    3 Posts

    Re: Cognos 10.1.1 - Issue with Excel 2007 and PDF Exports

    ‏2012-05-07T08:25:15Z  
    • Deva_S
    • ‏2012-05-07T08:22:46Z
    • Details of the issue:

    When exporting in Excel 2007 or PDF, The subtotal, grand total cells are shifted to the right (as shown in attached file).

    This only happens in 10.1.1 and not in 10.1

    As the production server has already been upgraded to 10.1.1, this is creating a lot of problems.
    The attachment did not upload.
  • SystemAdmin
    SystemAdmin
    1959 Posts

    Re: Cognos 10.1.1 - Issue with Excel 2007 and PDF Exports

    ‏2012-05-08T05:07:05Z  
    • Deva_S
    • ‏2012-05-07T08:25:15Z
    The attachment did not upload.
    The problem is caused by the use of the box type None setting for the crosstab row nodes. This feature really isn't intended to be used in this way to hide the rows and collapse the nesting that you have performed in the rows. Unfortunately, there isn't much that you can do with relational data to accomplish the same behaviour in other ways (other than complex union queries which have negative consequences for performance). With dimensional data you could make use of set expressions to combine the different level sets into one data item which would populate the crosstab rows.

    Attached is a modification of your report showing one way to use the box type property to hide the row nodes. Note that an extra crosstab space has been added to the grand total row to ensure that there is a consistent removal of 2 cells from each row of the crosstab output. The consistent removal of the same number of node cells inadvertently results in the proper alignment of the output in your sample report.

    On a side note, you might consider contacting IBM support to let them know that the formatting capabilities for hiding crosstab elements should be improved via an enhancement to the product capabilities.