A client has asked for the capability to drill from a TM1Web cube view to an Excel Websheet report that is on TM1Web. More specifically, to drill to a certain sheet in the Websheet of the report based on the parameters (i.e. where they drill from). I am quite familiar / experienced with drills; however, I have never come across this requirement and am quite unsure how to make this happen (or if it is even possible ).
The drill functionality can only drill to another cube view or an ODBC data source. It can't "drill" to a TM1Web workbook. If this were a TM1Web workbook, instead of a cube view, you could do what you want with an action button. Otherwise you are out of luck.
you can create your own JavaScript code which would catch the links created by the ti process or rules, but this is not the best practice.
Note that TM1 replaces the "<>" tags, which makes it impossible to write
).