Page 1 of 1

Drill Thru help

Posted: Tue May 19, 2009 7:23 pm
by vish
Hi ,
Just trying to work on the Drill thru using the Developer's guide. Some how my process and Rul are good but still when I right click then "Drill" option is grayed out.

Any ideas ??

Thanks for the help.

-V

Re: Drill Thru help

Posted: Tue May 19, 2009 7:57 pm
by George Regateiro
I would start by

1) Double check the spelling of the drill process name in the rules.
2) Try a very generic assignment rule to make sure that the drill at least shows up
3) Create a testing drill so you can test the logic of your rules. Use the testing drill to catch the false case of your if statements.

If this does not work post out the drill rules that you have, it could spark someone seeing something that you dont see.

Re: Drill Thru help

Posted: Tue May 19, 2009 8:07 pm
by vish
I am using very generic stuff. Just want to make it work, then building blocks.


Process Name : }Drill_DT_TEST

SQL :

select * from dbo.dmn_vendor_pnt_chd
where vendor_child = '?TEST_Vendor?'


RUL :

[]=S:IF( ISLEAF= 1, 'Drill_DT_TEST','');


Thanks for your help.

-V

Re: Drill Thru help

Posted: Tue May 19, 2009 8:12 pm
by George Regateiro
it has been a while since I worked with drills but I am pretty sure the Drill_ was added by TM1. Just try using DT_TEST when you reference the drill in the rules.

Re: Drill Thru help

Posted: Tue May 19, 2009 8:16 pm
by vish
u da MAN :8-)


Damn me....that was simple..

-V