Excel 2007 Export Tab Hyperlink Drill Thru Issues

[rocket21]

Business Requirement:  Need to have a Microsoft Excel report that has Drill Thru capabilities between tabs.

Attempt at Cognos Solution:  Create anchors and hyperlinks in report.

Technical Issue:
-If I insert a data item value as an HTML value with traditional HTML coding (ie A HREF = ), the hyperlink column shows in the HTML version, but comes through blank in Excel 2007.
-If I use a hyperlink item with # sign, the # shows in the HTML version, but not in Excel 2007.  Cognos appears to flatten symbols into underscore (_), so I also can't seem to try an ASCII code.

Any suggestions how I can have an Excel export with drill thru capabilities between tabs?

[CognosBen]

Hi,

I have used Bookmarks to solve this issue. Then I am able to get Drill Thru to another sheet.

I have also created a dynamic bookmark since I have set grouping options on some of the Pages. I have placed the bookmark on the grouped object and then selected this object as the data value in the Drill-Through Definitions.

I then have a main page in the excel report where i can drill throug to another sheet. And in the sheet I am taken to from the frontpage I also have a drill through via bookmark that takes me back to the main page.
Do a search on youtube for Bookmarks and you might get some ideas :)

[rocket21]

Hi,

I have used Bookmarks to solve this issue. Then I am able to get Drill Thru to another sheet.

I have also created a dynamic bookmark since I have set grouping options on some of the Pages. I have placed the bookmark on the grouped object and then selected this object as the data value in the Drill-Through Definitions.

I then have a main page in the excel report where i can drill throug to another sheet. And in the sheet I am taken to from the frontpage I also have a drill through via bookmark that takes me back to the main page.
Do a search on youtube for Bookmarks and you might get some ideas :)

Is this with the Excel 2007 export?  I've been attempting the bookmarks, but the issue I'm running into is the scripting necessary to link to them.  In HTML it would be a simple (brackets removed) A HREF=page.html#bookmark but I can't get Cognos to export the # (it converts it to a _ in the Excel version, which breaks the link).  Did you do anything special to get the number sign to work?

[CognosBen]

Yes, it is Excel 2007.

It's very hard to write in details how I did it, but I found the instruction video I used when I created this report. See if this might be useful for you.
This will also work in when exporting to excel.

https://www.youtube.com/watch?v=gEo4pQ9xbIA

[rocket21]

Thank you, CognosBen!

My issue was that I was trying to manually force HTML style bookmarks (AKA "anchors" - the A NAME tag).  Ben's solution was to use native Cognos bookmarks on the detail page and then use the native Cognos drill through to point to the bookmarks from the summary page.  This indeed appears to work in the Excel 2007 export, which makes my life a lot easier in working on this reporting solution!