TM1 Forum

When you create a drill-through process you can choose between ODBC, View and Other as a datasource.
I tried to use the Other option to create a 'drill-through' process with a None datasource. This process creates a view and fires a process using this view as a datasource.
This way I would like to use the Drill option in a cell to fire a process performing a custom function based on the cell coordinates.
The created option works fine except for the fact that the drill-through functionality appears to expect the return of a handle at the end of the process (throwing an error when no handle is returned). I was hoping that this was not neccessary for the Other datasource option. The documentation is at least weak on this part. Has anyone else tried to use the Drill option this way?
I could setup the process as an ODBC process returning a single column/row table with the value 'close dialog to finish'... but does anyone know a way to prevent the error message from occurring?

Michel

Hi Michel,
Did you try a forcing the exit before the epilog with a processquit or an out and out TI error?

Can't answer your Q directly though.

Cheers

Michel

I use a technique where a want to override the default view, ie the one on the source and return a different view.

I just put an IF statement around the return view handle

IF( 5 = 3) ;

Generated statement with RETURNVIEWHANDLE

ENDIF ;

However, I am surprised that the No source option is still generating a return view handle.

Regards


Paul Simon

I use the same technique as Paul.

PaulSimon wrote:Michel

I use a technique where a want to override the default view, ie the one on the source and return a different view.

I just put an IF statement around the return view handle

IF( 5 = 3) ;

Generated statement with RETURNVIEWHANDLE

ENDIF ;

However, I am surprised that the No source option is still generating a return view handle.

Regards


Paul Simon

Hi Paul,

I'm using 9.5.1 and the Other option is not generating a RETURNVIEWHANDLE statement. So in my process code there is no such statement.
The problem is that when I click Drill from a cell, the process is executed, but ends with the error: "Drill object was successfully built but did not return a valid handle. Check the Message Log". So apparently a process executed through the Drill hook should return a handle, even if the option is Other, using None as a datasource. What I'm looking for is a way to prevent the errormessage from popping up.

Michel

Hi Guys,

I am having exactly same problem as Michel. Did you already find a solution for this?

Mikko

Does any one have this problem, still?. It looks like I may have solution for this and my initial tests were successful so far. Still running more tests.

mathavra wrote:Does any one have this problem, still?. It looks like I may have solution for this and my initial tests were successful so far. Still running more tests.

Please... don't leave us in suspense !