Drill from Cube View to Websheet

Post Reply
wheeler6
Posts: 5
Joined: Sun Jan 17, 2016 3:15 am
OLAP Product: Cognos TM1
Version: 10.2.2 Fix Pack 5
Excel Version: 2010 32 bit

Drill from Cube View to Websheet

Post by wheeler6 » Thu Aug 31, 2017 3:55 pm

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

User avatar
tomok
MVP
Posts: 2318
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

Post by tomok » Thu Aug 31, 2017 4:10 pm

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.

wheeler6
Posts: 5
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

Post by wheeler6 » Thu Aug 31, 2017 4:18 pm

Yeeeep! This is what I was kind of thinking.

Thanks anyways!

Drg
Posts: 53
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

Post by Drg » Wed Sep 13, 2017 8:08 am

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

Code: Select all

<a href='tm1web sheet'>DRILL</a>
to cells

Post Reply