TM1 Forum

Hi Guys,

Is there a way that I can use Select statement query in Advanced Tab in TI? What I want is for me to be able to modify easily the parameters first before I pass them on the Select query. This is inside a drill-through process, where at the Epilog Tab, a RETURNSQLTABLEHANDLE is executed.

How about ODBCOutput? As far as I know, that's only for updating/inserting data to the database.

Can anyone help.

Thanks.

Bunch

You can basically do whatever you like to modify an SQL query in the prolog of a drill process.

The process will automatically have a parameter created for every dimension in the cube being drilled from which will capture the name of the element at the cell intersection from which the drill is triggered. You can modify the parameter values any way you want (but in a drill process you can't add additional parameters, ... well actually you can but the values won't be recognised).

As there can be quite a bit of asymetry between the cube intersection drilling from and the relational table or query being drilled to it can be very messy mucking around with the parameter values to end up with the desired query. Often or even most of the time it is just easier to parse your query together however you like and then just assign the value DataSourceQuery in one go. If you search the forum for "dataSourceQuery" you should get a godd head start on what you need to do.

Hi! Lotsaram,

Thank you for the information. Now I can combine all drill-through processes into just one TI.
However, on the publib documentation, 'dataSourceQuery' is under TM1 9.4 FP3. What I use now is a 9.4 FP1, so I'm thinking this might not work.
But I will try Lotsaram. Thanks for the information.

Bunch

Hi! Lotsaram,

It does work. Thanks!