Relational Drillthrough from Cognos Insight does not work

Post Reply
User avatar
Pim van Putten
Posts: 8
Joined: Thu Nov 13, 2008 4:30 pm

Relational Drillthrough from Cognos Insight does not work

Post by Pim van Putten »

Dear All,

I have a TM1 model in TM1 10.2 FP1 with a relational drillthrough that perfectly works from all interfaces (Cube View, Excel DBRW, TM1 Web) but NOT from Cognos Insight. I can click on the correct drill string via Get Detail, but nothing happens...

I can see in the message log that the drillprocess was correctly executed but the RETURNSQLTABLEHANDLE did not result in the usual popup with the relational data.

Is this a bug? The feature seems to be present as I can click on the correct drill string...
Screenshot of the Relational Drill option in Cognos Insight
Screenshot of the Relational Drill option in Cognos Insight
DrillScreenshot.jpg (167.8 KiB) Viewed 4389 times
Sincerely,

Pim van Putten
r0b1979
Posts: 6
Joined: Wed Aug 01, 2012 9:47 pm
OLAP Product: TM1, SQL Server
Version: 9.5.2
Excel Version: 2007 2010

Re: Relational Drillthrough from Cognos Insight does not wor

Post by r0b1979 »

Hi Pim,

I just encountered the exact same problem, so I was wondering if you by any chance found a cause or solution for this issue?

Best regards,

Rob Elshout
dr.nybble
MVP
Posts: 160
Joined: Wed Aug 17, 2011 3:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2007

Re: Relational Drillthrough from Cognos Insight does not wor

Post by dr.nybble »

Relational drill through is not yet supported in Cognos Insight / TM1 Performance Modeler.
It requires client-side orchestration that is not there yet.
r0b1979
Posts: 6
Joined: Wed Aug 01, 2012 9:47 pm
OLAP Product: TM1, SQL Server
Version: 9.5.2
Excel Version: 2007 2010

Re: Relational Drillthrough from Cognos Insight does not wor

Post by r0b1979 »

I see, thanks for clearing that up. Will look for other options for now.

Regards,
Rob
Post Reply