Hello,
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 ).
Any recommendations would be greatly appreciated!
Thank you!!!
Version: 10.2.2
OS: Windows 7
Drill from Cube View to Websheet
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Drill from Cube View to Websheet
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.
-
- Posts: 16
- Joined: Sun Jan 17, 2016 3:15 am
- OLAP Product: Cognos TM1
- Version: 10.2.2 Fix Pack 5
- Excel Version: 2010 32 bit
Re: Drill from Cube View to Websheet
Yeeeep! This is what I was kind of thinking.
Thanks anyways!
Thanks anyways!
-
- Regular Participant
- Posts: 159
- Joined: Fri Aug 12, 2016 10:02 am
- OLAP Product: tm1
- Version: 10.2.0 - 10.3.0
- Excel Version: 2010
Re: Drill from Cube View to Websheet
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 to cells
Note that TM1 replaces the "<>" tags, which makes it impossible to write
Code: Select all
<a href='tm1web sheet'>DRILL</a>